views:

1705

answers:

1

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

  1. Pretest existing pooled connection is selected - retry interval is zero seconds
  2. Pretest new connections is selected - # of retries is zero and retry interval is 0
  3. Pretest SQL String is "Select 'Hello' from dual"

What happens if the pretest fails and

  1. There are no connections in the inFreePool or InUse state?
  2. There are connections in the inFreePool state?

I'm referring to the settings in "Data sources > *data_source* > Websphere Application Server data source"

A: 
Mark Glass