Hi Tino,

I use torque.dsfactory.???.pool.maxWait=10000

Cheers,

Siegfried Goeschl

-----Original Message-----
From: Sperlich, Tino [mailto:[EMAIL PROTECTED] 
Sent: Freitag, 16. Juli 2004 13:31
To: Apache Torque Users List
Subject: How to set a pooled connection's timeout


Hi,

how may I set the query time-out for a connection,
i.e. the time it waits for locks in the DB before throwing
an exception?

My torque.properties is:

torque.database.btos.adapter=oracle
## Using commons-dbcp 
torque.dsfactory.btos.factory=org.apache.torque.dsfactory.SharedPoolDataSourceFactory
torque.dsfactory.btos.pool.maxActive=5
torque.dsfactory.btos.pool.testOnBorrow=true
torque.dsfactory.btos.pool.validationQuery=SELECT COUNT(*) FROM DUAL 
torque.dsfactory.btos.connection.driver = oracle.jdbc.driver.OracleDriver 
torque.dsfactory.btos.connection.url = jdbc:oracle:thin:@yyyyyy 
torque.dsfactory.btos.connection.user = USER torque.dsfactory.btos.connection.password 
= passwd

Thank you,

Tino Sperlich

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


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

Reply via email to