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