Hi, thanks for that quick reply. Isn't the maxWait parameter only setting the pool's timeout while trying to acquire a new connection?
What I need is setting the aquired connection's timeout to some 30 seconds or so... (Actually, in plain java I would go like connection->statement.setQueryTimeout()), but I dont want to set this on each connection etc. Is that any clearer? Thanks, Tino Sperlich -----Urspr�ngliche Nachricht----- Von: "G�schl,Siegfried" [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 16. Juli 2004 13:43 An: Apache Torque Users List Betreff: RE: How to set a pooled connection's timeout 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
