[OPENJPA-2196] Create Sequence Postgres 9.1

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.2.0
• Fix Version/s: 2.2.2, 2.2.1.1, 2.3.0
• Component/s: jdbc, jpa
• Environment: OpenJPA-2.2.0; Transaction-type JTA; Postgres 9.1; JBoss 6.1
• Patch Info: Patch Available
• Assignee: Albert Lee
• Reporter: Hendi Marcos Ramos Silva
• Created: 16/May/12 08:41
• Updated: 09/Nov/13 00:47
• Resolved: 25/Jul/12 22:40

Description

Sorry my bad english ..

when annotated a entity with @SequenceGenerator and with allocationSize = 1 and initialValue = 1, the method DBDictionary.commonCreateAlterSequenceSQL is creating a alter sequence sql invalid for Postgres 9.1.
Despite the documentation of postgres inform you that the other parameters 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 connection is marked for rollback and not allowing run the next val of sequence.

Hêndi Marcos

Issue Links

• is related to: OPENJPA-1376 @SequenceGenerator allocationSize incorrect implementation
• is related to: OPENJPA-2069 Natvie sequence problems uncovered after OPENJPA-1376
• is related to: OPENJPA-2450 Option to disable execution of ALTER SEQUENCE...INCREMENT BY statement for sequences.