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

Prabhu Natarajan do-not-reply at jboss.com
Wed Dec 5 04:50:29 EST 2012

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

Start a new discussion in Datasource Configuration at Community

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

More information about the jboss-user mailing list