[#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:

Repository	Revision	Date	User	Message
ASF	#468064	Thu Oct 26 17:08:05 UTC 2006	kwsutter	First step in resolving ~~OPENJPA-63~~. This change removes the usage of internal WebSphere transaction-related APIs and replaces it with the public ExtendedJTATransaction interface usage.
				Files Changed
				ADD /incubator/openjpa/trunk/openjpa-kernel/src/test/java ADD /incubator/openjpa/trunk/openjpa-kernel/src/test/java/org/apache ADD /incubator/openjpa/trunk/openjpa-kernel/src/main/java/org/apache/openjpa/util/WASTransformer.java ADD /incubator/openjpa/trunk/openjpa-kernel/src/test/java/org/apache/openjpa MODIFY /incubator/openjpa/trunk/openjpa-kernel/pom.xml MODIFY /incubator/openjpa/trunk/openjpa-kernel/src/main/resources/org/apache/openjpa/ee/localizer.properties ADD /incubator/openjpa/trunk/openjpa-kernel/src/test/java/org MODIFY /incubator/openjpa/trunk/openjpa-kernel/src/main/java/org/apache/openjpa/ee/AutomaticManagedRuntime.java ADD /incubator/openjpa/trunk/openjpa-kernel/src/test/java/org/apache/openjpa/util/TestWASTransformer.java ADD /incubator/openjpa/trunk/openjpa-kernel/src/main/java/org/apache/openjpa/ee/WASManagedRuntime.java ADD /incubator/openjpa/trunk/openjpa-kernel/src/test/java/org/apache/openjpa/util ADD /incubator/openjpa/trunk/openjpa-kernel/src/test

Repository	Revision	Date	User	Message
ASF	#482189	Mon Dec 04 14:42:09 UTC 2006	kwsutter	Resolving JIRA report ~~OPENJPA-63~~ for better pessimistic lock support for DB2. Instead of the usual "for update" clause, db2 dictionary will now use "with rr use and keep update locks" clause. A couple of additional changes were necessary to properly detect the version of DB2 currently in use.
				Files Changed
				MODIFY /incubator/openjpa/trunk/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/meta/MappingTool.java MODIFY /incubator/openjpa/trunk/openjpa-lib/src/main/java/org/apache/openjpa/lib/jdbc/DelegatingDatabaseMetaData.java MODIFY /incubator/openjpa/trunk/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/sql/DB2Dictionary.java