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

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

    XMLWordPrintableJSON

Details

    • Newcomer, Patch Available
    • 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.

      Attachments

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

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. DERBY-2064 Network client setTransactionIsolation() commits any active transactions

          • Major - Major loss of function.
          • Closed
          is related to

          Bug - A problem which impairs or prevents the functions of the product. DERBY-4343 ASSERT FAILED calling setTransactionIsolation checking isolation_ == level on pooled connection

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

          Activity

            People

              lilywei Lily Wei
              kmarsden Katherine Marsden
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: