You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-user@db.apache.org by "Sperlich, Tino" <t....@hpc-hamburg.de> on 2004/07/16 13:31:08 UTC
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: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org