Hi,
I have a unexpected problem.
I had create a war with grails war. Then I had deployed in Tomcat.
For my surprise the crud works fine but I don't know what persistence is using, because it isn't use the mysql database I had configurate.
I know that because it doesn't list the data in the database.
So I did this test: Compare grails prod run-app with grails prod run-war. The first works fine, and does conect with the mysql database. The other don't.
This is my DataSource.groovy:
dataSource {
pooled = true
driverClassName = "com.mysql.jdbc.Driver"
username = "grails"
password = "mysqlgrails"
}
hibernate {
cache.use_second_level_cache=false
cache.use_query_cache=false
cache.provider_class='net.sf.ehcache.hibernate.EhCacheProvider'
}
// environment specific settings
environments {
development {
dataSource {
dbCreate = "update" // one of 'create', 'create-drop','update'
url = "jdbc:mysql://some-key.amazonaws.com/MyDB"
}
}
test {
dataSource {
dbCreate = "update" // one of 'create', 'create-drop','update'
url = "jdbc:mysql://some-key.amazonaws.com/MyDB"
}
}
production {
dataSource {
dbCreate = "update"
url = "jdbc:mysql://some-key.amazonaws.com/MyDB"
}
}
}
Also I extract the war to see if I could find some data source configuration file without success.
More info: Grails version: 1.2.1 JVM version: 1.6.0_17
Also I think this question it's similar, but doesn't have a awnser.