When I reach the Maximum Capacity of my Connection Pool, I get an error “Internal error: Cannot obtain XAConnection weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool db1 to allocate to applications, please increase the size of the pool and retry….”
What are the default values in the Connection Pool and is it possible to change any of the values?
Especially the following values are relevant:
1. Maximum Capacity
2. Inactive Connection Timeout
3. Idle Instance Timeout
4. Pool Pooling Interval
5. Maximum Instance Time to Live
Please see Andrejus Baranovskis's Blog for his discussion on this topic: http://andrejusb.blogspot.dk/2010/02/optimizing-oracle-adf-application-pool.html
I have tested my ADF-application on a local invironment and have used some of the settings that Andrejus has mentioned. Thereby clarifiyng option 3-5. But I still need some information of the "Maximum Capacity" (1) and the "Inactive Connection Timeout" (2).