Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

com.ibm.websphere.ce.cm.StaleConnectionException:

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)

Published September 3, 2015 - Updated October 8, 2020

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice