You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openjpa.apache.org by "Albert Lee (JIRA)" <ji...@apache.org> on 2012/07/25 20:40:34 UTC
[jira] [Resolved] (OPENJPA-2196) Create Sequence Postgres 9.1
[ https://issues.apache.org/jira/browse/OPENJPA-2196?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Albert Lee resolved OPENJPA-2196.
---------------------------------
Resolution: Fixed
Fix Version/s: (was: 2.2.1)
2.3.0
I only commit the fix in trunk (2.3.0). If you need fixes in 2.2.x, you need to work with the release manager for inclusion. 2.2.x is a maintenance release for WebSphere, one can request a service call to the WebSphere product, if needed.
> 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
>
> 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 = 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