tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christopher Schultz <ch...@christopherschultz.net>
Subject Re: Query timeout in dbcp
Date Mon, 01 Jun 2009 21:10:23 GMT
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Arvind,

On 6/1/2009 3:26 PM, S Arvind wrote:
> Is there any possibility to mention max time a query can execute from DBCP
> side?

What do you want to happen after the timeout? The connection execute*
method throws an exception? That is going to be very database-specific.

Martin's response about using removeAbandoned="true" is not going to
help: this will only remove the connection from the connection pool...
it won't interfere with its operation in any way.

Is there some kind of query you can execute on the client side that will
modify the connection properties? You could make that the
"validationQuery" for your connection.

- -chris
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAkokQ78ACgkQ9CaO5/Lv0PD8zgCgsdVaJGsaFkz50mO0nkip/uJb
a3IAnA0W6Unug48rmCs94SYa6L5OkGEy
=1LuH
-----END PGP SIGNATURE-----

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message