[jboss-user] [Performance Tuning] - Re: Connection pool problem jboss 5.1 + hibernate oracle 11.2.3.0 DB, Hibernate 3.3.2.GA

[Wolf-Dieter Fink]

Wolf-Dieter Fink [https://community.jboss.org/people/wdfink] created the discussion

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

To view the discussion, visit: https://community.jboss.org/message/742138#742138

--------------------------------------------------------------
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
[https://community.jboss.org/message/742138#742138]

Start a new discussion in Performance Tuning at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2078]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20120616/c96db3da/attachment.html