Re: DB2 datasource

2003-12-18 Thread Michael Della Bitta
i think the problem is that DB2 assumes the schema = the username if none is provided in the sql. so you're creating all your tables under schema DB2ADM, and trying to access them as if they were in schema USER. i'm unaware of the support for database schemas in Torque. i seem to remember

DB2 datasource

2003-12-18 Thread Charles-Alexandre Sabourdin
Probleme with datasource and maybe SQL: Hello, I have the following problems : Basically I use two different users 1 for administating (user=db2adm) and one only has a reader (user=user). note : SELECT * FROM Table1 => Error: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/LINUX] SQL0204N