openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "David Wisneski (JIRA)" <j...@apache.org>
Subject [jira] Created: (OPENJPA-182) db2 update lock syntax WITH <isolation> USE AND KEEP UPDATE LOCKS
Date Mon, 26 Mar 2007 17:23:32 GMT
db2 update lock syntax  WITH <isolation> USE AND KEEP UPDATE LOCKS
------------------------------------------------------------------

                 Key: OPENJPA-182
                 URL: https://issues.apache.org/jira/browse/OPENJPA-182
             Project: OpenJPA
          Issue Type: New Feature
          Components: jdbc
         Environment: db2 database driver for zOS, AS400, Unix, Windows, Linux
            Reporter: David Wisneski
         Assigned To: David Wisneski


A while back we changed the syntax of update locking from FOR UPDATE OF  to  WITH RS USE AND
KEEP UPDATE LOCKS.   Additional changes are required because 
1.  if isolation=serializable is configured, then the syntax should be  WITH RR USE AND KEEP
UDPATE LOCKS
2.  when using DB2/400 on iSeries machines, the syntax is WITH RS USE AND KEEP EXCLUSIVE LOCKS
 or WITH RR USE AND KEEP EXCLUSIVE LOCKS because DB2/400 only supports read or exclusive locks.

3.  DB2 supports both a FETCH FIRST  ROWS and update LOCKS clauses.

So we change supportsLockingWithSelectRange = true in the AbstractDB2Dictionary class and
change the DB2Dictionary to append the correct LOCKS syntax depending on vendor, release and
isolation level.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message