Alex, Try using the Jdbc2PoolDataSourceFactory instead. There are some known bugs in the TorqueDataSourceFactory. See http://db.apache.org/torque/jdbc2pool-howto.html for configuration details. Also make sure you configure the default datasource and adapter:
torque.database.default=CPMSDEV torque.database.CPMSDEV.adapter=oracle Hope this helps. Tom -----Original Message----- From: Irazabal, Alex [mailto:[EMAIL PROTECTED] Sent: Thursday, July 03, 2003 2:36 PM To: '[EMAIL PROTECTED]' Subject: Oracle config I have looked thru the archives for a valid configuration file for Oracle. Here is what I have and it doesn't seem to work... torque.dsfactory.CPMSDEV.factory=org.apache.torque.dsfactory.TorqueDataSourc eFactory torque.dsfactory.CPMSDEV.pool.defaultMaxConnections=10 torque.dsfactory.CPMSDEV.pool.maxExpiryTime=3600 torque.dsfactory.CPMSDEV.pool.connectionWaitTimeout=10 torque.dsfactory.CPMSDEV.connection.driver = oracle.jdbc.driver.OracleDriver torque.dsfactory.CPMSDEV.connection.url = jdbc:oracle:thin://ETA:1521:CPMSDEV torque.dsfactory.CPMSDEV.connection.user = CPMS_CLAIM_OWNER torque.dsfactory.CPMSDEV.connection.password = CPMS_CLAIM_OWNER And here is the error I get when I run my test: 235 [main] ERROR dsfactory.AbstractDataSourceFactory - Property: driver value: oracle.jdbc.driver.OracleDriver is not supported by DataSource: org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS 235 [main] ERROR dsfactory.TorqueDataSourceFactory - java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39 ) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl .java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.apache.commons.beanutils.PropertyUtils.setSimpleProperty(PropertyUtils.j ava:1650) at org.apache.torque.dsfactory.AbstractDataSourceFactory.setProperty(AbstractDa taSourceFactory.java:121) at org.apache.torque.dsfactory.TorqueDataSourceFactory.initCPDS(TorqueDataSourc eFactory.java:134) at org.apache.torque.dsfactory.TorqueDataSourceFactory.initialize(TorqueDataSou rceFactory.java:108) at org.apache.torque.Torque.initDataSourceFactories(Torque.java:323) at org.apache.torque.Torque.initialize(Torque.java:237) at org.apache.torque.Torque.init(Torque.java:406) at org.apache.torque.Torque.init(Torque.java:386) at com.ai.torque.om.cpmsdevTest.main(cpmsdevTest.java:14) Caused by: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver at java.net.URLClassLoader$1.run(URLClassLoader.java:198) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:186) at java.lang.ClassLoader.loadClass(ClassLoader.java:299) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:265) at java.lang.ClassLoader.loadClass(ClassLoader.java:255) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:315) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:140) at org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS.setDriver(DriverAdapte rCPDS.java:441) ... 13 more 266 [main] ERROR torque.Torque - Any ideas? Alex Irazabal AIGM Distributed Apps 3 Beaver Valley Road Wilmington DE-19803 * (302)-252-4783 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
