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!.
