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

        Helen Xu created issue -
        Helen Xu made changes -
        Field Original Value New Value
        Attachment OPENJPA-1955.patch [ 12537267 ]
        Helen Xu made changes -
        Attachment OPENJPA-1955.patch [ 12537267 ]
        Helen Xu made changes -
        Attachment OPENJPA-2235.patch [ 12537360 ]
        Helen Xu made changes -
        Attachment OPENJPA-2235.patch [ 12538028 ]
        Helen Xu made changes -
        Attachment OPENJPA-2235.patch [ 12541604 ]
        Helen Xu made changes -
        Attachment OPENJPA-2235.patch [ 12541604 ]
        Helen Xu made changes -
        Attachment OPENJPA-2235.patch [ 12538028 ]
        Helen Xu made changes -
        Attachment OPENJPA-2235.patch [ 12537360 ]
        Helen Xu made changes -
        Attachment OPENJPA-2235.patch [ 12541605 ]
        Albert Lee made changes -
        Patch Info Patch Available [ 10042 ]
        Albert Lee made changes -
        Fix Version/s 2.1.2 [ 12317142 ]
        Fix Version/s 2.3.0 [ 12319463 ]
        Fix Version/s 2.2.2 [ 12323356 ]
        Fix Version/s 2.2.1.1 [ 12323484 ]
        Albert Lee made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        Albert Lee made changes -
        Status Resolved [ 5 ] Closed [ 6 ]

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development