Return-Path: 
 <dev-return-16599-apmail-openjpa-dev-archive=openjpa.apache.org@openjpa.apache.org>
Delivered-To: apmail-openjpa-dev-archive@www.apache.org
Received: (qmail 27562 invoked from network); 6 Jun 2010 17:41:50 -0000
Received: from unknown (HELO mail.apache.org) (140.211.11.3)
  by 140.211.11.9 with SMTP; 6 Jun 2010 17:41:50 -0000
Received: (qmail 94113 invoked by uid 500); 6 Jun 2010 17:41:50 -0000
Delivered-To: apmail-openjpa-dev-archive@openjpa.apache.org
Received: (qmail 94068 invoked by uid 500); 6 Jun 2010 17:41:49 -0000
Mailing-List: contact dev-help@openjpa.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:dev-help@openjpa.apache.org>
List-Unsubscribe: <mailto:dev-unsubscribe@openjpa.apache.org>
List-Post: <mailto:dev@openjpa.apache.org>
List-Id: <dev.openjpa.apache.org>
Reply-To: dev@openjpa.apache.org
Delivered-To: mailing list dev@openjpa.apache.org
Received: (qmail 94060 invoked by uid 99); 6 Jun 2010 17:41:49 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 06 Jun 2010 17:41:49 +0000
X-ASF-Spam-Status: No, hits=2.5 required=10.0
	tests=AWL,FREEMAIL_ENVFROM_END_DIGIT,FREEMAIL_FROM,RCVD_IN_DNSWL_NONE,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of fakod666@googlemail.com
 designates 74.125.82.174 as permitted sender)
Received: from [74.125.82.174] (HELO mail-wy0-f174.google.com) (74.125.82.174)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 06 Jun 2010 17:41:44 +0000
Received: by wyi11 with SMTP id 11so2163092wyi.33
        for <dev@openjpa.apache.org>; Sun, 06 Jun 2010 10:41:22 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=googlemail.com; s=gamma;
        h=domainkey-signature:mime-version:received:received:in-reply-to
         :references:date:message-id:subject:from:to:content-type
         :content-transfer-encoding;
        bh=0Ann0pkHWDHdpAPad0/TNcqj3bjMAjUN553789nH+yE=;
        b=BHim9UHaAiooY+k7yngFFzWYU1CxsvGb3fZSOx8twWIic6A3wMzomYZvFgzNo/ddxa
         Qtx2YMpZwDXCS8Ne3CtfVJNLdDcaec9ykrstPY+Tnl37SXIGWY8780v+CI7qE4BmYk5j
         YgJx+i9K46r+MKk7R8JFbiC5zpWrtO1OdRTUE=
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=googlemail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type:content-transfer-encoding;
        b=LqdBzCtHmXsvzugkJ3h0mo46TANrqiW0nljWKrERGa+xQmVBb4pfEhFe6Wd3BEFFlO
         Uz4gzzuhWjawBucJtqyItxG+vapW6IEMarQ4lGDI9w+URuEwnSuD12J+SiMYK4O1h9zc
         bAESInWFqGc2XLEmTvg2NICW3Dvi7JR3aI7rA=
MIME-Version: 1.0
Received: by 10.216.163.79 with SMTP id z57mr1509011wek.17.1275846082405;
 Sun,
	06 Jun 2010 10:41:22 -0700 (PDT)
Received: by 10.216.36.194 with HTTP; Sun, 6 Jun 2010 10:41:22 -0700 (PDT)
In-Reply-To: <AANLkTikk0k0BmZ2RusRJfpgHpJXSpCF_sucEktX6PQFl@mail.gmail.com>
References: <AANLkTikk0k0BmZ2RusRJfpgHpJXSpCF_sucEktX6PQFl@mail.gmail.com>
Date: Sun, 6 Jun 2010 19:41:22 +0200
Message-ID: <AANLkTinXQUGpcY0CKzdV_VOuYo--O-m6UhmGNh6cXrP1@mail.gmail.com>
Subject: Fwd: relation "mySequence" already exists
From: Christopher Schmidt <fakod666@googlemail.com>
To: dev@openjpa.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

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=3D"openjpa.jdbc.SynchronizeMappings"
value=3D"buildSchema(SchemaAction=3D'drop,add')"/>

The entity is defined as follows:

@Entity
@Table(name =3D "obj_item")
@Inheritance(strategy =3D InheritanceType.JOINED)
@SequenceGenerator(name =3D "obj_item_id_seq", sequenceName =3D
"obj_item_id_seq", allocationSize =3D 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=3D0, state=3D42P07]
=A0 =A0 =A0 =A0at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTo=
ol.java:556)...

I found a bug here: https://issues.apache.org/jira/browse/OPENJPA-1259

Any advice?

Regards Christopher