Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major 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

        Issue Links

          Activity

          No work has yet been logged on this issue.

            People

            • Assignee:
              Albert Lee
              Reporter:
              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

                  Development