tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christopher Schultz <ch...@christopherschultz.net>
Subject Re: Tomcat Connection Pooling - wait_timeout
Date Mon, 23 Jun 2008 15:30:28 GMT
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Thomas,

Thomas Haines wrote:
| I've used the validation query within the <Resource> as you suggested.
| This has stopped the "first connection after a while is a dead one"
| problem, and all is well in the land of my webapp!

I was reading the changelog for Connector/J this morning (have to see if
5.1.6 will cause us any problems upgrading from 5.0.8) and I saw this in
the 5.0.8 changes:

"
Specifying a "validation query" in your connection pool that starts with
"/* ping */" _exactly_ will cause the driver to instead send a ping to
the server and return a fake result set (much lighter weight), and when
using a ReplicationConnection or a LoadBalancedConnection, will send the
ping across all active connections.
"

So, you might be able to lessen the performance impact of your
velicationQuery queries by using the indicated query which seems a bit
lighter wright.

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

iEYEARECAAYFAkhfwZQACgkQ9CaO5/Lv0PBsVgCgjQIBdGw/DXTcJVTv+Bz2Smzr
blwAn1QgSlCOoaH53JsN5uItgb8amPof
=m07b
-----END PGP SIGNATURE-----

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


Mime
View raw message