Hibernate 6.6 and OracleDB 11.2

Hibernate ORM
1

Hi All,
I’m using quarkus 3.15 with hibernate 6.6 and as per documentation (OracleDialect (Hibernate Javadocs)) it should support Oracle DB v 11.2 but it’s not the case:
I’ve a paged query and hibernate is adding

offset ? rows fetch first ? rows only

at the end and this is not a valid dialect for 11.2

the only way I managed to make it work was to add hibernate-community-dialects:6.6.0 dependency. I find curious that in org.hibernate.dialect.OracleDialect the minimum version is set to 19 but the description says dialect for Oracle 11g and above.

is this intended or a bug?

2

The documentation is outdated. Support for Oracle 11 was dropped a while ago.

3

Hi, do you know if hibernate 6.2.19final supports oracle 11.2?

4

Oracle 11 “support” was dropped in the OracleDialect starting with Hibernate ORM 6.4 through HHH-17090, but note that the OracleLegacyDialect in the hibernate-community-dialects module still contains all the code for the older versions, it just isn’t supported by the Hibernate ORM team anymore. Also read hibernate-orm/dialects.adoc at main · hibernate/hibernate-orm · GitHub

Even though Hibernate ORM 6.2 still treated Oracle 11.2 as “supported”, you can only receive bug fixes or support for that Oracle version if you are a Red Hat or IBM customer. Even then, it is debatable if it makes sense to “support” a database that is out of support by Oracle themselves though, so chance are, you might not get any support at all anyways.