openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Albert Lee (JIRA)" <j...@apache.org>
Subject [jira] [Closed] (OPENJPA-2196) Create Sequence Postgres 9.1
Date Wed, 10 Apr 2013 16:08:15 GMT

     [ https://issues.apache.org/jira/browse/OPENJPA-2196?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Albert Lee closed OPENJPA-2196.
-------------------------------

    
> 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, 2.2.2, 2.2.1.1
>
>         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
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message