-----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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
