5 Replies Latest reply on Mar 26, 2015 11:14 AM by mylos78

    Unable to get managed connection for Datasource

    mylos78

      Hi all!

      We are getting the above exception during heavy use of our application accessing an Oracle Database.

      We have a pool of 500 units on each server. By checking the pool statistics at the end of the test, the following information have been collected:

          "outcome" => "success",
          "result" => {
              "ActiveCount" => "446",
              "AvailableCount" => "209",
              "AverageBlockingTime" => "1",
              "AverageCreationTime" => "19134",
              "AverageGetTime" => "3729",
              "BlockingFailureCount" => "0",
              "CreatedCount" => "446",
              "DestroyedCount" => "0",
              "IdleCount" => "155",
              "InUseCount" => "291",
              "MaxCreationTime" => "53662",
              "MaxGetTime" => "53662",
              "MaxUsedCount" => "444",
              "MaxWaitCount" => "0",
              "MaxWaitTime" => "2",
              "TimedOut" => "0",
              "TotalBlockingTime" => "231",
              "TotalCreationTime" => "8534182",
              "TotalGetTime" => "8536114",
              "WaitCount" => "0"
          }
      

      As you can see, we have not hit the maximum of connections (500). Is there any other scenario when the "Unable to get managed connection" is fired ? Can it be it caused by the large Creation Time of connections ?

      Our application server is WildFly 8.1.

      Thanks!

      Mylos