RE: Reset Cayenne Connection Pool

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Thu Apr 07 2005 - 14:45:55 EDT

  • Next message: Mike Kienenberger: "Re: Reset Cayenne Connection Pool"

    I see.. Yeah, PoolManager can't reconnect on errors inside
    PreparedStatements, as it only wraps Connections, but not Statements... I
    think DBCP should be able to do it though. Try it out.

    Andrus

    > Caused by: java.sql.SQLException:
    > ORA-04068: existing state of packages has been discarded ORA-04061:
    > existing state of package "MEMBERSHIP.BAS" has been invalidated
    > ORA-04065: not executed, altered or dropped package "MEMBERSHIP.BAS"
    > ORA-06508: PL/SQL: could not find program unit being called
    > ORA-06512: at line 1
    > at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at
    > oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) at
    > oracle.jdbc.ttc7.Oall7.receive(Oall7.java:582) at
    > oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1986) at
    > oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1144) at
    > oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2152) at
    > oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2035) at
    > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2876) at
    > oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:609) at
    > oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:685) at
    > org.objectstyle.cayenne.access.DataNode.runStoredProcedure(DataNode.java:641) at
    > org.objectstyle.cayenne.access.DataNode.performQueries(DataNode.java:345) ...



    This archive was generated by hypermail 2.0.0 : Thu Apr 07 2005 - 14:45:56 EDT