JBoss Community

Re: Connection pool problem jboss 5.1 + hibernate oracle 11.2.3.0 DB,Hibernate 3.3.2.GA

created by Wolf-Dieter Fink in Performance Tuning - View the full discussion

The reason is logged as the cause:

     No ManagedConnections available within configured blocking timeout ( 50000 [ms] )

 

You have set  a maximum of 100 connections and a blocking timeout of 5000ms.

If you increase the nummer of parallel throughput the getConnection might wait for the next free one.

As the handling is not fair it might happen that one is waiting longer as others and hit the timeout.

Also if your transactions run for longer and block the connections.

 

You might check this in the jmx.console, there are several counters for the connection pool.

 

In fact you have to increase the max-pool-size.

Reply to this message by going to Community

Start a new discussion in Performance Tuning at Community