After certain duration, application is not getting connections from the connection pool configured in Jboss. We are seeing the error “Unable to get managed connection”.
javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/AppDS}: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/AppDS
All the connections are handled through Spring JDBC template. Nowhere explicit call made through JDBC to open or close the connection.
I have enabled the Jboss Spy and verified logs. Even Spring framework sends request to release the connection but the connection is no where released to the pool still it appears as InUse
2013-12-10 10:10:50,023 DEBUG [org.springframework.jdbc.datasource.DataSourceUtils][doReleaseConnection] Returning JDBC Connection to DataSource
Method: returnConnection(12e9257e, false)
Below extra configurations added in standalone.xml to fix the issue,
1. Increased the connection pool upto 75
2. The ccm flag is enabled [use-ccm="true"]
3. Marked debug="true" for cached-connection-factory
In spite of doing all the changes, still the issue appears.
Please share your ideas if you came across this issue.