MySQL connections in the database connection pool time out (usually set to 8 hours). Possible
workarounds(?):
1. Increase the time out value and hope that someone will connect to OFBiz
before the connections time out.
2. Fix OFBiz to allow to a "validateQuery" mechanism.
3. Use PostgreSQL.
In Tomcat, we usually use the "validateQuery" so the DBCP will test each connection before giving
it to the application. If all connections in the pool has timed out (say no one has accessed OFBiz
in 8 hours), the DBCP creates new connections for the pool.
If someone will tell me that this doesn't happen for PostgreSQL, I'll simply make the switch to
PostgreSQL rather than fix things in OFBiz for MySQL.
Thanks.
Jonathon
