[OS-JIRA] Created: (CAY-160) Improved handling of database reconnects

From: jir..bjectstyle.org
Date: Wed Jul 07 2004 - 18:49:46 EDT

  • Next message: jir..bjectstyle.org: "[OS-JIRA] Created: (CAY-161) Modeler exception thrown during eomodel import"

    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