0 Replies Latest reply on Jul 19, 2017 1:56 AM by Vivek Shrivastava

    org.jboss.util.NestedSQLException: No ManagedConnections available within configured blocking

    Vivek Shrivastava Newbie

      Hi

        We are getting No Managed Connection very frequently in our application, which making the entire system down. Please help on this issue. At our end we checked in the code, all the open connection are being closed properly. Still at some  point of time, we are getting No Managed connection problem

      Below is the technical detail of the application that we are using.

       

      Java 1.6

      JBoss 5.0.0

      My SQL 5.x.x

       

      Data source file that we are using to get the connection :
      ================================================

       

       

      <?xml version="1.0" encoding="UTF-8" ?>

       

      <datasources>

        

        <xa-datasource>

      <jndi-name>MASTER</jndi-name>

      <xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class> 

          <xa-datasource-property name="URL">jdbc:mysql://2xx.1xx.1xx.80:3306/MASTER?useUnicode=true&amp;characterEncoding=UTF-8&amp;useFastDateParsing=false</xa-datasource-property> 

          <xa-datasource-property name="User">root</xa-datasource-property> 

          <xa-datasource-property name="Password">xxxxxx</xa-datasource-property> 

      <track-connection-by-tx>true</track-connection-by-tx>

      <no-tx-separate-pools>true</no-tx-separate-pools>

      <min-pool-size>5</min-pool-size> 

      <max-pool-size>50</max-pool-size>

      <idle-timeout-minutes>10</idle-timeout-minutes> <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>

      <metadata>

      <type-mapping>mySQL</type-mapping>

      </metadata>

      </xa-datasource>

       

       

        <xa-datasource>

      <jndi-name>DB2</jndi-name>  

      <xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class> 

          <xa-datasource-property name="URL">jdbc:mysql://2xx.1xx.1xx.80:3306/DB2?useUnicode=true&amp;characterEncoding=UTF-8&amp;useFastDateParsing=false</xa-datasource-property> 

          <xa-datasource-property name="User">root</xa-datasource-property> 

          <xa-datasource-property name="Password">xxxxxx</xa-datasource-property>

      <track-connection-by-tx/>

       

       

      <min-pool-size>5</min-pool-size> 

      <max-pool-size>25</max-pool-size>

      <idle-timeout-minutes>10</idle-timeout-minutes>

        </xa-datasource>

       

        </datasources>

       

       

       

       

       

      ===============================================

       

      Thanks

      Vivek