[OPENJPA-2186] Sequences are not removed in DerbyDB

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Assignee: Unassigned
• Reporter: Lucas Smith
• Created: 06/May/12 15:37
• Updated: 06/May/12 15:39

Description

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.

Issue Links

• relates to: OPENJPA-1689 The mapping tool does not remove user created sequences on PostgreSQL