Derby
  1. Derby
  2. DERBY-2064

Network client setTransactionIsolation() commits any active transactions

    Details

    • Urgency:
      Normal
    • Issue & fix info:
      Release Note Needed, Repro attached
    • Bug behavior facts:
      Embedded/Client difference

      Description

      Network client implements setTransactionIsolation() using
      Statement.executeUpdate("SET CURRENT ISOLATION.......")
      which again causes any active transactions to commit.

      This differs from the embedded driver, where setTransactionIsolation() does not cause a commit.

      (Note that "SET CURRENT ISOLATION....." will commit active transactions idependent of this)

        Issue Links

          Activity

          Bernt M. Johnsen created issue -
          Bernt M. Johnsen made changes -
          Field Original Value New Value
          Link This issue is part of DERBY-310 [ DERBY-310 ]
          Bernt M. Johnsen made changes -
          Link This issue is related to DERBY-638 [ DERBY-638 ]
          Bernt M. Johnsen made changes -
          Link This issue relates to DERBY-2060 [ DERBY-2060 ]
          Knut Anders Hatlen made changes -
          Link This issue is duplicated by DERBY-2401 [ DERBY-2401 ]
          Hide
          Knut Anders Hatlen added a comment -

          > This differs from the embedded driver, where setTransactionIsolation() does not cause a commit.
          More precisely: ... where setTransactionIsolation() only commits if the isolation level is changed.

          Show
          Knut Anders Hatlen added a comment - > This differs from the embedded driver, where setTransactionIsolation() does not cause a commit. More precisely: ... where setTransactionIsolation() only commits if the isolation level is changed.
          Hide
          Knut Anders Hatlen added a comment -

          Triaged for 10.5.2. A test case for this is included in jdbcapi/SetTransactionIsolationTest (testSetTransactionIsolationCommits), so setting "Repro attached".

          Show
          Knut Anders Hatlen added a comment - Triaged for 10.5.2. A test case for this is included in jdbcapi/SetTransactionIsolationTest (testSetTransactionIsolationCommits), so setting "Repro attached".
          Knut Anders Hatlen made changes -
          Summary Network client setTransactionIsolation() commits any active transactios Network client setTransactionIsolation() commits any active transactions
          Bug behavior facts [Embedded/Client difference]
          Urgency Normal
          Issue & fix info [Release Note Needed, Repro attached]
          Lily Wei made changes -
          Link This issue is duplicated by DERBY-4314 [ DERBY-4314 ]
          Hide
          Lily Wei added a comment -

          Thanks Knut for clear description and repro.

          Per Kathey's suggestion and the similarity nature of the bug, I am marking this bug a dup of DERBY-4314.

          Show
          Lily Wei added a comment - Thanks Knut for clear description and repro. Per Kathey's suggestion and the similarity nature of the bug, I am marking this bug a dup of DERBY-4314 .
          Kathey Marsden made changes -
          Labels derby_triage10_5_2
          Hide
          Myrna van Lunteren added a comment -

          I think this can then be closed as a duplicate.

          Show
          Myrna van Lunteren added a comment - I think this can then be closed as a duplicate.
          Myrna van Lunteren made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Fix Version/s 10.7.1.1 [ 12315564 ]
          Resolution Duplicate [ 3 ]
          Hide
          Knut Anders Hatlen added a comment -

          [bulk update] Close all resolved issues that haven't been updated for more than one year.

          Show
          Knut Anders Hatlen added a comment - [bulk update] Close all resolved issues that haven't been updated for more than one year.
          Knut Anders Hatlen made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Gavin made changes -
          Workflow jira [ 12388904 ] Default workflow, editable Closed status [ 12802762 ]

            People

            • Assignee:
              Unassigned
              Reporter:
              Bernt M. Johnsen
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development