Hi, do you have any advice?
---------- Forwarded message ---------- From: Christopher Schmidt <[email protected]> Date: Thu, Jun 3, 2010 at 9:17 PM Subject: relation "mySequence" already exists To: [email protected] Hi all, using OpenJPA 2.0.0 with Postgresql 8.4 JDBC4 I want to create the schema with the following property: <property name="openjpa.jdbc.SynchronizeMappings" value="buildSchema(SchemaAction='drop,add')"/> The entity is defined as follows: @Entity @Table(name = "obj_item") @Inheritance(strategy = InheritanceType.JOINED) @SequenceGenerator(name = "obj_item_id_seq", sequenceName = "obj_item_id_seq", allocationSize = 1) class ObjectItem ... it seems that the sequence will not be dropped - so I get the following exception: org.apache.openjpa.persistence.PersistenceException: ERROR: relation "obj_item_id_seq" already exists {stmnt 1834517285 CREATE SEQUENCE obj_item_id_seq START WITH 1} [code=0, state=42P07] at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:556)... I found a bug here: https://issues.apache.org/jira/browse/OPENJPA-1259 Any advice? Regards Christopher
