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

Network client setTransactionIsolation() commits any active transactions

    XMLWordPrintableJSON

Details

    • Normal
    • Release Note Needed, Repro attached
    • 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)

      Attachments

        Issue Links

          is duplicated by

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-4314 With derby client setTransactionIsolation executes and commits even if isolation has not changed

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Task - A task that needs to be done. DERBY-2401 change client setTransactionIsolation to only commit when the isolation level is changed to match embedded

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          is part of

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-310 Document and/or change Derby client code to match behavior with Embedded driver where possible.

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          is related to

          Bug - A problem which impairs or prevents the functions of the product. DERBY-638 Network driver setTransactionIsolation() causes a commit, but does not complete it locally

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. DERBY-2060 SET CURRENT ISOLATION in ref.man refers java.sql.Connection.setTransactionLevel instead of java.sql.Connection.setTransactionIsolation

          • Major - Major loss of function.
          • Closed

          Activity

            People

              Unassigned Unassigned
              bernt Bernt Johnsen
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: