-----------------------------
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]