Return-Path: X-Original-To: apmail-openjpa-dev-archive@www.apache.org Delivered-To: apmail-openjpa-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 8FAA610614 for ; Wed, 10 Apr 2013 16:08:15 +0000 (UTC) Received: (qmail 84114 invoked by uid 500); 10 Apr 2013 16:08:15 -0000 Delivered-To: apmail-openjpa-dev-archive@openjpa.apache.org Received: (qmail 84073 invoked by uid 500); 10 Apr 2013 16:08:15 -0000 Mailing-List: contact dev-help@openjpa.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@openjpa.apache.org Delivered-To: mailing list dev@openjpa.apache.org Received: (qmail 84063 invoked by uid 99); 10 Apr 2013 16:08:15 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 10 Apr 2013 16:08:15 +0000 Date: Wed, 10 Apr 2013 16:08:15 +0000 (UTC) From: "Albert Lee (JIRA)" To: dev@openjpa.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Closed] (OPENJPA-2196) Create Sequence Postgres 9.1 MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/OPENJPA-2196?page=3Dcom.atlass= ian.jira.plugin.system.issuetabpanels:all-tabpanel ] Albert Lee closed OPENJPA-2196. ------------------------------- =20 > Create Sequence Postgres 9.1 > ---------------------------- > > Key: OPENJPA-2196 > URL: https://issues.apache.org/jira/browse/OPENJPA-2196 > Project: OpenJPA > Issue Type: Bug > Components: jdbc, jpa > Affects Versions: 2.2.0 > Environment: OpenJPA-2.2.0 > Transaction-type JTA > Postgres 9.1 > JBoss 6.1 > Reporter: Hendi Marcos Ramos Silva > Assignee: Albert Lee > Fix For: 2.3.0, 2.2.2, 2.2.1.1 > > Attachments: OPENJPA-2196-2.2.0.patch > > Original Estimate: 4h > Remaining Estimate: 4h > > Sorry my bad english .. > when annotated a entity with @SequenceGenerator and with allocationSize = =3D 1 and initialValue =3D 1, the method DBDictionary.commonCreateAlterSequ= enceSQL is creating a alter sequence sql invalid for Postgres 9.1. > Despite the documentation of postgres inform you that the other parameter= s are optional (http://www.postgresql.org/docs/9.1/static/sql-altersequence= .html), an error occurs in executing the sql below. > Eg: ALTER SEQUENCE schema_experimento.usuario_sq (no other attributes) > Even the method NativeJDBCSeq.udpateSql being fault tolerant, the connect= ion is marked for rollback and not allowing run the next val of sequence. > H=C3=AAndi Marcos -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrato= rs For more information on JIRA, see: http://www.atlassian.com/software/jira