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

[spring-projects-issues]

Axel Fontaine opened SPR-7480 and commented

When trying to insert a NULL value into a NOT NULL column

H2 Returns org.h2.jdbc.JdbcSQLException: NULL nicht zulässig für Feld "xyz"
Spring translates it to org.springframework.jdbc.UncategorizedSQLException

On Oracle and HsqlDB, Spring correctly translates this case to org.springframework.dao.DataIntegrityViolationException

---

Affects: 3.0.4

Issue Links:

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

[spring-projects-issues]

Axel Fontaine commented

The same also occurs with MySQL

MySQL returns java.sql.SQLException: Field 'xyz' doesn't have a default value
Spring translates it to org.springframework.jdbc.UncategorizedSQLException