tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christopher Schultz <ch...@christopherschultz.net>
Subject Re: JDBC Pool Disconnections
Date Wed, 06 Apr 2011 21:44:58 GMT
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

הילה,

On 4/6/2011 3:36 PM, הילה wrote:
> I wanted to add it, bu the company that developed the application
> that runs on the tomcat, says that it affect performance and has
> issues.

What is your RDBMS? If it happens to be MySQL, I know that they support
a "ping" query that is very fast. It's much better and faster than
spewing SQLExceptions into your log file.

I would always recommend running with a validationQuery enabled, even if
you have to set a validation interval to reduce the number of
validations that actually occur.

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

iEYEARECAAYFAk2c3tkACgkQ9CaO5/Lv0PBGyACgu1jH9svX+SbIU4ZrvUG63VRD
FnUAoLMOBchXqMmyQRJUHD/G3Dc4ijDP
=vpTh
-----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