Uploaded image for project: 'OpenJPA'
  1. OpenJPA
  2. OPENJPA-2235

"READ_UNCOMMITTED" setting for the fetch plan isolation level is ignored in DB2Dictionary

    Details

    • Patch Info:
      Patch Available

      Description

      When user set query hint as shown below for db2, no "with UR" clause append to the query. The setting is ignored.
      query.setHint("openjpa.FetchPlan.Isolation", "READ_UNCOMMITTED");

      Uncommitted read is very risky and should be avoid if it is possible. JPA specification requires a minimum of read-committed isolation to ensure no "dirty read" and "non-repeatible read" can occur. Use of read-uncommitted isolation may cause data integrity problem.

        Attachments

          Activity

            People

            • Assignee:
              helenxu Helen Xu
              Reporter:
              helenxu Helen Xu
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: