tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christopher Schultz <ch...@christopherschultz.net>
Subject Re: DBCP and Firewall timeouts
Date Wed, 01 Jul 2009 20:31:21 GMT
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

David,

On 7/1/2009 10:49 AM, David Smith wrote:
> It would and the performance hit is minimal if you use the ping syntax
> in your validation query.  I believe it looks like this:
> 
> validationQuery="/* ping */ SELECT 1"

Note that both the PING is only applicable for MySQL when using
Connector/J, and "SELECT 1" may only be applicable on certain databases
(MySQL being one of them).

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

iEYEARECAAYFAkpLx5kACgkQ9CaO5/Lv0PCzJgCfQfuVYZtUCmJtWoWUPeVwY4hp
Z6IAn2+/5C4waC3RmiqKeJlPT11w1RpD
=w3h/
-----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