You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openjpa.apache.org by "Heath Thomann (JIRA)" <ji...@apache.org> on 2016/07/11 21:49:11 UTC
[jira] [Commented] (OPENJPA-2647) Not working -
disableAlterSeqenceIncrementBy - with WAS 8.5.5.7
[ https://issues.apache.org/jira/browse/OPENJPA-2647?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15371707#comment-15371707 ]
Heath Thomann commented on OPENJPA-2647:
----------------------------------------
HI! If the property is properly set, you will see a warning message in the WebSphere logs with the first sentence saying "The property "openjpa.jdbc.DBDictionary=disableAlterSeqenceIncrementBy" is set to true.". If you see this message, yet you still see OpenJPA executing an "ALTER SEQUENCE...." SQL, then something is up with OpenJPA. If you do not see this message, then you are likely not setting this property in the right place or right way. If you set this as a JVM custom property, it should ensure that OpenJPA will use it from ALL persistence units. You could try this as a proof of concept to see what happens. If you continue to see unexpected behavior, you should open a ticket against WebSphere support. When opening the ticket please provide more details, or even better, a sample demonstrating your issue.
Thanks,
Heath Thomann
> Not working - disableAlterSeqenceIncrementBy - with WAS 8.5.5.7
> ---------------------------------------------------------------
>
> Key: OPENJPA-2647
> URL: https://issues.apache.org/jira/browse/OPENJPA-2647
> Project: OpenJPA
> Issue Type: Bug
> Components: jdbc
> Affects Versions: 2.3.0
> Environment: WebSphere Application Server 8.5.5.7
> Reporter: Naveen
>
> Hi, We have recently upgraded our infrastructure from WAS7.x to WAS8.x . Post migration in prod, we ended up with blow issue.
> Issue: The open JPA which is delivered as part of WAS 8.5.5.7, is altering our DB sequences with increment by value as 50. We tried to disable this sql with the below property in persistence.xml but for some reason, open jpa not considering this property and still sequence getting altered.
> Below are the various ways we tried to disable the alter sequence sql, but none of these options worked for us
> <property name="openjpa.jdbc.DBDictionary" value="DisableAlterSeqenceIncrementBy=true" />
> <property name="openjpa.jdbc.DBDictionary" value="disableAlterSeqenceIncrementBy=true" />
> <property name="openjpa.jdbc.DBDictionary.DisableAlterSeqenceIncrementBy" value="true" />
> <property name="openjpa.jdbc.DBDictionary.disableAlterSeqenceIncrementBy" value="true" />
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)