Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.2.0
    • Fix Version/s: 2.2.2, 2.2.1.1, 2.3.0
    • Component/s: jdbc, jpa
    • Labels:
      None
    • Environment:
      OpenJPA-2.2.0
      Transaction-type JTA
      Postgres 9.1
      JBoss 6.1
    • Patch Info:
      Patch Available

      Description

      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

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                allee8285 Albert Lee
                Reporter:
                hendimarcos Hendi Marcos Ramos Silva
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 4h
                  4h
                  Remaining:
                  Remaining Estimate - 4h
                  4h
                  Logged:
                  Time Spent - Not Specified
                  Not Specified