Mailing-List: contact dev-help@openjpa.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@openjpa.apache.org
Date: Tue, 21 Aug 2012 03:17:37 +1100 (NCT)
From: "Helen Xu (JIRA)" <jira@apache.org>
To: dev@openjpa.apache.org
Message-ID: <375528644.30461.1345479457994.JavaMail.jiratomcat@arcas>
In-Reply-To: <1578271636.76159.1342713394949.JavaMail.jiratomcat@issues-vm>
Subject: [jira] [Updated] (OPENJPA-2235) "READ_UNCOMMITTED" setting for the
 fetch plan isolation level is ignored in DB2Dictionary
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


     [ https://issues.apache.org/jira/browse/OPENJPA-2235?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Helen Xu updated OPENJPA-2235:
------------------------------

    Attachment:     (was: OPENJPA-2235.patch)
    
> "READ_UNCOMMITTED" setting for the fetch plan isolation level is ignored in DB2Dictionary
> -----------------------------------------------------------------------------------------
>
>                 Key: OPENJPA-2235
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-2235
>             Project: OpenJPA
>          Issue Type: Bug
>          Components: performance, query
>    Affects Versions: 2.1.1, 2.2.0, 2.3.0
>            Reporter: Helen Xu
>            Assignee: Helen Xu
>         Attachments: OPENJPA-2235.patch
>
>
> 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.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira