I checked the docs, you are right ... And I don't know any more than you
Siegfried Goeschl
-----Original Message-----
From: Sperlich, Tino [mailto:t.sperlich@hpc-hamburg.de]
Sent: Freitag, 16. Juli 2004 13:49
To: Apache Torque Users List
Subject: AW: How to set a pooled connection's timeout
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:Siegfried.Goeschl@drei.com]
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:t.sperlich@hpc-hamburg.de]
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: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
|