Hibernate dialect Issue with update to Oracle 12.2 C database

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

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

--
You received this message because you are subscribed to the Google Groups "Grails Dev Discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To post to this group, send email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/grails-dev-discuss/1559576607238-0.post%40n4.nabble.com.
For more options, visit https://groups.google.com/d/optout.
Reply | Threaded
Open this post in threaded view
|

Re: Hibernate dialect Issue with update to Oracle 12.2 C database

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 10gorg.hibernate.dialect.Oracle10gDialect
Oracle 11gorg.hibernate.dialect.Oracle10gDialect




On Wednesday, June 5, 2019 at 11:17:16 PM UTC-4, dev.ray wrote:
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: <a href="http://grails.1312388.n4.nabble.com/Grails-Dev-Discuss-f4657524.html" target="_blank" rel="nofollow" onmousedown="this.href=&#39;http://www.google.com/url?q\x3dhttp%3A%2F%2Fgrails.1312388.n4.nabble.com%2FGrails-Dev-Discuss-f4657524.html\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNGvmIco5BVnpCNuYkBxqqAJaqxKDw&#39;;return true;" onclick="this.href=&#39;http://www.google.com/url?q\x3dhttp%3A%2F%2Fgrails.1312388.n4.nabble.com%2FGrails-Dev-Discuss-f4657524.html\x26sa\x3dD\x26sntz\x3d1\x26usg\x3dAFQjCNGvmIco5BVnpCNuYkBxqqAJaqxKDw&#39;;return true;">http://grails.1312388.n4.nabble.com/Grails-Dev-Discuss-f4657524.html

--
You received this message because you are subscribed to the Google Groups "Grails Dev Discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To post to this group, send email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/grails-dev-discuss/529f54b1-a0f3-4ac5-8f04-6c5ab3f6ffe3%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Phill M Nacelli
Senior Software Architect, Solutions Lead
AboutWeb, LLC
Rockville, MD
Online: www.aboutweb.com

Reply | Threaded
Open this post in threaded view
|

Re: Hibernate dialect Issue with update to Oracle 12.2 C database

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.



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

--
You received this message because you are subscribed to the Google Groups "Grails Dev Discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To post to this group, send email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/grails-dev-discuss/1560245362556-0.post%40n4.nabble.com.
For more options, visit https://groups.google.com/d/optout.
Reply | Threaded
Open this post in threaded view
|

Re: Hibernate dialect Issue with update to Oracle 12.2 C database

dev.ray
In reply to this post by 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.



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

--
You received this message because you are subscribed to the Google Groups "Grails Dev Discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To post to this group, send email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/grails-dev-discuss/1560245490548-0.post%40n4.nabble.com.
For more options, visit https://groups.google.com/d/optout.