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


Hi,
On Tue, 14 Sep 1999, Craig R. McClanahan wrote:
CRM| that the connection at the "bottom" of the stack was used pretty rarely.  It
CRM| seems that Oracle SQL*Net will sometimes disconnect a long-lived connection
CRM| that hasn't been accessed for a significant amount of time, which caused a
CRM| problem for the next user that I eventually allocated that connection to.

So I've written a wrapper around a (Oracle-)Connection which can be asked
for Statements etc. Before each action, it makes a quick check if the
connection is still alive and makes a reconnect if not.

These Connectionwrappers are itself stored in a (fifo-)connection pool.
This seems to be very stable.

ciao,
  -hen
---
Henner Zeller                                 [EMAIL PROTECTED]
 PGP pub key [77F75B39]: finger [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]

Reply via email to