Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Why do I get a StaleConnectionException while using WebSphere 4.0 and Toolboxs AS400JDBCConnectionPoolDataSource?

April 26, 2017Toolbox websphere

0

Posted

Why do I get a StaleConnectionException while using WebSphere 4.0 and Toolboxs AS400JDBCConnectionPoolDataSource?

1 Answer

0

Posted

There are several different reasons for this error. First of all, make sure you have v5r1 JACL PTF #SI02886 (SS03 PTF #SI03548) for Toolbox or at least JTOpen version 3.0. This PTF level updates the Toolbox JDBC driver to fully support the JDBC 2.x features used by WAS 4.0. Older versions of Toolbox may cause StaleConnectionExceptions or incorrectly report network errors causing function sequence errors.