[OPENJPA-63] Better pessimistic lock support for DB2 v8.2+

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.9.7
• Component/s: jdbc
• Environment: IBM DB2 UDB v8.2 or later
• Assignee: Kevin W. Sutter
• Reporter: Igor Fedorenko
• Created: 04/Oct/06 18:16
• Updated: 01/Mar/07 02:20
• Resolved: 01/Mar/07 02:20

Description

There is new SELECT "FOR READ ONLY WITH RS USE AND KEEP EXCLUSIVE LOCKS" syntax in DB2 v8.2 and later that can be used to implement pessimistic locks for selects with multiple from tables, subselects, inner/outer joins and so forth. I'll attach simple patch shortly.