mysqlgrailsdatabase-migration

Grails database migrations MySQL changelog not generated


I tried running a database migration on Grails 2.2.1, but it seems to not work.

Running dbm-generate-changelog generated an initial changelog.groovy, but trying to run dbm-gorm-diff after model changes resulted in no file being generated.

Last line that is logged back from Liquibase is:

Sequences not supported for .....

My datasource is set properly and mysql dialect is set to org.hibernate.dialect.MySQL5InnoDBDialect

I tried to find a configuration option to specify directly to Liquibase that MySQL is the target, but it seems that it reads it from datasource.

Any ideas?


Solution

  • There is an issue associated with this http://jira.grails.org/browse/GPDATABASEMIGRATION-120

    As a workaround you can clone https://github.com/ph4t/grails-database-migration and then point to the cloned project from your grails application (BuildConfig.groovy) by using>

    grails.plugin.location.'database-migration' = "<path to cloned folder>"