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
