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

[vivekshrivastava30]

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