openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kevin Sutter (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (OPENJPA-2196) Create Sequence Postgres 9.1
Date Wed, 20 Jun 2012 13:50:42 GMT

    [ https://issues.apache.org/jira/browse/OPENJPA-2196?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13397505#comment-13397505
] 

Kevin Sutter edited comment on OPENJPA-2196 at 6/20/12 1:49 PM:
----------------------------------------------------------------

Through another discussion on the OpenJPA mailing list (http://openjpa.208410.n2.nabble.com/Postgres-sequence-current-transaction-is-aborted-td7580299.html),
we've come to the bottom of this issue.  The creation of this "alter sequence.." statement
stops prematurely when it's discovered that the sequence allocation size is not greater than
1.  I think this conditional should be greater than 0 (instead of 1).  Regardless, we have
to be smarter with creating these "create/alter sequence.." statements so that they are complete
before attempting to execute.
                
      was (Author: kwsutter):
    Through another discussion on the OpenJPA mailing list (), we've come to the bottom of
this issue.  The creation of this "alter sequence.." statement stops prematurely when it's
discovered that the sequence allocation size is not greater than 1.  I think this conditional
should be greater than 0 (instead of 1).  Regardless, we have to be smarter with creating
these "create/alter sequence.." statements so that they are complete before attempting to
execute.
                  
> 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.2.1
>
>   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

       

Mime
View raw message