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

    Unable to get managed connection for Datasource

    Mylos Kathos Master

      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