C9510-418 · Question #4
What data source property can an administrator configure to minimize the chances of encountering StaleConnectionExceptions?
The correct answer is A. Minimum connections = 0. 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…
Question
What data source property can an administrator configure to minimize the chances of encountering StaleConnectionExceptions?
Options
- AMinimum connections = 0
- BReap Timeout < Unused Timeout
- CPurge Policy = FailingConnectionOnly
- DUnused Timeout > Half firewall timeout
How the community answered
(60 responses)- A80% (48)
- B3% (2)
- C5% (3)
- D12% (7)
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
Topics
Community Discussion
No community discussion yet for this question.