[
https://issues.apache.org/jira/browse/OPENJPA-2570?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14526841#comment-14526841
]
Heath Thomann commented on OPENJPA-2570:
----------------------------------------
To enabled the code of this fix, set the following property in your
persistence.xml file:
<property name="openjpa.jdbc.DBDictionary"
value="informix(disableRetainUpdateLocksSQL=true)" />
This property could instead be set as a JVM system property.
> Allow an Informix user the option to disable the 'RETAINUPDATELOCKS' SQL.
> -------------------------------------------------------------------------
>
> Key: OPENJPA-2570
> URL: https://issues.apache.org/jira/browse/OPENJPA-2570
> Project: OpenJPA
> Issue Type: New Feature
> Components: jdbc
> Affects Versions: 2.0.2, 2.1.2, 2.2.1.1, 2.2.3, 2.4.0
> Reporter: Heath Thomann
> Assignee: Heath Thomann
> Priority: Minor
> Fix For: 2.2.3, 2.4.0
>
>
> 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
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
