You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@turbine.apache.org by Marshall Casey-ra9569 <Ca...@motorola.com> on 2002/05/14 16:46:11 UTC
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
RE: Problems with standalone Torque in 3.0-b2
Posted by Age Mooy <am...@home.nl>.
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:Casey.Marshall@motorola.com]
> Sent: Tuesday, May 14, 2002 16:46
> To: turbine-user@jakarta.apache.org
> 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: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>