PreTest option in DataSource Property in Websphere

[ricky wong]

Dear all,

Have you enabled the PreTest options (Existing / New Connection) in Websphere Application Server DataSource Property before? Is any overhead added to WAS? In case, if the Connection Pool Manager gets a invalid db connection (during PreTest stage), will it retry to get another db connection again and again until it gets a valid db connection? If yes, can we say that this PreTest option can guarantee to get a VALID db connection from Connection Pool? Could you share your experience to me? Thanks in advance.

Best Regards,
Ricky