Re: [castor-dev] problems with DB2 driver

[Markus Kling]

DB2 does not support the "*=" syntax for outer - joins (which acutally your error-code means).

 

I had a quick look at the Implementation of the JDBC expression. The DB2QueryExpression doesn't overwrite the generation of the sql-clause syntax when using outer-joins. Its just not implemented.

 

If you'd like to send me your mapping and the oql-query, I try to implement a functional version (I just donno when an outer join is generated by the oql-query parser ;-)

 

regards

 - Markus

-----Urspr�ngliche Nachricht-----
Von: Gianmarco Ugolini [mailto:[EMAIL PROTECTED]]
Gesendet: Montag, 8. April 2002 17:18
An: [EMAIL PROTECTED]
Betreff: [castor-dev] problems with DB2 driver

I have some problem running the examples with DB2. DB2 does not accept the SQL string generated by the OQL query. I think my problem depends on driver I use (COM.ibm.db2.jdbc.net.DB2Driver). Any suggestion are welcome.

What drivers do work properly with DB2?

Thanks in advance.

 

Here is the stack trace:

[test] SELECT "prod"."id","prod"."name","prod"."price","prod"."group_id","prod_detail"."id" FROM "prod","pro
d_detail" WHERE "prod"."id"*="prod_detail"."prod_id" AND ("prod"."id" = ?)
Nested error: COM.ibm.db2.jdbc.net.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0727N  An error occurred durin
g implicit system action type "2".  Information returned for the error includes SQLCODE "-104", SQLSTATE "42
601" and message tokens "=|" WHERE "prod"."id"*|<factor>".  SQLSTATE=56098
 while executing SELECT "prod"."id","prod"."name","prod"."price","prod"."group_id","prod_detail"."id" FROM "
prod","prod_detail" WHERE "prod"."id"*="prod_detail"."prod_id" AND ("prod"."id" = ?)

 

---

Do You Yahoo!?
Get personalised at My Yahoo!.