0 Replies Latest reply on Dec 11, 2013 4:30 AM by dathatreyulu kothapalli

    No managed Connection in Jboss

    dathatreyulu kothapalli Newbie

      Hi

       

      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)

      Available:

      InUse:

        2379bbae (NORMAL)

        12e9257e (NORMAL)

       

      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.

       

      Thanks,

      Shan