Hibernate dialect for Oracle Database 18c?

hibernate oracle-rac oracle18c
Chris picture Chris · Nov 15, 2018 · Viewed 7.8k times · Source

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?

Answer

Ariel Carrera picture Ariel Carrera · Jan 27, 2020

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.

Related questions

What are the possible values of the Hibernate hbm2ddl.auto configuration and what do they do

I really want to know more about the update, export and the values that could be given to hibernate.hbm2ddl.auto I need to know when to use the update and when not? And what is the alternative? These …

Read More
How to fix the Hibernate "object references an unsaved transient instance - save the transient instance before flushing" error

I receive following error when I save the object using Hibernate object references an unsaved transient instance - save the transient instance before flushing

Read More
How to solve the “failed to lazily initialize a collection of role” Hibernate exception

I have this problem: org.hibernate.LazyInitializationException: failed to lazily initialize a collection of role: mvc3.model.Topic.comments, no session or session was closed Here is the model: @Entity @Table(name = "T_TOPIC") public class Topic { @Id @GeneratedValue(strategy=…

Read More