for more than just Oracle, try "SELECT 1"
> -----Original Message----- > From: V D [mailto:[EMAIL PROTECTED] > Sent: Saturday, July 17, 2004 7:33 AM > To: Tomcat Users List > Subject: Re: Connection pool detecting bad connection > > > Thank you very much for the information. I wonder what is the > implication of this in term of performance. This effectively > double the > number of query if my query is small and one for each request > to have a > connection handle (but under very heavy load). Also, what's > a generic > way for doing this across other database, for example, MySql, MS Sql, > etc. Also, what if the table does not exist? > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
