I want to use H2 in PostgreSQL mode + Hibernate 6. However, I am not sure about 
driver and dialect settings for Hibernate:

url - 
jdbc:h2:tcp://localhost/db;MODE=PostgreSQL;DATABASE_TO_LOWER=TRUE;DEFAULT_NULL_ORDERING=HIGH"
driver - org.h2.Driver
dialect - org.hibernate.dialect.H2Dialect

I was told to to use H2Dialect for such situation, but not(PostgreSQLDialect). 
However, I don't understand why.

When we work with Hibernate then Hibernate will generate SQL code and if we set 
PostgreSQL mode for H2 then
we need to configure Hibernate generate PosgreSQL SQL code, don't we?

Best regards, Pavel

--
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/h2-database/af2ea905-ca59-25ed-2860-28070d813aef%40gmail.com.

Reply via email to