For a long-running, stable configuration of the WebSphere JDBC Connection Pool for a database (DB2, Oracle, SQL Server 2005), there are additional configuration steps that can be performed.
1) Enable pre-testing of pooled connections
2) Enable pre-testing of existing pooled connections
In the WebSphere Admin Console, navigate to JDBC providers->[Your_JDBC_Provider_Name]->Data sources->[Your_JDBC_Data_Source_Name]->WebSphere Application Server data source properties.
Check the checkbox for “Pretest existing pooled connections”
Check the checkbox for Pretest new connections.
In the “Pretest SQL string” field, enter:
SELECT COUNT(*) FROM LCDB2.EDCVERSIONENTITY.
Replace “LCDB2” with the actual name of your schema.
Apply and save the changes.
Repeat this for all of LiveCycle’s data sources (IDP_DS, EDC_DS, JMS_DS).
Re-start the WebSphere appserver instances that host LiveCycle.