Uploaded image for project: 'Spring Framework'
  1. Spring Framework
  2. SPR-8235

Update SQL error code mapping for H2 1.3.154

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.0.5
    • Fix Version/s: 3.0.7, 3.1 RC1
    • Component/s: Data
    • Labels:
      None
    • Last commented by a User:
      false

      Description

      Since H2 1.3.154 SQL error codes has changed in order to utilize commonly used ones. See the thread: http://groups.google.com/group/h2-database/browse_thread/thread/e4f6e77e3eebc1d4 and the change log: http://www.h2database.com/html/changelog.html.

      This makes duplicate key condition undetected, DataIntegrityViolationException is thrown instead of DuplicateKeyException.

      In order to fix this error code 23505 needs to be added to duplicateKeyCodes property of H2 bean in org/springframework/jdbc/support/sql-error-codes.xml.

        Issue Links

          Activity

          Hide
          juergen.hoeller Juergen Hoeller added a comment -

          Thomas, could you have a look at this please?

          Juergen

          Show
          juergen.hoeller Juergen Hoeller added a comment - Thomas, could you have a look at this please? Juergen
          Hide
          juergen.hoeller Juergen Hoeller added a comment -

          Backported to 3.0.7, for release in late December.

          Juergen

          Show
          juergen.hoeller Juergen Hoeller added a comment - Backported to 3.0.7, for release in late December. Juergen

            People

            • Assignee:
              thomas.risberg Thomas Risberg
              Reporter:
              blacklion Oleg Alexeyev
              Last updater:
              Trevor Marshall
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                5 years, 51 weeks, 4 days ago