org.codehaus.groovy.grails.orm.hibernate.exceptions.CouldNotDetermineHibernateDialectException: Could not determine Hibernate dialect - oracle

Hi,

If you are getting following exception,

org.codehaus.groovy.grails.orm.hibernate.exceptions.CouldNotDetermineHibernateDialectException: Could not determine Hibernate dialect for database name [Oracle]!

at org.grails.tomcat.TomcatServer.start(TomcatServer.groovy:135)

at grails.web.container.EmbeddableServer$start.call(Unknown Source)

at _GrailsRun_groovy$_run_closure5_closure12.doCall(_GrailsRun_groovy:158)

at _GrailsRun_groovy$_run_closure5_closure12.doCall(_GrailsRun_groovy)

at _GrailsSettings_groovy$_run_closure10.doCall(_GrailsSettings_groovy:287)

at _GrailsSettings_groovy$_run_closure10.call(_GrailsSettings_groovy)

at _GrailsRun_groovy$_run_closure5.doCall(_GrailsRun_groovy:149)

at _GrailsRun_groovy$_run_closure5.call(_GrailsRun_groovy)

at _GrailsRun_groovy.runInline(_GrailsRun_groovy:115)

at _GrailsRun_groovy.this$4$runInline(_GrailsRun_groovy)

at _GrailsRun_groovy$_run_closure1.doCall(_GrailsRun_groovy:59)

at RunApp$_run_closure1.doCall(RunApp.groovy:33)

at gant.Gant$_dispatch_closure4.doCall(Gant.groovy:324)

at gant.Gant$_dispatch_closure6.doCall(Gant.groovy:334)

at gant.Gant$_dispatch_closure6.doCall(Gant.groovy)

at gant.Gant.withBuildListeners(Gant.groovy:344)

at gant.Gant.this$2$withBuildListeners(Gant.groovy)

at gant.Gant$this$2$withBuildListeners.callCurrent(Unknown Source)

at gant.Gant.dispatch(Gant.groovy:334)

at gant.Gant.this$2$dispatch(Gant.groovy)

at gant.Gant.invokeMethod(Gant.groovy)

at gant.Gant.processTargets(Gant.groovy:495)

at gant.Gant.processTargets(Gant.groovy:480)

It might be becuase your hibernate dialect for database oracle is not set properly.

You need to add this line dialect='org.hibernate.dialect.Oracle10gDialect' in your database configuration file for your grail application in datasource part.

Please take a note it must be added to datasource part not hibernate part.

I hope this helps.

Regards

Rahul Teni