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 Thu, 02 Jul 2009 13:38:58 GMT
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

David,

On 7/1/2009 5:01 PM, David Smith wrote:
> Christopher Schultz wrote:
>> 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).
>>
> Right and I double checked the original post that started this thread. 
> AD described the environment as having MySQL 5.1

Apologies... the thread was broken somewhere along the way and the
original message wasn't grouped with the others in my mail reader. The
OP definitely said they were using MySQL 5.1.

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

iEYEARECAAYFAkpMuHIACgkQ9CaO5/Lv0PADewCfVnBaTKaGS/bnDm7DZiWkTj8x
7JgAoMOO3vwM7gzLQXz8fWpGutVBclDR
=mPNr
-----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