1 Reply Latest reply: Mar 20, 2013 3:47 AM by 994188 RSS

    Connection Pool from Java Cloud Service to Database Cloud Service....

      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

      Best regards