Hibernate dialect for Oracle Database 18c

hibernateoracle-racoracle18c

Is there a Hibernate dialect for Oracle Database 18c? Or should I use the org.hibernate.dialect.Oracle12cDialect that ships with Hibernate?

When using Hibernate 5.3 and Oracle 18c RAC is there anything special the application has to take care of?

Best Answer

At the time of writing this comment with the latest version of Hibernate (5.4.10), there is no official dialect for Oracle18 in Hibernate.

When there are no major differences in the Database dialect, a special dialect is not usually created for him in Hibernate.

For example, I used the Oracle10 dialect with Oracle11 without major problems in production environments. The same for Oracle 18, the Oracle12 dialect should work without major problems.

Keep in mind that Oracle release numbers are no longer numbered as in the past, and today they are related to the release year (so the larger number does not mean exactly that there are major changes in your dialect).

About Oracle Database release numbers: release number

As a comment, if you don't use the new features of Oracle 18, there is also the possibility of configuring Oracle to be compatible with a certain previous version (11 or 12 in this case). However, it is recommend not to use this config if it's possible solved with a custom Dialect or modifying your software.

About Oracle Database Compatible parameter: compatible parameter

I hope this helps others who are looking for the same.