grails prod run-app connects to mysql but grails prod run-war doesn't
- by damian
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.
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.
