Tweaking The Grails Datasource To Cope With MySQL’s Foibles – Transentia

Tweaking The Grails Datasource To Cope With MySQL’s Foibles – Transentia

The application I am maintaining is falling prey to MySQL’s infamous “kill connections after 8 hours of inactivity” feature.
The users arrive each morning to find that their application is unworkable, ‘cos all the connections have “gone away.”
This IS a feature and not a bug, and it does make sense (the server has to manage its resources appropriately [for it] and 8 hours is as good a timeout as 1 or 1000)…but it is darned inconvenient, nonetheless.