What data source property can an administrator configure to minimize the chances of encountering StaleConnectionExceptions?
A . Minimum connections = 0
B . Reap Timeout < Unused Timeout
C . Purge Policy = FailingConnectionOnly
D . Unused Timeout > Half firewall timeout
Answer: C
Explanation:
The configuration options below help minimize the chances of encountering StaleConnectionExceptions by helping to ensure that your WebSphere Application Server maintains control of database connections, specifically, the only one closing them, rather than other components in your network:
The datasource MIN connections should be set to 0. By setting a MIN > 0, you are telling the application server that this number of connections will be valid for the life of the application server JVM. Unless you can guarantee the MIN number of connections will never be timed out or dropped, setting a MIN will cause a StaleConnectionException when the connection becomes invalid.
Leave a Reply