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>