Hi Andrus,
the patch works fine!!
Thank's for your help :)
Davide
-----Original Message-----
From: Andrus Adamchik [mailto:andru..bjectstyle.org]
Sent: marted́ 8 febbraio 2005 5.04
To: cayenne-use..bjectstyle.org
Subject: Re: maximum open cursors exceeded (with Stored Procedure)
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 : Wed Feb 09 2005 - 03:49:45 EST