OpenJPA
  1. OpenJPA
  2. OPENJPA-1935

Informix lock exceptions are not mapped properly by OpenJPA

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 2.1.0, 2.2.0
    • Fix Version/s: 2.1.0, 2.2.0
    • Component/s: jdbc
    • Environment:
      Informix IDS 10 and IDS 11

      Description

      Locking type failures are not mapped correctly when using Informix with OpenJPA. When a SQLException with generic sql state value 'IX000' is returned, it gets mapped to a query exception. Instead, the underlying SQLException(s) should be inspected for specific lock or lock timeout sql codes to determine the correct exception type.

        Activity

        Hide
        Pinaki Poddar added a comment -

        IX000 is specified as query error for Informix in sql-error-state-codes.xml. See DBDictionary.narrow(...) to overwrite for Informix.

        Show
        Pinaki Poddar added a comment - IX000 is specified as query error for Informix in sql-error-state-codes.xml. See DBDictionary.narrow(...) to overwrite for Informix.
        Hide
        Jeremy Bauer added a comment -

        Thanks, Pinaki. I have a fix brewing down the DBDictionary.narrow path. It actually overwrites matchErrorState (called by narrow to determine the exception type) and fixes isFatalException which is also semi-broken in the Informix dictionary. I just need to finish cleaning up the jUnits before posting a fix...

        Show
        Jeremy Bauer added a comment - Thanks, Pinaki. I have a fix brewing down the DBDictionary.narrow path. It actually overwrites matchErrorState (called by narrow to determine the exception type) and fixes isFatalException which is also semi-broken in the Informix dictionary. I just need to finish cleaning up the jUnits before posting a fix...
        Hide
        Albert Lee added a comment -

        Close issue in preparation for 2.2.0 release.

        Show
        Albert Lee added a comment - Close issue in preparation for 2.2.0 release.

          People

          • Assignee:
            Jeremy Bauer
            Reporter:
            Jeremy Bauer
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development