Tuesday, November 13, 2012

Grails - Connect with mysql

Default Grails connect with HSQLDB. But we need connect mysql
Go to conf folder. Change file DataSoure.groovy


dataSource {
    pooled = true
    driverClassName = "com.mysql.jdbc.Driver"
    username = "root"
    password = "password"
    dialect = "org.hibernate.dialect.MySQL5InnoDBDialect"
}

Go to environment change url database
url = "jdbc:mysql://localhost:3306/racetrack_dev"

Go to file BuildConfig.groovy
uncomment runtime dependencies with mysql 
When run grails will download mysql driver.

Check mysql database

Good luck to you


No comments:

Post a Comment