tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From הילה <hilavalen...@gmail.com>
Subject Re: JDBC Pool Disconnections
Date Fri, 08 Apr 2011 10:14:43 GMT
What is RDBMS? I tried to google it, but haven't quite figure it out.
as mentioned, we're using SQL server 2008, latest SP.

And I will add the strings of validationQuery and validationInterval. :]

Thanks
Hila


2011/4/7 Christopher Schultz <chris@christopherschultz.net>

> -----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
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message