hibernate dialect in groovy

[Manikandan Jayaraman]

Hi

Our DB recently migrated from Oracle10g to 11g. Our application is a groovy/grails application deployed in tcServer. This app was working without a dialect declaration in Oracle10g.

But now we get
===
org.codehaus.groovy.grails.orm.hibernate.exceptions.CouldNotDetermineHibernateDialectException: Could not determine Hibernate dialect for database name [Oracle]!
at java.security.AccessController.doPrivileged(Native Method)
===

I added dialect='org.hibernate.dialect.Oracle10gDialect' to datasource.groovy to make the app work. But this means I will have to redeploy the application and we have lot of grails applications all now pointing to 11g database.

Is there a easy way to mention this dialect configuration somewhere else, like wrapper.conf, which will just need a tcServer restart and not an app deploy?

I tried
===
wrapper.java.additional.16="-Dhibernate.dialect=org.hibernate.dialect.Oracle10gDialect"
===

but this didnt work. Please help.

Thanks!
Mani