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.

        Activity

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development