db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Charles-Alexandre Sabourdin <kan...@dedaletechnology.com>
Subject DB2 datasource
Date Thu, 18 Dec 2003 08:57:28 GMT
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 Le 
nom "USER.TABLE1" n'est pas défini.  SQLSTATE=42704

while 
SELECT * FROM DB2ADM.Table1 => Works correctly
Here are my Torque.properties

--
torque.applicationRoot=/home/kaneda/java/tomcat
# Sets the driver for the data sources.
torque.defaults.connection.driver=COM.ibm.db2.jdbc.net.DB2Driver

# Sets the URL for the datasources
torque.defaults.connection.url=jdbc:db2://192.168.1.9:6789/TESTUSED

# Sets login and password for the data sources.
torque.defaults.connection.user=user
torque.defaults.connection.password=***

torque.database.TESTUSED.adapter=db2net

## Using commons-dbcp
torque.dsfactory.TESTUSED.factory=org.apache.torque.dsfactory.SharedPoolDataSourceFactory
torque.dsfactory.TESTUSED.connection.driver=COM.ibm.db2.jdbc.net.DB2Driver
torque.dsfactory.TESTUSED.connection.url=jdbc:db2://192.168.1.9:6789/TESTUSED
# This works correctly
#torque.dsfactory.TESTUSED.connection.user=db2adm
#torque.dsfactory.TESTUSED.connection.password=*****
torque.dsfactory.TESTUSED.connection.user=user
torque.dsfactory.TESTUSED.connection.password=*****



-- 
Charles-Alexandre
SABOURDIN
-----------------


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message