[jboss-user] [Datasource Configuration] - Re: JBoss AS 7 connection pooling issues with Mysql

[Prabhu Natarajan]

Prabhu Natarajan [https://community.jboss.org/people/prabhun] created the discussion

"Re: JBoss AS 7 connection pooling issues with Mysql"

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

--------------------------------------------------------------
Hello Marc,

In our case we found that in one place the connection is not closed. Spring DataSourceUtils.getConnection was called and developers missed to close the connection by calling DataSourceUtils.releaseConnection.
We replaced that call with Spring JDBCTemplate which took care of closing the resources.

We then increased the max pool size, as all the connections are busy due to long running transactions and not released immediately. 

In your case whether all connections are taking too much time to get released?
--------------------------------------------------------------

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

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

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