Configure your connection pool to use the 'Test On Borrow' feature. This will send a small query out to make user the connection is available before it uses the connection for the larger query. Your query could be like "SELECT 'test' from dual" if you are on Oracle.
Hope this helps Michael -----Original Message----- From: Vy Ho [mailto:[EMAIL PROTECTED] Sent: Friday, July 16, 2004 2:15 PM To: 'Tomcat Users List' Subject: Connection pool detecting bad connection I am sure people with DBCP background would know about this. My question is what is the generic/common/standward JDBC way of check a connection to see if it's a good connection or not. Check thing like: con.isClosed() works in some case, and does not in another case. Would retriveing the metadata do it? What is the implication in term of performance for this? Thanks. --------------------------------------------------------------------- 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]
