Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-1158

Allow use of Statements created in local transaction with default holdability to be used in global transactions.

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.1.2.1
    • Fix Version/s: 10.1.3.1, 10.2.1.6
    • Component/s: JDBC, Network Client
    • Labels:
      None

      Description

      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.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                djd Daniel John Debrunner
                Reporter:
                djd Daniel John Debrunner
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: