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
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.