Have you got No ManagedConnections available error message ? well there are 4 possible cause to this problem.......

# 1  Your connection pool is too small

Increase the max number of connections in your Datasource .ds.xml file

<max-pool-size>100</max-pool-size>

# 2  Your threads are being starved by cpu

Incresing the blocking timeout from default 30000 in your Datasource ds.xml

<blocking-timeout-millis>50000</blocking-timeout-millis>

# 3 You are not closing connections properly


Are you closing your connections in the finally method ? (If not your job is really in danger )

finally {
    if (resultSet != null)
      resultSet.close();
    if (statement != null)
      statement.close();

    connection.close();
}

#4 You have hit a bug !

This is the most unlikely......anyway a couple of bugs existed with release 3.2.5 and earlier, so check the bug parade !

Check the following article to learn how to trace your Datasource connections: How to trace JDBC statements with JBoss and WildFly

0
0
0
s2smodern

Related articles available on mastertheboss.com

How to deploy a DataSource in jboss at application level ?

  Do you need to deploy your DataSource along with your Enterpri

JBoss Datasource HA

This tutorial has been updated for the new release of JBoss Appli

How to connect to a DataSource from a remote client?

  If you want to connect to your JBoss Connection Pool from a re

JBoss Datasource configuration

A Datasource is a Java Naming and Directory Interface (JNDI) obje

How do I get the list of Datasources available ?

JBOSS AS 4/5 Users You can use either twiddle: $ twiddle.sh que

How to change JBoss Connection pool size dynamically ?

JBoss recipe of the day