0 Replies Latest reply on Jul 13, 2017 1:42 AM by mdelson

    Unable to get managed connection for java:jboss/MySqlDS


      wildfly-10.1.0.Final with Mysql


      DB connection pool get exhausted and below is seen in the log


      [INFO] [11-Jul-2017-16:04:29] org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception

      java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/MySqlDS


      Update :

      This is in domain mode with 3 instances.


      I have used the below in datasources configuration. But don't see it to be working.




      Further I tried explicitly calling of flush from admin console to flush the dbpool, but I see that "Flush Gracefully", "Flush Idle" and "Flush Invalid" has no effect, It just displays "Success: Flush connections for MySqlDS".


      But "Flush All" free up the dbpool. so I guess "Flush All" is only working but I feel it cleans up the active connection disturbing the transaction.


      Is this a known issue in wildfly-10.1.0.Final?


      Any pointers/workaround would be helpful. Thanks.