Update SQL error code mapping for H2 1.3.154 [SPR-8235]

[spring-projects-issues]

Oleg Alexeyev opened SPR-8235 and commented

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.

---

Affects: 3.0.5

Issue Links:

• org.h2.jdbc.JdbcSQLException: NULL nicht zulässig für Feld "xyz" gets translated to org.springframework.jdbc.UncategorizedSQLException [SPR-7480] #12138 org.h2.jdbc.JdbcSQLException: NULL nicht zulässig für Feld "xyz" gets translated to org.springframework.jdbc.UncategorizedSQLException

[spring-projects-issues]

Juergen Hoeller commented

Thomas, could you have a look at this please?

Juergen

[spring-projects-issues]

Juergen Hoeller commented

Backported to 3.0.7, for release in late December.

Juergen