openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lucas Smith (JIRA)" <>
Subject [jira] [Created] (OPENJPA-2186) Sequences are not removed in DerbyDB
Date Sun, 06 May 2012 15:39:48 GMT
Lucas Smith created OPENJPA-2186:

             Summary: Sequences are not removed in DerbyDB
                 Key: OPENJPA-2186
             Project: OpenJPA
          Issue Type: Bug
            Reporter: Lucas Smith

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.

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:!default.jspa
For more information on JIRA, see:


View raw message