Author: arminw
Date: Wed Nov 22 07:21:40 2006
New Revision: 478190

URL: http://svn.apache.org/viewvc?view=rev&rev=478190
Log:
rollback identity column request changes

Modified:
    
db/ojb/branches/OJB_1_0_RELEASE/src/java/org/apache/ojb/broker/platforms/PlatformDb2Impl.java

Modified: 
db/ojb/branches/OJB_1_0_RELEASE/src/java/org/apache/ojb/broker/platforms/PlatformDb2Impl.java
URL: 
http://svn.apache.org/viewvc/db/ojb/branches/OJB_1_0_RELEASE/src/java/org/apache/ojb/broker/platforms/PlatformDb2Impl.java?view=diff&rev=478190&r1=478189&r2=478190
==============================================================================
--- 
db/ojb/branches/OJB_1_0_RELEASE/src/java/org/apache/ojb/broker/platforms/PlatformDb2Impl.java
 (original)
+++ 
db/ojb/branches/OJB_1_0_RELEASE/src/java/org/apache/ojb/broker/platforms/PlatformDb2Impl.java
 Wed Nov 22 07:21:40 2006
@@ -251,13 +251,9 @@
 
     public String getLastInsertIdentityQuery(String tableName)
     {
-        // [EMAIL PROTECTED]
-        // the function is used by the 
org.apache.ojb.broker.util.sequence.SequenceManagerNativeImpl
-               // this call must be made before commit the insert command, so 
you
-        // must turn off autocommit by seting the useAutoCommit="2"
-        // or use useAutoCommit="1" or use a connection with autoCommit set 
false
-        // by default (e.g. in managed environments)
-        // transaction demarcation is mandatory
-        return "values IDENTITY_VAL_LOCAL()";
+        // arminw: Query "values IDENTITY_VAL_LOCAL()" doesn't seems to
+        // work with DB2 Z/os v7 (reported on user-list) thus rollback to
+        // 
+        return "select IDENTITY_VAL_LOCAL() from sysibm.sysdummy1";
     }
 }



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to