Re: maximum open cursors exceeded (with Stored Procedure)

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Mon Feb 07 2005 - 23:03:50 EST

  • Next message: Joel Trunick: "Building with JUnit"

    Davide,

    I just uncovered another resource leak in the Oracle procedure code. So
    here is another patched 1.1. Let me know how this worked.

         http://objectstyle.org/downloads/cayenne/patched/proc/cayenne.jar

    Andrus

    On Feb 7, 2005, at 11:49 AM, Pirola Davide wrote:
    > Hi,
    > i have another problem.
    > If i make a loop (for test) that perform a query(stored procedure with
    > out cursor parameter) and try valorize my java object i get this error
    > (after a few time):
    >
    > -----------------------------------------------------------------
    > INFO QueryLogger: *** error.
    > java.sql.SQLException: Ref cursor is invalid
    > at
    > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
    > at
    > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
    > at
    > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
    > at
    > oracle.jdbc.driver.OracleStatement.getCursorValue(OracleStatement.java:
    > 3847)
    > at
    > oracle.jdbc.driver.OracleStatement.getObjectValue(OracleStatement.java:
    > 6039)
    > at
    > oracle.jdbc.driver.OracleStatement.getObjectValue(OracleStatement.java:
    > 5827)
    > at
    > oracle.jdbc.driver.OracleCallableStatement.getObject(OracleCallableStat
    > ement.java:698)
    > at
    > com.caucho.sql.UserCallableStatement.getObject(UserCallableStatement.ja
    > va:333)
    > at
    > org.objectstyle.cayenne.dba.oracle.OracleDataNode.readStoredProcedureOu
    > tParameters(OracleDataNode.java:138)
    > at
    > org.objectstyle.cayenne.access.DataNode.runStoredProcedure(DataNode.jav
    > a:644)

    This archive was generated by hypermail 2.0.0 : Mon Feb 07 2005 - 23:03:55 EST