PrepAway - Latest Free Exam Questions & Answers

What data source property can an administrator configur…

What data source property can an administrator configure to minimize the chances of encountering
StaleConnectionExceptions?

PrepAway - Latest Free Exam Questions & Answers

A.
Minimum connections = 0

B.
Reap Timeout < Unused Timeout

C.
Purge Policy = FailingConnectionOnly

D.
Unused Timeout > Half firewall timeout

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.
https://www.ibm.com/developerworks/community/blogs/aimsupport/entry/
websphere_application_server_staleconnectionexceptions?lang=en

One Comment on “What data source property can an administrator configur…


Leave a Reply