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?