Return-Path: Delivered-To: apmail-xml-cocoon-users-archive@xml.apache.org Received: (qmail 25107 invoked by uid 500); 5 Jan 2003 21:39:59 -0000 Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: list-post: Reply-To: cocoon-users@xml.apache.org Delivered-To: mailing list cocoon-users@xml.apache.org Received: (qmail 25091 invoked from network); 5 Jan 2003 21:39:58 -0000 Message-ID: <004001c2b502$c251fbb0$e4a1fea9@webspace> From: =?iso-8859-1?Q?Robert_S=F6semann?= To: References: <001001c2b3fd$7c882470$0d0110ac@TINYTIM> Subject: Re: DB2 with Cocoon Date: Sun, 5 Jan 2003 14:27:15 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N Thanks for answering. Could you send me the relevant parts of your xconf because I am not sure where to add the oradb attribute. By the way the comments in my xconf say to do this only for ORACLE ?!! And why do you think, that Cocoon sends dummy queries? To hold the pool? Or do you think I made something wrong with the driver? I have no error in the logs before. Thank you very much, Robert ----- Original Message ----- From: "Nils Le�mann" To: Sent: Saturday, January 04, 2003 3:27 PM Subject: AW: DB2 with Cocoon 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:robert.soesemann@gmx.de] Gesendet: Samstag, 4. Januar 2003 00:12 An: cocoon-users@xml.apache.org 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: "". 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. To unsubscribe, e-mail: For additional commands, e-mail: --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. To unsubscribe, e-mail: For additional commands, e-mail: --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. To unsubscribe, e-mail: For additional commands, e-mail: