[ http://issues.apache.org/jira/browse/OPENJPA-63?page=all ]

Igor Fedorenko updated OPENJPA-63:
----------------------------------

    Attachment: db2-selectForUpdate2.patch.diff

Revised patch that uses "WITH RR USE AND KEEP UPDATE LOCKS" for-update clause 
and tolerates JDBC 2.x (read, "Legacy CLI") drivers. I tested this patch with 
DB2 8.2.2 (both JCC and CLI drivers) and with DB2 9.1 (JCC driver only).


> Better pessimistic lock support for DB2 v8.2+
> ---------------------------------------------
>
>                 Key: OPENJPA-63
>                 URL: http://issues.apache.org/jira/browse/OPENJPA-63
>             Project: OpenJPA
>          Issue Type: Improvement
>          Components: jdbc
>         Environment: IBM DB2 UDB v8.2 or later
>            Reporter: Igor Fedorenko
>         Attachments: db2-selectForUpdate.patch, 
> db2-selectForUpdate2.patch.diff
>
>
> 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.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Reply via email to