C1000-174: IBM WebSphere Application Server Network Deployment v9.0.5 Administrator

By IBM · Question Mode

QuestionQ33

Monitor and Tune the Environment

An administrator notices that all data-access applications failed to connect to the database and received a StaleConnectionException. After investigating the network and database, the administrator finds that the firewall timed out the JDBC connections, causing the exception. What can the administrator do to prevent StaleConnectionException occurrences?

Explanation

An unused pooled JDBC connection can be closed by a firewall without WebSphere being aware of it; reusing that connection then produces a StaleConnectionException. Setting the connection pool’s Unused timeout to half the firewall timeout lets WebSphere remove idle connections before the firewall times them out.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!