What's the difference between Pretest existing pooled connections and prestest new connections in websphere 6.1..and which option is best one?
can we enable both options?
What's the difference between Pretest existing pooled connections and prestest new connections in websphere 6.1..and which option is best one?
can we enable both options?
You may enable both options simultaneously.
Pretesting existing pooled connections is much more useful because it deals with the common issue of stale connections within a pool of already opened connections. If the pretest fails, the connection is discarded and a new connection is established. "Active" connections are not pretested so the performance impact is limited. Otherwise, you would need to handle StaleConnectionExceptions as per:
Pretesting new connections is less useful but you can enable it if you'd like to get an "early warning system."