Symptoms

One or more SQL Macro returns the following error:

java.sql.SQLRecoverableException

Cause

Your connection (part of a connection pool) is being terminated between queries.

Resolution

Add a validation query to your configuration. This helps the application server connection pool recover from database connection problems.

validationQuery="Select 1"