HowTo set autoReconnect = true on the Data Source configuration

[cfrerebeau]

Hi,

My Grails application is getting some Exception after a long time of inactivity (~ one day). I solved this issue in another environment by settings the autoReconnect to true in the Data Source configuration (either via Grails or via a JNDI DataSource config).

However it seems that this settings in Grails is not taken into consideration once deployed with cloudFoundry.

I guess CloudFoundry redefine a new DataSource to enable load balancing among the Database instances. Is there a way to set this parameter, or would you suggest another approach?

My application is mainly used during business hours, and thus this exception frequently occured on Monday morning.

Thank you
Christophe

[ceracm]

Christophe,

Not sure what is happening here.
We are not redefining DataSources that you specify in your DataSource.groovy file.
What is the specific exception that is being thrown?

Chris

[cfrerebeau]

My mistake, I found out some occurences of the same issue in my test environment, so there is nothing to do with cloudFoundry.

Thanks for your quick reply.