Re: java.sql.SQLException: invalid arguments in call when running exa mple

[Scott Eade]

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


[EMAIL PROTECTED] 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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]