svn commit: r468440 - /incubator/openjpa/trunk/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/sql/DB2Dictionary.java

[kwsutter]

Author: kwsutter
Date: Fri Oct 27 09:16:59 2006
New Revision: 468440

URL: http://svn.apache.org/viewvc?view=rev&rev=468440
Log:
Resolving OPENJPA-67.  The sql statement for selecting the next value in a 
sequence was not correct in the DB2 Dictionary.

Modified:
    
incubator/openjpa/trunk/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/sql/DB2Dictionary.java

Modified: 
incubator/openjpa/trunk/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/sql/DB2Dictionary.java
URL: 
http://svn.apache.org/viewvc/incubator/openjpa/trunk/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/sql/DB2Dictionary.java?view=diff&rev=468440&r1=468439&r2=468440
==============================================================================
--- 
incubator/openjpa/trunk/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/sql/DB2Dictionary.java
 (original)
+++ 
incubator/openjpa/trunk/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/sql/DB2Dictionary.java
 Fri Oct 27 09:16:59 2006
@@ -33,7 +33,7 @@
             + "SYSIBM.SYSTABLES";
         supportsSelectEndIndex = true;
 
-        nextSequenceQuery = "SELECT NEXTVAL FOR {0}";
+        nextSequenceQuery = "VALUES NEXTVAL FOR {0}";
 
         binaryTypeName = "BLOB(1M)";
         longVarbinaryTypeName = "BLOB(1M)";