svn commit: r1517838 - /openjpa/branches/2.1.x/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/sql/DB2Dictionary.java

[hthomann]

Author: hthomann
Date: Tue Aug 27 14:49:06 2013
New Revision: 1517838

URL: http://svn.apache.org/r1517838
Log:
OPENJPA-2423: Isolation level is not working properly on DB2 for JPQL queries 
with nested sub-queries - committed to 2.1.x the patch/fix provided by Pinaki 
Poddar.

Modified:
    
openjpa/branches/2.1.x/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/sql/DB2Dictionary.java

Modified: 
openjpa/branches/2.1.x/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/sql/DB2Dictionary.java
URL: 
http://svn.apache.org/viewvc/openjpa/branches/2.1.x/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/sql/DB2Dictionary.java?rev=1517838&r1=1517837&r2=1517838&view=diff
==============================================================================
--- 
openjpa/branches/2.1.x/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/sql/DB2Dictionary.java
 (original)
+++ 
openjpa/branches/2.1.x/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/sql/DB2Dictionary.java
 Tue Aug 27 14:49:06 2013
@@ -469,7 +469,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);
                }