Re: Database reconnect support? [Oracle 9i]

From: Mike Kienenberger (mkienen..laska.net)
Date: Mon Jul 05 2004 - 15:09:18 EDT

  • Next message: Andrus Adamchik: "Re: postgresql "TABLENAME" versus TABLENAME"

    Status:
    X-Status:

    Andrus Adamchik <andru..bjectstyle.org> wrote:
    > IIRC my earlier tests with Oracle showed that reconnect worked on certain
    > errors, but not all
    > (http://objectstyle.org/cayenne/faq/deploy.html#reconnect). I guess better
    > reconnect support may require wrapping more of JDBC classes with custom
    > implementations (not only the Connection).

    I somehow missed that, but our situation is that the Oracle DB is being
    restarted rather than the connection being lost.

    > BTW, are you using Cayenne connection pool or something like commons-dbcp?
    > I believe DBCP wraps things like PreparedStatements, etc., so it can do
    > the reconnect in more deeply nested cases.

    I'm using whatever Cayenne defaults to. :)

    I will take a look at DBCP if that seems more likely to handle this case.

    I will also try to see if I can't determine the actual error returned when
    this happens.

    Thanks!

    This archive was generated by hypermail 2.0.0 : Mon Jul 05 2004 - 15:08:59 EDT