[OPENJPA-182] db2 update lock syntax WITH <isolation> USE AND KEEP UPDATE LOCKS

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.9.7
• Component/s: jdbc
• Environment: db2 database driver for zOS, AS400, Unix, Windows, Linux
• Assignee: Unassigned
• Reporter: David Wisneski
• Created: 26/Mar/07 17:22
• Updated: 09/Mar/10 18:32
• Resolved: 06/Apr/07 23:54

Description

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.

Issue Links

• relates to: OPENJPA-222 FOR READ ONLY clause getting generated for subselects