db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Scott Eade <se...@backstagetech.com.au>
Subject Re: java.sql.SQLException: invalid arguments in call when running exa mple
Date Wed, 04 Feb 2004 22:02:52 GMT
What version of Torque are you using?  If it is 3.1 you should move to 
one of the new DataSourceFactories and then try and sort your problem out.

Scott

-- 
Scott Eade
Backstage Technologies Pty. Ltd.
http://www.backstagetech.com.au



Travis.Prescott@novainfo.com wrote:

> I am connecting to an Oracle db but I get the following exception.  
> What I don't understand is that I am able to build the Torque objects 
> and dynamically generate the database with this below properties so 
> why won't it save a record?.  My torque.properties file looks like this:
>  
> torque.database.default=emt
> torque.dsfactory.emt.adapter=oracle
> torque.dsfactory.emt.factory=org.apache.torque.dsfactory.TorqueDataSourceFactory
> torque.dsfactory.emt.pool.defaultMaxConnections=10
> torque.dsfactory.emt.pool.maxExpiryTime=3600
> torque.dsfactory.emt.pool.connectionWaitTimeout=10
> torque.dsfactory.emt.connection.driver=oracle.jdbc.driver.OracleDriver
> torque.dsfactory.emt.connection.url=jdbc:oracle:thin:@myserver.com:1521:RD01
> torque.dsfactory.emt.connection.username=*********
> torque.dsfactory.emt.connection.password=*********
>  
>  
> java.sql.SQLException: invalid arguments in call
>         at 
> oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
>         at 
> oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
>         at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1160)
>         at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:184)
>         at 
> oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:360)
>         at 
> oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:521)
>         at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:325)
>         at java.sql.DriverManager.getConnection(DriverManager.java:512)
>         at java.sql.DriverManager.getConnection(DriverManager.java:171)
>         at 
> org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS.getPooledConnection(DriverAdapterCPDS.java:205)
>         at 
> org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS.getPooledConnection(DriverAdapterCPDS.java:175)
>         at 
> org.apache.torque.pool.ConnectionPool.getNewConnection(ConnectionPool.java:254)
>         at 
> org.apache.torque.pool.ConnectionPool.getConnection(ConnectionPool.java:223)
>         at 
> org.apache.torque.pool.TorqueClassicDataSource.getConnection(TorqueClassicDataSource.java:488)
>         at 
> org.apache.torque.pool.TorqueClassicDataSource.getConnection(TorqueClassicDataSource.java:458)
>         at 
> org.apache.torque.TorqueInstance.getConnection(TorqueInstance.java:743)
>         at org.apache.torque.Torque.getConnection(Torque.java:306)
>         at 
> org.apache.torque.util.Transaction.beginOptional(Transaction.java:118)
>         at org.apache.torque.util.Transaction.begin(Transaction.java:100)
>         at com.novainfo.emt.dao.BasePublisher.save(BasePublisher.java:490)
>         at com.novainfo.emt.dao.BasePublisher.save(BasePublisher.java:471)
>         at com.novainfo.emt.test.TestTorque.go(TestTorque.java:31)
>         at com.novainfo.emt.test.TestTorque.main(TestTorque.java:13)
>


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message