db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel John Debrunner (JIRA)" <derby-...@db.apache.org>
Subject [jira] Assigned: (DERBY-1158) Allow use of Statements created in local transaction with default holdability to be used in global transactions.
Date Tue, 28 Mar 2006 19:13:33 GMT
     [ http://issues.apache.org/jira/browse/DERBY-1158?page=all ]

Daniel John Debrunner reassigned DERBY-1158:
--------------------------------------------

    Assign To: Daniel John Debrunner

> Allow use of Statements created in local transaction with default holdability to be used
in global transactions.
> ----------------------------------------------------------------------------------------------------------------
>
>          Key: DERBY-1158
>          URL: http://issues.apache.org/jira/browse/DERBY-1158
>      Project: Derby
>         Type: Improvement
>   Components: JDBC, Network Client
>     Versions: 10.1.2.1
>     Reporter: Daniel John Debrunner
>     Assignee: Daniel John Debrunner

>
> A statement created or prepared in a local transaction using the default holdability
settting can not be used in a global transaction.
> This is because the default holdability is HOLD_CURSORS_OVER_COMMIT and Derby does not
support held cursors in global transactions.
> The change would be to allow those statements to be used in global transactions, returning
ResultSets that are CLOSE_CURSORS_AT_COMMIT .
> This would allow such statements to be cached by application servers.
> JDBC 3.0 section 12.6 does allow holdability to be handled in an implementation specific
way for global transactions.
> I believe this change is forward compatible if Derby ever does start supporting held
cursors in global transactions (pretty unlikely) since
> the functionality displayed is a ub-set of the holdable functionality. 

-- 
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


Mime
View raw message