I understand that--my app does "close" connections (release back to the
pool). The problem is that the pool itself maintains open connections to
the database, and doesn't seem to recover very well when the databsae dies
and comes back.
-jason
[EMAIL PROTECTED]
08/02/2001 11:31 AM
Please respond to struts-user
To: [EMAIL PROTECTED]
cc:
Subject: RE: DataSource timeouts?
in the documentation it says that you close the connection after you have
used it...
ie.
conn.close();
this wont close the connection but will release it for others to use...
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 02, 2001 5:07 PM
To: [EMAIL PROTECTED]
Subject: DataSource timeouts?
Is there any parameter that can be set to timeout datasources, or to
re-init them after a specified period of time? We recently bounced our
Oracle database that our struts connection pool points to, and I noticed
that all the connections had hung (the app just hung while trying to
perform queries). The only way to fix it (that I knew of) was to restart
the servlet container. Is there a better way around this?
Thnaks,
Jason
------------------------------------------------------------------------------
The information in this Internet email is confidential and may be
legally privileged. It is intended solely for the addressee. Access
to this Internet email by anyone else is unauthorised.
If you are not the intended recipient, any disclosure, copying,
distribution
or any action taken or omitted to be taken in reliance on it, is
prohibited
and may be unlawful. When addressed to our clients any opinions or advice
contained in this Internet email are subject to the terms and conditions
expressed in any applicable governing ING Barings' terms of business or
client engagement letter.
Visit us at www.ingbarings.com
------------------------------------------------------------------------------