yuo're right the validationQuery is done before every query. but is implemented any keepalive protocol to mantain a persistent connection (i guess no)
----- Original Message ----- From: "Boris Folgmann" <[EMAIL PROTECTED]> To: "Tomcat Users List" <[EMAIL PROTECTED]> Sent: Wednesday, January 29, 2003 3:55 PM Subject: Re: Can the JNDI Connection Pool re-connect after failure? > Ryan Cornia wrote: > > This solution seems to work great for me. After adding this and > > re-booting the database server, it re-connected and worked great > > automatically!!!! > > Same for me. It works too with postgresql. It would be interesting to know > how big the overhead is for this check. Is the check done before EVERY > query? Anyway, I used an even simpler <value>SELECT 1;</value> which does > not need to read any table but returns a row as requested in the Javadoc. > > cu, > boris > > -- > Dipl.-Inf. Boris Folgmann mailto:[EMAIL PROTECTED] > Folgmann IT-Consulting http://www.folgmann.de > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
