A Grails Plugin for Multiple DataSources | An Army of Solipsists

An Army of Solipsists » Blog Archive » A Grails Plugin for Multiple DataSources

There have been a few requests on the Grails user mailing list about using multiple data sources in a Grails app, i.e. some domain classes use one data source and database and others use another. Grails doesn’t directly support this – there’s only one DataSource and one SessionFactory, and all domain classes use them. But it turns out it’s not that difficult to support this (and it doesn’t involve too many ugly hacks …)

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.