Using the Weceem plugin. After periods of inactivity I get a java.sql.SQLException: Connection is closed error. I normally handle this with DBCP properties in DataSource.groovy thusly:
Joined: 04/06/2009 13:36:35
Messages: 303
Location: UK
Offline
Hi Gary,
It sounds like something is returning a stale connection. Weceem does nothing special here, its all plain Grails GORM.
DBCP pool has known issues however. I suggest you try using the Tomcat-pool (there is a grails plugin for it) that apparently performs and works better.
However you might also want to verify that your production system is running with a good up to date MySQL JDBC driver.