Adding .jar to Grails Project Dependencies

Question

I have this project with MSSQL 2008 R2 as the database server. A connection is established and started between the Services IReport view and the database. The problem here is that the project cannot connect to the database server when it starts.

This is the error shown on the grails console before the launch is complete:

ERROR hbm2ddl.SchemaUpdate - unable to complete schema update

I saw a similar case, but the way to resolve it is that the sqljdbc4.jar driver is placed inside the [Project Name]\classpath\Grails Dependencies (explorer project hierarchy), where the driver is located in [Project Name]\lib . But do it the way it is.

I also tried to manually install the dependency after the command below, but grails will return that the driver was not found.

grials> install-dependency sqljdbc4

The question is how to enable the driver depending on Grails?

Answer 1

Assuming you are using Grails 2+, this article should help you. I also had to restart Eclipse before everything really appeared correctly.