Hey, I use Tomcat's JDBC pool (tomcat-jdbc.jar) sorry, I haven't quite understood why shouldn't I use the ValidationInterval="30000" (30 seconds) string on my configuration.. On tomcat's documentation, it says that testonborrow=true and validationQuery=SELECT 1 were part of the DBCP , and the ValidationInterval=30000 is introduced in the Tomcat's JDBC pool.
Thanks Hils 2011/6/6 Christopher Schultz <ch...@christopherschultz.net> > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > הילה, > > On 6/6/2011 9:56 AM, הילה wrote: > > I've set testonborrow, validationquery and validationinterval - and it > did > > the trick. After ESX migration or just disconnect and reconnect of the > > network card, the application recovers by itself. > > Note that "validationInterval" is not a valid configuration option (if > you're talking about DBCP... sorry, I can't keep track of your > configuration... are you using DBCP or Tomcat's new, semi-experimental > pool?). > > If you're using DBCP, you should really read this page in it's entirety: > > http://commons.apache.org/dbcp/configuration.html > > If you are using Tomcat's pool, you should read the documentation that > comes with it. > > Any type of "interval" setting is likely to create a background thread > that monitors the connections and tests them periodically. > > Unless you have a very strict response-time metric that you are trying > to hit, I would stick with testOnBorrow="true" (along with an innocuous > validationQuery) and leave everything else alone. > > - -chris > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.10 (MingW32) > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ > > iEYEARECAAYFAk3s5cgACgkQ9CaO5/Lv0PCLgQCfTA/5t1Rr2uJegTtZf+btaJgC > otMAn0ixB0LEoO0TSBRAUF4QE9Ssv1+S > =b247 > -----END PGP SIGNATURE----- > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > >
