Hello.
Hibernate produces wrong SQL for H2 because
H2IdentityColumnSupport.getIdentityInsertString() incorrectly returns
"null" instead of "default" for a some historic reason.
`getIdentitySelectString() also needs to be updated.
There is a workaround described in another thread, but actually t
On 2021/12/02 9:59 am, Andrea Spacca wrote:
without `MODE=PostgreSQL` and with `org.hibernate.dialect.H2Dialect` I get the
following error:
```
ERROR: NULL not allowed for column "ID"; SQL statement:
insert into users (id, password, session_id, username) values (null, ?, ?, ?)
[23502-202]
`
I saw the change in 2.0.202 and tried with that version
without `MODE=PostgreSQL` and with `org.hibernate.dialect.H2Dialect` I get
the following error:
```
ERROR: NULL not allowed for column "ID"; SQL statement:
insert into users (id, password, session_id, username) values (null, ?, ?,
?) [23502
Hello.
H2 2.0.202 has INFORMATION_SCHEMA.SEQUENCES.START_VALUE, but usage
of PostgreSQL***Dialect with H2 may still fail at any point, H2 should only
be used with H2Dialect.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from t