0 Replies Latest reply on Jul 13, 2017 1:42 AM by Micheal Delson Nadar

    Unable to get managed connection for java:jboss/MySqlDS

    Micheal Delson Nadar Newbie

      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.

       

      <flush-strategy>AllGracefully</flush-strategy>

       

      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.