I have studied the Websphere document "Connection Life Cycle" for Websphere Application Server Express v6.1 and and have searched the web for an answer to the following.
Connection Pool State
- Pretest existing pooled connection is selected - retry interval is zero seconds
- Pretest new connections is selected - # of retries is zero and retry interval is 0
- Pretest SQL String is "Select 'Hello' from dual"
What happens if the pretest fails and
- There are no connections in the inFreePool or InUse state?
- There are connections in the inFreePool state?
I'm referring to the settings in "Data sources > *data_source* > Websphere Application Server data source"