You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Daniel John Debrunner (JIRA)" <de...@db.apache.org> on 2006/03/14 03:57:55 UTC

[jira] Created: (DERBY-1111) getStatement() for a ResultSet returned from a procedure in embedded mode must return the Statement that executed the CALL procedure

getStatement() for a ResultSet returned from a procedure in embedded mode must return the Statement that executed the CALL procedure
------------------------------------------------------------------------------------------------------------------------------------

         Key: DERBY-1111
         URL: http://issues.apache.org/jira/browse/DERBY-1111
     Project: Derby
        Type: Bug
    Reporter: Daniel John Debrunner


Currently the getStatement() call for such a ResultSet will return a reference ot the Statement object  that created the ResultSet using server-side JDBC within the procedure. 
SQL Standard 2003, part 13 indicates that a copy of the server-side JDBC ResultSet is made by the database engine as a cursor, and in fact the server-side ResultSet is closed. The cursor would then be returned to the client as for any other cursor, converted to a ResultSet for JDBC.

Derby optimizes this copying by returning the original ResultSet  through the embedded driver, but switching its ownership to the Statement that invokved CALL procedure. This ownership switch however does not switch the application statement returned by getStatement.

See also http://issues.apache.org/jira/browse/DERBY-1101#action_12370189

Fixing this will expose DERBY-1101 in JDBC 4.0


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


[jira] Updated: (DERBY-1111) getStatement() for a ResultSet returned from a procedure in embedded mode must return the Statement that executed the CALL procedure

Posted by "Mike Matrigali (JIRA)" <de...@db.apache.org>.
     [ http://issues.apache.org/jira/browse/DERBY-1111?page=all ]

Mike Matrigali updated DERBY-1111:
----------------------------------

    Component: JDBC
               SQL

> getStatement() for a ResultSet returned from a procedure in embedded mode must return the Statement that executed the CALL procedure
> ------------------------------------------------------------------------------------------------------------------------------------
>
>          Key: DERBY-1111
>          URL: http://issues.apache.org/jira/browse/DERBY-1111
>      Project: Derby
>         Type: Bug

>   Components: JDBC, SQL
>     Reporter: Daniel John Debrunner

>
> Currently the getStatement() call for such a ResultSet will return a reference ot the Statement object  that created the ResultSet using server-side JDBC within the procedure. 
> SQL Standard 2003, part 13 indicates that a copy of the server-side JDBC ResultSet is made by the database engine as a cursor, and in fact the server-side ResultSet is closed. The cursor would then be returned to the client as for any other cursor, converted to a ResultSet for JDBC.
> Derby optimizes this copying by returning the original ResultSet  through the embedded driver, but switching its ownership to the Statement that invokved CALL procedure. This ownership switch however does not switch the application statement returned by getStatement.
> See also http://issues.apache.org/jira/browse/DERBY-1101#action_12370189
> Fixing this will expose DERBY-1101 in JDBC 4.0

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


[jira] Closed: (DERBY-1111) getStatement() for a ResultSet returned from a procedure in embedded mode must return the Statement that executed the CALL procedure

Posted by "Daniel John Debrunner (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-1111?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Daniel John Debrunner closed DERBY-1111.
----------------------------------------

    Resolution: Duplicate

Duplicate of DERBY-3305, changes are being made under that issue.

> getStatement() for a ResultSet returned from a procedure in embedded mode must return the Statement that executed the CALL procedure
> ------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-1111
>                 URL: https://issues.apache.org/jira/browse/DERBY-1111
>             Project: Derby
>          Issue Type: Bug
>          Components: JDBC, SQL
>            Reporter: Daniel John Debrunner
>
> Currently the getStatement() call for such a ResultSet will return a reference ot the Statement object  that created the ResultSet using server-side JDBC within the procedure. 
> SQL Standard 2003, part 13 indicates that a copy of the server-side JDBC ResultSet is made by the database engine as a cursor, and in fact the server-side ResultSet is closed. The cursor would then be returned to the client as for any other cursor, converted to a ResultSet for JDBC.
> Derby optimizes this copying by returning the original ResultSet  through the embedded driver, but switching its ownership to the Statement that invokved CALL procedure. This ownership switch however does not switch the application statement returned by getStatement.
> See also http://issues.apache.org/jira/browse/DERBY-1101#action_12370189
> Fixing this will expose DERBY-1101 in JDBC 4.0

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.