pentaho/pentaho-platform — pull request #357 by pedrofvteixeira (2013-04-18 10:00:53+00:00)
Title: BISERVER-4248 DBCP BasicDataSource configuration doesn't have pool options set - MySQL timeouts will result

In trunk, changes to the applicationContext-*hibernate* and *jdbc* will result in mysql timeouts after the connection gets stale.

1- Settings need to be added that include the connection check query - for mysql, this should be set to "/* ping */select 1". For others, see the connection check queries in the hibernate files.

2- The settings also should include minimum/maximum idle, maximum connections, etc. For this login stuff, I'm going to suggest a minimum idle of 0, and a max idle of 4. Other pool settings should be in there too.