openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christopher Schmidt <fakod...@googlemail.com>
Subject Fwd: relation "mySequence" already exists
Date Sun, 06 Jun 2010 17:41:22 GMT
Hi, do you have any advice?


---------- Forwarded message ----------
From: Christopher Schmidt <fakod666@googlemail.com>
Date: Thu, Jun 3, 2010 at 9:17 PM
Subject: relation "mySequence" already exists
To: users@openjpa.apache.org


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

Mime
View raw message