Rick O'Sullivan (
https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=712020%...
) *created* an issue
Hibernate ORM (
https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZjY2MGFmMDll...
) / Bug (
https://hibernate.atlassian.net/browse/HHH-17032?atlOrigin=eyJpIjoiZjY2MG...
) HHH-17032 (
https://hibernate.atlassian.net/browse/HHH-17032?atlOrigin=eyJpIjoiZjY2MG...
) H2 Database: PostgreSQL Dialect Mode (
https://hibernate.atlassian.net/browse/HHH-17032?atlOrigin=eyJpIjoiZjY2MG...
)
Issue Type: Bug Affects Versions: 6.2.7 Assignee: Unassigned Components: hibernate-core
Created: 03/Aug/2023 15:05 PM Environment:
org.hibernate.orm:hibernate-core:jar:6.2.7.Final
com.h2database:h2:jar:2.2.220
openjdk version "17.0.8" 2023-07-18
Ubuntu 22.04.2 LTS Priority: Minor Reporter: Rick O'Sullivan (
https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=712020%...
)
I use the H2 database in PostgreSQL mode, in development.
# H2 PostgreSQL Mode: h2db database in local file.
jakarta.persistence.jdbc.driver=org.h2.Driver
jakarta.persistence.jdbc.user=tester
jakarta.persistence.jdbc.password=123456
jakarta.persistence.jdbc.url=jdbc:h2:file:./target/test-database/h2db;MODE=PostgreSQL
hibernate.dialect=org.hibernate.dialect.PostgreSQL10Dialect
I just updated my Hibernate dependencies to 6.x from 5.x. Specifically, to 6.2.7.Final.
When I use PostgreSQL10Dialect, I get this warning:
WARN deprecation - HHH90000026: PostgreSQL10Dialect has been deprecated; use
org.hibernate.dialect.PostgreSQLDialect instead
But when I use PostgreSQLDialect, I get this warning:
WARN Dialect - HHH000511: The 2.2.0 version for [org.hibernate.dialect.PostgreSQLDialect]
is no longer supported, hence certain features may not work properly. The minimum
supported version is 10.0.0. Check the community dialects project for available legacy
versions.
What is the plan, going forward, to select a Hibernate dialect for H2 in PostgreSQL mode?
I would like to use a proper dialect setting that does not produce a warning.
Note: H2 (
http://www.h2database.com/html/features.html#compatibility ) supports
several SQL modes: IBM DB2, Apache Derby, HSQLDB, MS SQL Server, MySQL,
Oracle, and PostgreSQL.
I am concerned that the deprecated PostgreSQL10Dialect will be removed before H2 SQL Modes
is supported by Hibernate dialects.
(
https://hibernate.atlassian.net/browse/HHH-17032#add-comment?atlOrigin=ey...
) Add Comment (
https://hibernate.atlassian.net/browse/HHH-17032#add-comment?atlOrigin=ey...
)
Get Jira notifications on your phone! Download the Jira Cloud app for Android (
https://play.google.com/store/apps/details?id=com.atlassian.android.jira....
) or iOS (
https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=Em...
) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100233- sha1:3ea1a2a )