-----------------------------
Please read the FAQ!
<http://java.apache.org/faq/>
-----------------------------

Alex Shneyderman wrote:
> 
> As to efficient connection test call -  there is Connection.isClosed()
> method in JDBC. This is not DBMS dependent method, but rather, driver
> dependent, so before relying on it you should check your driver docs.
> 

To my experience this does not work on connections which have been
terminated by timing out or being interrupted by a router.
We use a select count(*) from a table we use in our application.
Donīt know if getMetaData wouldwork on all databases.

Stefan


--
--------------------------------------------------------------
Please read the FAQ! <http://java.apache.org/faq/>
To subscribe:        [EMAIL PROTECTED]
To unsubscribe:      [EMAIL PROTECTED]
Archives and Other:  <http://java.apache.org/main/mail.html>
Problems?:           [EMAIL PROTECTED]

Reply via email to