java.sql.SQLException: invalid arguments in=20 call
        at=20 oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
&nbs= p;      =20 at=20 oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
&nbs= p;      =20 at=20 oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1160)
&nb= sp;     =20 at=20 oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:184)
&nbs= p;     =20 at=20 oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:3= 60)
       =20 at=20 oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:= 521)
       =20 at=20 oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:325)
=       =20 at=20 java.sql.DriverManager.getConnection(DriverManager.java:512)
&n= bsp;     =20 at=20 java.sql.DriverManager.getConnection(DriverManager.java:171)
&n= bsp;     =20 at=20 org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS.getPooledConnectio= n(DriverAdapterCPDS.java:205)
      &nb= sp;=20 at=20 org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS.getPooledConnectio= n(DriverAdapterCPDS.java:175)
      &nb= sp;=20 at=20 org.apache.torque.pool.ConnectionPool.getNewConnection(ConnectionPool.ja= va:254)
       =20 at=20 org.apache.torque.pool.ConnectionPool.getConnection(ConnectionPool.java:= 223)
       =20 at=20 org.apache.torque.pool.TorqueClassicDataSource.getConnection(TorqueClass= icDataSource.java:488)
       =20 at=20 org.apache.torque.pool.TorqueClassicDataSource.getConnection(TorqueClass= icDataSource.java:458)
       =20 at=20 org.apache.torque.TorqueInstance.getConnection(TorqueInstance.java:743)<= BR>       =20 at=20 org.apache.torque.Torque.getConnection(Torque.java:306)
  &= nbsp;    =20 at=20 org.apache.torque.util.Transaction.beginOptional(Transaction.java:118)       =20 at=20 org.apache.torque.util.Transaction.begin(Transaction.java:100)
=       =20 at=20 com.novainfo.emt.dao.BasePublisher.save(BasePublisher.java:490)
= ;      =20 at=20 com.novainfo.emt.dao.BasePublisher.save(BasePublisher.java:471)
= ;      =20 at=20 com.novainfo.emt.test.TestTorque.go(TestTorque.java:31)
  &= nbsp;    =20 at = com.novainfo.emt.test.TestTorque.main(TestTorque.java:13)<= /DIV>

-----Original Message-----
From: Moore, Richard=20 [mailto:Richard.Moore@logistics.nhs.uk]
Sent: Wednesday, = February=20 04, 2004 6:59 AM
To: = torque-user@db.apache.org
Subject:=20 cannot use 2 connections

Hello,

I am using=20 jetspeed/turbine/torque, my default connection works fine but I am = having a=20 problem using a second connection. My Torque.properties contains=20 :

torque.database.default=3Ddefault

###=20 = torque.database.default.adapter=3Dhypersonic
torque.database.default.adapter=3Dmysql<= /P>
torque.database.trdb.adapter=3Doracle
###=20 torque.database.default.adapter=3Dmssql

##

## Using torque's old=20 pool

##

###=20 torque.dsfactory.default.connection.driver =3D=20 org.hsqldb.jdbcDriver

###=20 torque.dsfactory.default.connection.url =3D=20 = jdbc:hsqldb:${webappRoot}/WEB-INF/db/jetspeed
###=20 torque.dsfactory.default.connection.user =3D sa =

###=20 torque.dsfactory.default.connection.password =3D =

torque.dsfactory.default.factory=3Dorg.apache.torque.dsfactory.To= rqueDataSourceFactory

# The number of = database=20 connections to cache per ConnectionPool instance (specified per=20 database)

torque.dsfactory.default.pool.defaultMaxConnections=3D10

torque.dsfactory.default.pool.maxExpiryTime=3D3600

torque.dsfactory.default.pool.connectionWaitTimeout=3D10

###=20 MySQL

torque.dsfactory.default.connection.driver=20 =3D org.gjt.mm.mysql.Driver

torque.dsfactory.default.connection.url=20 =3D jdbc:mysql://localhost:3306/turbine

torque.dsfactory.default.connection.user=20 =3D ****

torque.dsfactory.default.connection.password=20 =3D ****

torque.dsfactory.trdb.factory=3Dorg.apache.torque.dsfactory.Torqu= eDataSourceFactory

# The number of = database=20 connections to cache per ConnectionPool instance (specified per=20 database)

torque.dsfactory.trdb.pool.defaultMaxConnections=3D10<= /SPAN>

torque.dsfactory.trdb.pool.maxExpiryTime=3D3600=

torque.dsfactory.trdb.pool.connectionWaitTimeout=3D10<= /SPAN>

###=20 Oracle

torque.dsfactory.trdb.connection.driver=3Doracle.jdbc.driver.Orac= leDriver

torque.dsfactory.trdb.connection.url=3Djdbc:oracle:thin:@194.155.= 160.252:1521:TRDB

torque.dsfactory.trdb.connection.username=3D****

torque.dsfactory.trdb.connection.password=3D****

When I try and get a = connection to=20 trdb from my portlet, I get the following error = :

There was no = DataSourceFactory=20 configured for the connection trdb

java.lang.NullPointerException:=20 There was no DataSourceFactory configured for the connection=20 trdb

I cannot figure this = out – any=20 ideas?

Many=20 thanks,

Richard.

This=20 e-mail and any attachments hereto are: -strictly confidential and = intended=20 solely for the addressee. If you are not the intended addressee, you = must not=20 disclose, forward, copy, or take any action in reliance on this = e-mail or=20 attachments. If you have received this e-mail in error, please notify = NHS=20 Logistics sender as soon as possible. -not intended to create = contractual=20 relations or legal obligations binding on NHS Logistics and no action = may be=20 taken in reliance on this e-mail and any attachments hereto unless = the=20 contents are confirmed by letter. Addressees should check all = attachments for viruses. NHS Logistics makes no representations as regards the = absence of=20 viruses in attachments to this e-mail.

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.

------_=_NextPart_001_01C3EB2A.24C6FBC0-- ------=_NextPartTM-000-8485b397-efe8-460e-9e80-79ccfefdc7b9 Content-Type: text/plain; charset=us-ascii --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org ------=_NextPartTM-000-8485b397-efe8-460e-9e80-79ccfefdc7b9--