SA-13936

Summary

A stale connection error is generated repeatedly in the PegaRULES and Application server log file.

Error Messages

[7/27/15 16:14:06:762 EDT] 0000010a WSJdbcConnect W DSRA8650W: Error closing a JDBC child wrapper, com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement@8f1ca577
com.ibm.websphere.ce.cm.StaleConnectionException: Closed Statement
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:80)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:57)
at java.lang.reflect.Constructor.newInstance(Constructor.java:539)
at com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapExceptionHelper(GenericDataStoreHelper.java:621)
at com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapException(GenericDataStoreHelper.java:680)
at com.ibm.ws.rsadapter.AdapterUtil.mapException(AdapterUtil.java:2267)

Steps to Reproduce

Configure the connection pool in Websphere as described in the documentation for Oracle.

Root Cause

A third-party product issue. The problem should be resolved by specifying the appropriate information in the JDBC data source connection pool properties so that there are no stale connections given to Pega 7 to use.

Resolution

Make the following change to the operating environment:

To correct the configuration, specify the following on the WebSphere Application Server data source properties.

• Validate New Connections
• Validate Existing Pooled connections
• Validation by JDBC driver (Requires JDBC 4 driver)