[OS-JIRA] Created: (CAY-271) Oracle Procedure: Ref cursor is invalid

From: jir..bjectstyle.org
Date: Wed Feb 09 2005 - 19:27:36 EST

  • Next message: jir..bjectstyle.org: "[OS-JIRA] Created: (CAY-272) PK generation failure with jTDS driver"

    Message:

      A new issue has been created in JIRA.

    ---------------------------------------------------------------------
    View the issue:

      http://objectstyle.org/jira/secure/ViewIssue.jspa?key=CAY-271

    Here is an overview of the issue:
    ---------------------------------------------------------------------
            Key: CAY-271
        Summary: Oracle Procedure: Ref cursor is invalid
           Type: Bug

         Status: Assigned
       Priority: Major

        Project: Cayenne
     Components:
                 Cayenne Core Library
       Fix Fors:
                 1.1
       Versions:
                 1.1
                 1.2 [DEV]

       Assignee: Andrus Adamchik
       Reporter: Andrus Adamchik

        Created: Wed, 9 Feb 2005 7:27 PM
        Updated: Wed, 9 Feb 2005 7:27 PM

    Description:
    Error when reading out parameters of type ref cursor on Oracle multiple types in a row [http://objectstyle.org/cayenne/lists/cayenne-user/2005/02/0047.html]

    ava.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(OracleCallableStatement.java:698)
            at com.caucho.sql.UserCallableStatement.getObject(UserCallableStatement.java:333)
            at org.objectstyle.cayenne.dba.oracle.OracleDataNode.readStoredProcedureOutParameters(OracleDataNode.java:138)

    Investigation shows that even after fixing CAY-255 there is still some leaks in the stored procedure code...

    ---------------------------------------------------------------------
    JIRA INFORMATION:
    This message is automatically generated by JIRA.

    If you think it was sent incorrectly contact one of the administrators:
       http://objectstyle.org/jira/secure/Administrators.jspa

    If you want more information on JIRA, or have a bug to report see:
       http://www.atlassian.com/software/jira



    This archive was generated by hypermail 2.0.0 : Wed Feb 09 2005 - 19:27:39 EST