openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hendi Marcos Ramos Silva (JIRA)" <>
Subject [jira] [Created] (OPENJPA-2196) Create Sequence Postgres 9.1
Date Wed, 16 May 2012 04:42:15 GMT
Hendi Marcos Ramos Silva created OPENJPA-2196:

             Summary: Create Sequence Postgres 9.1
                 Key: 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
             Fix For: 2.2.1

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 (,
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

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:!default.jspa
For more information on JIRA, see:


View raw message