That looks like a typical "forgot to copy the jdbc driver" error message... is the the oracle jdbc driver jar file in the appropriate lib directory ?
Age > -----Original Message----- > From: Marshall Casey-ra9569 [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, May 14, 2002 16:46 > To: [EMAIL PROTECTED] > Subject: Problems with standalone Torque in 3.0-b2 > > > I am evaluating Torque as an ORM solution for a standalone > (non-Turbine) application. I am able to import the schema from > an existing database, generate the Java classes, and everything > compiles fine. However, I cannot get a simple test application > to run, I get an exception "java.sql.SQLException: No suitable driver". > > I know that I am using the correct URL, username, password, > schema name because they work with the project-jdbc target. What > is wrong with my configuration? > > Thanks, > Casey > > Here is a dump of the configuration object that Torque is using > (printed out at runtime by iterating thru the Configuration object): > > Reading properties from myapp.properties > applicationRoot = . > database.default = myapp > database.default.driver = oracle.jdbc.driver.OracleDriver > database.default.url = jdbc:oracle:thin:@dbserver:1521:SCOTTDB > database.default.username = scott > database.default.password = tiger > database.default.schema = SCOTT > database.adapter = DBOracle > database.adapter.DBOracle = oracle.jdbc.driver.OracleDriver > database.myapp.driver = oracle.jdbc.driver.OracleDriver > database.myapp.url = jdbc:oracle:thin:@dbserver:1521:SCOTTDB > database.myapp.username = scott > database.myapp.password = tiger > database.myapp.schema = SCOTT > database.default.maxConnections = 80 > database.default.expiryTime = 3600000 > database.connectionWaitTimeout = 10000 > database.logInterval = 0 > idbroker.cleverquantity = true > idbroker.prefetch = true > idbroker.usenewconnection = true > > Here is the stack trace I get: > > java.sql.SQLException: No suitable driver > at java.sql.DriverManager.getConnection(DriverManager.java:532) > at java.sql.DriverManager.getConnection(DriverManager.java:171) > at org.apache.torque.adapter.DB.getConnection(Unknown Source) > at > org.apache.torque.pool.ConnectionPool.getNewConnection(Unknown Source > ) > at > org.apache.torque.pool.ConnectionPool.getConnection(Unknown Source) > at org.apache.torque.Torque.getConnection(Unknown Source) > at org.apache.torque.util.BasePeer.executeQuery(Unknown Source) > at org.apache.torque.util.BasePeer.doSelect(Unknown Source) > at > omniscience.om.BaseMIRPeer.doSelectVillageRecords(BaseMIRPeer.java:48 > 5) > at > omniscience.om.BaseMIRPeer.doSelectVillageRecords(BaseMIRPeer.java:45 > 5) > at omniscience.om.BaseMIRPeer.doSelect(BaseMIRPeer.java:433) > at omniscience.om.Test.main(Test.java:26) > rethrown as org.apache.torque.TorqueException: No suitable driver > at org.apache.torque.Torque.getConnection(Unknown Source) > at org.apache.torque.util.BasePeer.executeQuery(Unknown Source) > at org.apache.torque.util.BasePeer.doSelect(Unknown Source) > at > omniscience.om.BaseMIRPeer.doSelectVillageRecords(BaseMIRPeer.java:48 > 5) > at > omniscience.om.BaseMIRPeer.doSelectVillageRecords(BaseMIRPeer.java:45 > 5) > at omniscience.om.BaseMIRPeer.doSelect(BaseMIRPeer.java:433) > at omniscience.om.Test.main(Test.java:26) > Caused by: java.sql.SQLException: No suitable driver > at java.sql.DriverManager.getConnection(DriverManager.java:532) > at java.sql.DriverManager.getConnection(DriverManager.java:171) > at org.apache.torque.adapter.DB.getConnection(Unknown Source) > at > org.apache.torque.pool.ConnectionPool.getNewConnection(Unknown Source > ) > at > org.apache.torque.pool.ConnectionPool.getConnection(Unknown Source) > ... 7 more > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
