openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hendi Marcos Ramos Silva (JIRA)" <j...@apache.org>
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
                 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
             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 (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

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

Mime
View raw message