-----------------------------
Please read the FAQ!
<http://java.apache.org/faq/>
-----------------------------
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.
On Tue, 5 Oct 1999, Stan Weinronk wrote:
> -----------------------------
> Please read the FAQ!
> <http://java.apache.org/faq/>
> -----------------------------
>
> Hi
>
> 1) On a similar note, does anyone have a good reference for implementing an
> efficient connection test() call that would work with most DBMS's to test
> that the connection is still valid. Alternatively, does anyone have a list
> of good tests for each major DBMS. I.e.
> Oracle: select sysdate from dual
> DB2: ?
> SYBASE:...
>
> Thanks
>
> Stan Weinronk
>
> ----- Original Message -----
> From: Match Grun <[EMAIL PROTECTED]>
> To: Java Apache Users <[EMAIL PROTECTED]>
> Sent: Tuesday, October 05, 1999 11:18 AM
> Subject: Re: Maintaining a database connection
>
>
> > -----------------------------
> > Please read the FAQ!
> > <http://java.apache.org/faq/>
> > -----------------------------
> >
> > There are two possibilites:
> >
> > 1) Why not write a monitor servlet which periodically uses the
> > connection(s) to execute a query against Oracle's DUAL table?
> > 2) Use connection pooling. Refer to Jason Hunter's book for an
> > example of how to get started. His examples would need more
> > work to keep the connection alive.
> >
> > Match
> >
> [snip]
>
>
>
> --
> --------------------------------------------------------------
> 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]
>
>
--
--------------------------------------------------------------
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]
