[
https://issues.apache.org/jira/browse/OPENJPA-2186?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Richard Zowalla resolved OPENJPA-2186.
--------------------------------------
Resolution: Fixed
Fixed on master by OPENJPA-3034 (06d91ea4d); part of 4.2.0.
> Sequences are not removed in DerbyDB
> ------------------------------------
>
> Key: OPENJPA-2186
> URL: https://issues.apache.org/jira/browse/OPENJPA-2186
> Project: OpenJPA
> Issue Type: Bug
> Reporter: Lucas Smith
> Priority: Major
> Fix For: 4.2.0
>
>
> I have the following code:
> @SequenceGenerator(name="CompanySeqGen", sequenceName="COMPANYSEQUENCE")
> @GeneratedValue(strategy = GenerationType.SEQUENCE, generator="CompanySeqGen")
> and following property in persistence.xml file:
> <property name="openjpa.jdbc.SynchronizeMappings"
> value="buildSchema(SchemaAction='drop,add,deleteTableContents',IgnoreErrors=true)"
> />
> When I generate the schema for the first time everything is OK. However when
> I do it once again I get exception that sequence 'COMPANYSEQUENCE' already
> exists. I have to remove this sequence manually using SQL language.
> Tables are dropped and then created, but sequences are not removed.
> Similar problem has already been reported but with different database.
--
This message was sent by Atlassian Jira
(v10.3.26#10030026)
