Dear Michael, can I not just add another esql:query before that sets the schema. Something like: <esql:query>set schema development</esql:query> ... <esql:query>THE ACTUAL QUERY</esql:query>
Robert ----- Original Message ----- From: "Michael Mertel" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, January 04, 2003 12:45 PM Subject: AW: DB2 with Cocoon Rob, maybe create alias is your friend ... just create an alias with your development schema for each table, that will work too // // Mit freundlichen Gruessen - Kind regards // Michael Mertel // // Bit World Computing eK // Andreas-Bauer-Strasse 4, 97297 Waldbuettelbrunn, Germany // Phone +49 931 45335 0 - FAX +49 931 45335 99 // http://www.bwc.de // Amtsgericht Wuerzburg HRA 4937 // // one bit ahead ... since 1993 -----Ursprüngliche Nachricht----- Von: Robert Sösemann [mailto:[EMAIL PROTECTED]] Gesendet: Samstag, 4. Januar 2003 12:26 An: [EMAIL PROTECTED]; [EMAIL PROTECTED] Betreff: Re: DB2 with Cocoon Thanks a lot, Michael. But my problem is, that I have to use the given schema "development", because our team works in another schema than the online db (production schema). Is there a chance to set the schema before querying with esql? Thanks in advance. Rob ----- Original Message ----- From: "Michael Mertel" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, January 04, 2003 11:32 AM Subject: AW: DB2 with Cocoon Rob, if there is no schema definition in your query than the username is used, that you used for connecting to the database. Just create the needed tables with this user, then it should match. --Michael -----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]> ---------------------------------------------------------------------------- ---- > --------------------------------------------------------------------- > 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]>
