Derby
  1. Derby
  2. DERBY-4314

With derby client setTransactionIsolation executes and commits even if isolation has not changed

    Details

    • Issue & fix info:
      Newcomer, Patch Available
    • Bug behavior facts:
      Embedded/Client difference

      Description

      With in EmbedConnection.setIsolation() we have a check to see if the isolation level is the same and if so just return without doing a commit:
      public void setTransactionIsolation(int level) throws SQLException {

      if (level == getTransactionIsolation())
      return;

      with org.apache.derby.client.am.Connection we have no such check. It would be good if the client driver acted like embedded.

      1. DERBY-4314.diff
        1 kB
        Lily Wei
      2. DERBY-4314-2.diff
        4 kB
        Lily Wei
      3. DERBY-4314-3.diff
        4 kB
        Lily Wei
      4. DERBY-4314-5.diff
        4 kB
        Lily Wei
      5. derby-4314-6a-initial_piggybacking.diff
        8 kB
        Kristian Waagan
      6. derby-4314-6a-initial_piggybacking.stat
        0.2 kB
        Kristian Waagan
      7. DERBY-4314-6b-combinepiggybacking.diff
        11 kB
        Lily Wei
      8. DERBY-4314-6c-combineaftermerge.diff
        11 kB
        Lily Wei
      9. derby-4314-6d-handle_xa.diff
        15 kB
        Kristian Waagan
      10. DERBY-4314-7b-combine.diff
        16 kB
        Lily Wei
      11. DERBY-4314-7-withoutpiggybacking.diff
        5 kB
        Lily Wei
      12. releaseNote.html
        4 kB
        Lily Wei
      13. releaseNote.html
        4 kB
        Lily Wei
      14. ReproIsoLost.java
        4 kB
        Kathey Marsden
      15. TestConnReuse.java
        2 kB
        Lily Wei
      16. utilXid.java
        2 kB
        Kathey Marsden

        Issue Links

          Activity

          No work has yet been logged on this issue.

            People

            • Assignee:
              Lily Wei
              Reporter:
              Kathey Marsden
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development