I am using 3.1.  I noticed that the DataSourceFactory is deprecated as of
this version.  The note says to use
org.apache.torque.dsfactory.Jdbc2PoolDataSourceFactory which is not in my
torque-3.1.jar file.  I found a javadoc references to it in 3.02, however.
Where do I get this object?

Thanks, Travis

-----Original Message-----
From: Scott Eade [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 04, 2004 5:03 PM
To: Apache Torque Users List
Subject: Re: java.sql.SQLException: invalid arguments in call when
running exa mple


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.TorqueDataSourceFac
tory
> 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(Dr
iverAdapterCPDS.java:205)
>         at 
>
org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS.getPooledConnection(Dr
iverAdapterCPDS.java:175)
>         at 
>
org.apache.torque.pool.ConnectionPool.getNewConnection(ConnectionPool.java:2
54)
>         at 
>
org.apache.torque.pool.ConnectionPool.getConnection(ConnectionPool.java:223)
>         at 
>
org.apache.torque.pool.TorqueClassicDataSource.getConnection(TorqueClassicDa
taSource.java:488)
>         at 
>
org.apache.torque.pool.TorqueClassicDataSource.getConnection(TorqueClassicDa
taSource.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]

Note:  The information contained in this email and in any attachments is
intended only for the person or entity to which it is addressed and may
contain confidential and/or privileged material.  Any review,
retransmission, dissemination or other use of, or taking of any action in
reliance upon, this information by persons or entities other than the
intended recipient is prohibited.  The recipient should check this email and
any attachments for the presence of viruses.  Sender accepts no liability
for any damages caused by any virus transmitted by this email. If you have
received this email in error, please notify us immediately by replying to
the message and delete the email from your computer.  This e-mail is and any
response to it will be unencrypted and, therefore, potentially unsecure.
Thank you.  NOVA Information Systems, Inc.

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to