openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Igor Fedorenko (JIRA)" <j...@apache.org>
Subject [jira] Updated: (OPENJPA-63) Better pessimistic lock support for DB2 v8.2+
Date Sun, 12 Nov 2006 07:12:37 GMT
     [ 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

        

Mime
View raw message