How to avoid CouldNotDetermineHibernateDialectException error?

This problem happened for java version 1.7.0_25. By upgrading java 1.7.0_25 to another upper version will help you to resolve the issue. Sometimes downgrade to 1.6.X also works. But upgrading is best solution.

It is fixed in Grails 2.2.3. But in Grails 2.2.3, It is still broken for OpenJDK 1.7.0_25 on Linux, Oracle's JDK does work though.

Credit goes to @aeischeid

A step by step solution is given in this tutorial:Connect Grails with Oracle 11g Example Configuration

Resource Link:

1. How do I avoid 'Could not determine Hibernate dialect for databasename [H2]!'?

UPDATE

Suggestion - 1:

From this tutorial, I got two suggestions, please try this 2 issues-You need to install the Grails H2 plugin. Add

compile ":h2:0.2.6"

to grails-app/conf/BuildConfig.groovy, in the plugins block.

Suggestion - 2:

In DataSource.groovy, they are case sensitive. So please check is there anything(like username or others) with case mismatching.

Resource Link: MASSIVE ERROR ON GRAILS RUN-APP

Suggestion - 3:

danielnaber gives some suggestionsgrails compile --refresh-dependencies and/or grails clean might help.You will need to configure database access in grails-app/conf/DataSource.groovy (development for grails run-app and production for grails war)

Suggestion - 4:

From this tutorialRemove your DataSource.groovy file and rebuild the WAR after doing a grails clean, which will disable the default file based data source

Currently it is trying to create a database on the file system but failing because you do not have the permission to do so.

Suggestion - 5:

You can take a look in https://github.com/Netflix/Lipstick/issues/8

Suggestion - 6:

While you're in there you should fix the cache provider warning you're seeing too - change the value for 'cache.provider_class' in the hibernate block to

   cache.provider_class = 'net.sf.ehcache.hibernate.EhCacheProvider' 

Please give a try of 6 suggestions. Hope it can help you.