cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Robert Sösemann <robert.soesem...@gmx.de>
Subject Re: DB2 with Cocoon
Date Sat, 04 Jan 2003 11:25:54 GMT
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" <michael.mertel@bwc.de>
To: <cocoon-users@xml.apache.org>
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: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: "<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:     <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>





----------------------------------------------------------------------------
----


> ---------------------------------------------------------------------
> 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:     <cocoon-users-unsubscribe@xml.apache.org>
> For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>


---------------------------------------------------------------------
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:     <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>


Mime
View raw message