[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/742181#742181

--------------------------------------------------------------
Do you checked the connection pool statistics of your datasource configuration?
If you have reached the 100 connections parallel the next thread/transaction/db-access must wait for a free one.

The possible solutions are:
reduce the duration of transaction where the database is used, that is only a small posibility because you need to read first and commit very late.
So the effort to optimize here is very high and depend to the application maybe not possible.

Other thing is to increase the number of parallel connections to the database, in that case you might reach the limit of one JBoss instance and you have to cluster the application.
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/742181#742181]

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/20120617/8a28793a/attachment-0001.html