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

OpenJPA

Better pessimistic lock support for DB2 v8.2+

Created: 04/Oct/06 06:16 PM Updated: 01/Mar/07 02:20 AM

Return to search

Component/s:

jdbc

Affects Version/s:

None

Fix Version/s:

0.9.7

Time Tracking:

Not Specified

File Attachments:

File Name	Date Attached	Attached By	Size
db2-selectForUpdate.patch	2006-10-04 06:19 PM	Igor Fedorenko	3 kB
db2-selectForUpdate2.patch.diff	2006-11-12 07:12 AM	Igor Fedorenko	7 kB

Environment:

IBM DB2 UDB v8.2 or later

Resolution Date:

01/Mar/07 02:20 AM

Description

« Hide

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.

All

Comments

Work Log

Change History

Subversion Commits

Sort Order:

Igor Fedorenko made changes - 04/Oct/06 06:19 PM

Field	Original Value	New Value
Attachment		db2-selectForUpdate.patch [ 12342282 ]

Kevin Sutter made changes - 24/Oct/06 01:39 PM

Summary

Better pissimistic lock support for DB2 v8.2+

Better pessimistic lock support for DB2 v8.2+

Igor Fedorenko made changes - 12/Nov/06 07:12 AM

Attachment

db2-selectForUpdate2.patch.diff [ 12344830 ]

Kevin Sutter made changes - 04/Dec/06 02:39 PM

Assignee

Kevin Sutter [ kwsutter ]

Kevin Sutter made changes - 04/Dec/06 02:46 PM

Resolution		Fixed [ 1 ]
Status	Open [ 1 ]	Resolved [ 5 ]

Kevin Sutter made changes - 09/Jan/07 04:56 PM

Status

Resolved [ 5 ]

Closed [ 6 ]

Patrick Linskey made changes - 01/Mar/07 02:17 AM

Status	Closed [ 6 ]	Reopened [ 4 ]
Resolution	Fixed [ 1 ]

Patrick Linskey made changes - 01/Mar/07 02:18 AM

Fix Version/s

0.9.7 [ 12312340 ]

Patrick Linskey made changes - 01/Mar/07 02:20 AM

Status	Reopened [ 4 ]	Closed [ 6 ]
Resolution		Fixed [ 1 ]