RE: maximum open cursors exceeded (with Stored Procedure)

From: Pirola Davide (davide.pirol..tin.it)
Date: Fri Feb 04 2005 - 09:45:41 EST

  • Next message: Andrus Adamchik: "Re: flattened relations intermediate table records not deleted with cascade"

    Hi,
    as usually yours suggests are great!

    Thank's
    Davide

    -----Original Message-----
    From: Andrus Adamchik [mailto:andru..bjectstyle.org]
    Sent: venerd́ 4 febbraio 2005 15.28
    To: cayenne-use..bjectstyle.org
    Subject: Re: maximum open cursors exceeded (with Stored Procedure)

    Hi Davide,

    It's a bug - http://objectstyle.org/jira/secure/ViewIssue.jspa?key=CAY-255

    You can download patched 1.1 jar from here:

    http://objectstyle.org/downloads/cayenne/patched/CAY-255/cayenne.jar

    Andrus

    > Hi,
    > i have found this error when i execute my code in a loop.
    > I must close open cursors?
    > Where i can make this?
    >
    > Thank's
    > Davide
    >
    > -------------------------------------------------------------------------------------------
    > INFO QueryLogger: *** error.
    > java.sql.SQLException: ORA-01000: maximum open cursors exceeded
    > ORA-06512: at "AUTHORIZATION_MANAGER.AUTHORIZATION", line 926
    > 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:640)
    > .....
    > -------------------------------------------------------------------------------------------

    This archive was generated by hypermail 2.0.0 : Fri Feb 04 2005 - 09:47:42 EST