Upgrade H2 version 2.0.204 from 1.4.200

[emircankilinc-oviva]

Hi, we are trying to upgrade 2.0.204 from 1.4.200 because of vulnerability. We are using latest quarkus version. But we are getting an error related with running our entity manager tests. While persisting data we are getting below error. Could you any suggest for that?

Error :

- javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute statement

- Caused by: org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException: 
   NULL not allowed for column "ID"; SQL statement:

And also we are using id like :

  @Id
  @GeneratedValue(strategy = GenerationType.IDENTITY)
  private int id;

There was no problem with 1.4.200 version. All test cases work. But now all entity manager tests failed.

[katzyn]

It is a bug of Hibernate ORM, it produces invalid SQL for H2 for unknown reason:
https://hibernate.atlassian.net/browse/HHH-14985
hibernate/hibernate-orm#4524

You can try to append ;MODE=LEGACY to JDBC URL as a temporary workaround, it this mode H2 accepts incorrect attempts to insert NULL into identity column.

But you may run into some other issue like
https://hibernate.atlassian.net/browse/HHH-15009
It that case you can try to add ;OLD_INFORMATION_SCHEMA=TRUE, maybe it will help, maybe not.