Hi Christopher,
now it works...
...after i restarted tomcat and apache and then my server :-] it works...i
dont know why...
on the same day i got the errormessage that the code cannot be compiled and
since that errormessage nothing worked anymore...because of this i restarted
everything...mybe there is a context between both events...???
sorry for the excitement i produced with my question...
cu,
christian
Am Freitag, 26. Oktober 2001 16:49 schrieben Sie:
Christian,
I can't see anything wrong, but you've not shown us all your code. Also,
we have no way of verifying that your column and table names match your
database. One reason it is hard to debug ESQL is because all exceptions
get trapped and turned into generic exceptions, so you don't know what
actual issue the JDBC driver or database is complaining about. You should
first ensure your queries work outside Cocoon (e.g., type them into a query
tool and see if they blow up). You can also try building up from simple
queries that work, adding to them in small increments, e.g., one WHERE
condition at a time and so forth. That should help you find what bit is
causing the trouble.
If you want to see what JDBC is really complaining about, you'll have to
hack the esql.xsl logicsheet to re-throw the JDBC exceptions instead of
substituting generic exceptions.
-Christopher
Please respond to [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
cc:
Subject: SQL-Statment with two (or more) where statments
Hi,
i use cocoon1.8.2. Now i have a little problem:
i want to query my db like this:
esql:connect
...
esql:connect
...
SELECT
a.name
FROM
a, b
WHERE
b.fk2 = a.pk
AND
b.fk1 = esql:parameter type=string
esql:get-string ancestor=1 column=fk_x/ /esql:parameter
...
/esql:connection
/esql:connection
But i get the errormessage:
Error executed prepared statement: SELECT a.name FROM a, b WHERE b.fk2 =
a.pk
AND b.fk1 = ?
When i only use one where statment it works, but with 2 it wount
What must i change ?
cu
Christian
-
Please check that your question has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faqs.html
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
Please check that your question has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faqs.html
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]