Uploaded image for project: 'OpenJPA'
  1. OpenJPA
  2. OPENJPA-2570

Allow an Informix user the option to disable the 'RETAINUPDATELOCKS' SQL.

    Details

    • 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
    • Labels:
      None

      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

          Activity

          Hide
          jira-bot ASF subversion and git services added a comment -

          Commit 1666312 from Heath Thomann in branch 'openjpa/branches/2.2.x'
          [ https://svn.apache.org/r1666312 ]

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

          Show
          jira-bot ASF subversion and git services added a comment - Commit 1666312 from Heath Thomann in branch 'openjpa/branches/2.2.x' [ https://svn.apache.org/r1666312 ] OPENJPA-2570 : Allow an Informix user the option to disable the 'RETAINUPDATELOCKS' SQL.
          Hide
          jira-bot ASF subversion and git services added a comment -

          Commit 1666314 from Heath Thomann in branch 'openjpa/trunk'
          [ https://svn.apache.org/r1666314 ]

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

          Show
          jira-bot ASF subversion and git services added a comment - Commit 1666314 from Heath Thomann in branch 'openjpa/trunk' [ https://svn.apache.org/r1666314 ] OPENJPA-2570 : Allow an Informix user the option to disable the 'RETAINUPDATELOCKS' SQL.
          Hide
          jira-bot ASF subversion and git services added a comment -

          Commit 1672435 from Jody Grassel in branch 'openjpa/branches/2.2.x'
          [ https://svn.apache.org/r1672435 ]

          OPENJPA-2570: Allow an informix user the option to disable the RETAINUPDATELOCKS sql

          Show
          jira-bot ASF subversion and git services added a comment - Commit 1672435 from Jody Grassel in branch 'openjpa/branches/2.2.x' [ https://svn.apache.org/r1672435 ] OPENJPA-2570 : Allow an informix user the option to disable the RETAINUPDATELOCKS sql
          Hide
          jira-bot ASF subversion and git services added a comment -

          Commit 1672487 from Jody Grassel in branch 'openjpa/trunk'
          [ https://svn.apache.org/r1672487 ]

          OPENJPA-2570: Allow an informix user the option to disable the RETAINUPDATELOCKS sql

          Show
          jira-bot ASF subversion and git services added a comment - Commit 1672487 from Jody Grassel in branch 'openjpa/trunk' [ https://svn.apache.org/r1672487 ] OPENJPA-2570 : Allow an informix user the option to disable the RETAINUPDATELOCKS sql
          Hide
          jira-bot ASF subversion and git services added a comment -

          Commit 1675457 from Jody Grassel in branch 'openjpa/branches/2.2.x'
          [ https://svn.apache.org/r1675457 ]

          OPENJPA-2570: Allow an informix user the option to disable the RETAINUPDATELOCKS sql

          Show
          jira-bot ASF subversion and git services added a comment - Commit 1675457 from Jody Grassel in branch 'openjpa/branches/2.2.x' [ https://svn.apache.org/r1675457 ] OPENJPA-2570 : Allow an informix user the option to disable the RETAINUPDATELOCKS sql
          Hide
          jira-bot ASF subversion and git services added a comment -

          Commit 1675495 from Jody Grassel in branch 'openjpa/trunk'
          [ https://svn.apache.org/r1675495 ]

          OPENJPA-2570: Allow an informix user the option to disable the RETAINUPDATELOCKS sql

          Show
          jira-bot ASF subversion and git services added a comment - Commit 1675495 from Jody Grassel in branch 'openjpa/trunk' [ https://svn.apache.org/r1675495 ] OPENJPA-2570 : Allow an informix user the option to disable the RETAINUPDATELOCKS sql
          Hide
          jpaheath Heath Thomann added a comment -

          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.

          Show
          jpaheath Heath Thomann added a comment - 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.

            People

            • Assignee:
              jpaheath Heath Thomann
              Reporter:
              jpaheath Heath Thomann
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development