[
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)
