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 <ch...@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-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > >