You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@openjpa.apache.org by ht...@apache.org on 2013/08/27 17:06:13 UTC
svn commit: r1517843 - in /openjpa/trunk: ./
openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/sql/DB2Dictionary.java
Author: hthomann
Date: Tue Aug 27 15:06:13 2013
New Revision: 1517843
URL: http://svn.apache.org/r1517843
Log:
OPENJPA-2423: Isolation level is not working properly on DB2 for JPQL queries with nested sub-queries - committed to trunk the patch/fix provided by Pinaki Poddar.
Modified:
openjpa/trunk/ (props changed)
openjpa/trunk/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/sql/DB2Dictionary.java
Propchange: openjpa/trunk/
------------------------------------------------------------------------------
Merged /openjpa/branches/2.1.x:r1517838
Modified: openjpa/trunk/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/sql/DB2Dictionary.java
URL: http://svn.apache.org/viewvc/openjpa/trunk/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/sql/DB2Dictionary.java?rev=1517843&r1=1517842&r2=1517843&view=diff
==============================================================================
--- openjpa/trunk/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/sql/DB2Dictionary.java (original)
+++ openjpa/trunk/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/sql/DB2Dictionary.java Tue Aug 27 15:06:13 2013
@@ -440,7 +440,8 @@ public class DB2Dictionary
break;
}
} else {
- if ( fetch != null && fetch.getIsolation() == Connection.TRANSACTION_READ_UNCOMMITTED ) {
+ if ( fetch != null && fetch.getIsolation() == Connection.TRANSACTION_READ_UNCOMMITTED
+ && sel.getParent() == null) { // i.e. not a subquery
forUpdateString.append(" ").append(forReadOnlyClause)
.append(" ").append(withURClause);
}