Dear Robert, without knowing anything aboout db2 or db schemas - my guess is that this error results from Excalibur sending a "select 1" as a dummy query to the database so the connection doesn't time out.
Try setting oradb to true in your cocoon.xconf where you configured the connection pool. This solved the issue for me (using sapdb). Regards, Nils -----Ursprüngliche Nachricht----- Von: Robert Sösemann [mailto:[EMAIL PROTECTED]] Gesendet: Samstag, 4. Januar 2003 00:12 An: [EMAIL PROTECTED] Betreff: DB2 with Cocoon Hello, this is my first time connecting IBMs DB2 with cocoon. Cocoon succesfully finds the drivers and connects correctly. But I get strange SQL Errors like: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0104N Auf "SELECT 1" folgte das unerwartete Token "END-OF-STATEMENT". Zu den möglichen Token gehören: "<table_expr>". SQLSTATE=42601 Before I used MySQL, which doesn't have something like a db schema. As I know in DB2 you always must set a correct schema before queriing. I guess the problem causes from the fact that I didn't set a schema in my ESQL XSP. But how should I do that?? Who can help me out? Rob --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faq/index.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/faq/index.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>
