Hibernate dialect Issue with update to Oracle 12.2 C database

[dev.ray]

Hi Everyone,

We are running Grails 2.3.11 on JRE 1.8_211. We have Hibernate version -
3.6.10.6.
When we were working with Oracle 11, it was working fine but when I upgrade
to 12.2C, I get following error:-

org.codehaus.groovy.grails.orm.hibernate.exceptions.CouldNotDetermineHibernateDialectException:
Could not determine Hibernate dialect for database name [Oracle]!
On reverting back to Oracle 11, the issue gets resolved.

Can anyone please suggest a solution for the same.



--
Sent from: http://grails.1312388.n4.nabble.com/Grails-Dev-Discuss-f4657524.html

[Phill Nacelli]

Just checking, what dialect configuration do you have when running with 12C? It should not have changed, notice the docs still has it at 10g.  So check if it was modified:

Oracle 10g	org.hibernate.dialect.Oracle10gDialect
Oracle 11g	org.hibernate.dialect.Oracle10gDialect

https://docs.jboss.org/hibernate/orm/3.6/reference/en-US/html/session-configuration.html#configuration-optional-dialects

[dev.ray]

We had not specified the hibernate dialect in one of the datasources in
datasource.groovy.

It seems that in oracle 12C, it is mandatory to specify the dialect for each
data source even though it is not mandatory for Oracle 11g.

Hence, during migrating from Oracle 11g to Oracle 12C, please add verifying
that dialects are explicitly specified in your checklist.

Hope this helps others.

[dev.ray]

We had not specified the hibernate dialect in one of the datasources in
datasource.groovy.

It seems that in oracle 12C, it is mandatory to specify the dialect for each
data source even though it is not mandatory for Oracle 11g.

Hence, during migrating from Oracle 11g to Oracle 12C, please add verifying
that dialects are explicitly specified in your checklist.

Hope this helps others.