[OPENJPA-2570] Allow an Informix user the option to disable the 'RETAINUPDATELOCKS' SQL.

• Type: New Feature
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 2.0.2, 2.1.2, 2.2.1.1, 2.2.3, 2.4.0
• Fix Version/s: 2.2.3, 2.4.0
• Component/s: jdbc
• Assignee: Heath Thomann
• Reporter: Heath Thomann
• Created: 18/Feb/15 20:14
• Updated: 04/May/15 16:55
• Resolved: 12/Mar/15 23:44

Description

In JIRA OPENJPA-1608, a fix was added to the InformixDictionary which causes the following SQL to be executed on each connection:

"SET ENVIRONMENT RETAINUPDATELOCKS 'ALL'"

I've had a request to allow a user to disable this option should they so choose. This JIRA will be used to simply add a property to allow a user to disable this SQL. By default this SQL will remain as-is today.

Thanks,

Heath Thomann

Issue Links

• is related to: OPENJPA-1608 PESSIMISTIC_WRITE is not working in Informix