Derby
  1. Derby
  2. DERBY-3436

Embedded closes all open ResultSets on failure in auto-commit mode, whereas client keeps them open

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Duplicate
    • Affects Version/s: 10.4.1.3
    • Fix Version/s: None
    • Component/s: JDBC
    • Labels:
      None
    • Urgency:
      Normal
    • Bug behavior facts:
      Embedded/Client difference

      Description

      When an error happens in auto-commit mode, the embedded driver will close all open ResultSets (including holdable ones) in that transaction. The client driver will keep the ResultSets open. The embedded driver and the client driver should have the same behaviour.

      The test case testAutoCommitFailure() in jdbc4/TestDbMetaData contains code that shows the difference between client and embedded.

      DatabaseMetaData.autoCommitFailureClosesAllResultSets() currently returns true on the embedded driver (after DERBY-3422) and false on the client driver to account for this difference.

        Issue Links

          Activity

          No work has yet been logged on this issue.

            People

            • Assignee:
              Unassigned
              Reporter:
              Knut Anders Hatlen
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development