Sorry, it's "validationQuery", not validateQuery.
Jonathon
Jonathon -- Improov wrote:
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
