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.