Re: [h2] Re: hibernate migration an MODE=PostgreSQL

2021-12-02 Thread Evgenij Ryazanov
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

Re: [h2] Re: hibernate migration an MODE=PostgreSQL

2021-12-02 Thread Noel Grandin
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]