I've got a grails project and my configuration indicates a mysql database:

    environments {
        development {
            dataSource {
                dbCreate = "update"
                url = "jdbc:mysql://localhost/mydb"
                driverClassName = "com.mysql.jdbc.Driver"
                username = "root"
                password = "mypass"
                hibernate.dialect = "org.hibernate.dialect.MySQLDialect"

When Grails runs, (using grails dev run-app or grails run-app) it's not hooking up for this development atmosphere whatsoever, but rather is applying a default development atmosphere. I understand this because no data within the mydb database is visible, and new records in to the db aren't endured in mydb. What shall we be held doing wrong?


I recieve some error messages on startup contributing me to believe that it is really loading the best database:

2011-06-20 13:15:00,603 [main] ERROR hbm2ddl.SchemaUpdate  - Unsuccessful: alter table X add index FK9DBE53031937164 (a_id), add constraint FK9DBE53031937164 foreign key (a_id) references Y (id)
2011-06-20 13:15:00,607 [main] ERROR hbm2ddl.SchemaUpdate  - Can't create table 'mydb.#sql-2db_215' (errno: 150)

but see no indication this would make it relax towards the default Grails atmosphere or anything like this. Could this be related?


Config.groovy has got the following:

environments {
        grails.server.port.http = 9091


however the application still operates on 8080.

It was really my problem (user error). It had been pointing properly towards the correct database, but a number of problems triggered the data to become written to some place that managed to get seem like it had not been being written. My fault! Just help.