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