Message:
A new issue has been created in JIRA.
---------------------------------------------------------------------
View the issue:
http://objectstyle.org/jira/secure/ViewIssue.jspa?key=CAY-160
Here is an overview of the issue:
---------------------------------------------------------------------
Key: CAY-160
Summary: Improved handling of database reconnects
Type: Improvement
Status: Assigned
Priority: Major
Project: Cayenne
Components:
Cayenne Core Library
Fix Fors:
1.1 [DEV]
Versions:
1.1 [DEV]
Assignee: Andrus Adamchik
Reporter: Mike Kienenberger
Created: Wed, 7 Jul 2004 6:48 PM
Updated: Wed, 7 Jul 2004 6:48 PM
Environment: Oracle 9i 9.2.0.5
Description:
Cayenne fails to reconnect after an Oracle 9i 9.2.0.5 database reboot.
This patch appears to fix the problem by closing the PooledConnection then re-attempting PooledConnection.getConnection() once more when an SQLException is thrown during PooledConnection.getConnection() from PoolManager.getConnection().
Unfortunately, my understanding of connection pooling is basic, so I don't know if this may have unintended side-effects, but the idea seems sound.
I made the change in both places where PooledConnection.getConnection() is called from PoolManager.getConnection().
I'm not sure whether it might make more sense to rethrow the original pre-closed-connection exception if the exception happens a second time.
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://objectstyle.org/jira/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
This archive was generated by hypermail 2.0.0 : Wed Jul 07 2004 - 18:49:47 EDT