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

[Wolf-Dieter Fink]

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

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

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

--------------------------------------------------------------
You might have a chance to check it. IF you run in such situation you should stop new clients from accessing and see whether the connections are all back to pool if the requests are finished.
Other option is to monitor the in-use and max-in-use counter, if you see it growing under a similar load during the time you will have a connection leak.

You can also add debug=true or error=true to the cached-connection manager of the JCA subsystem. this will track whether an application does not close the connection at the end.
A Exception or a log statement (error/debug) will show you where the connection is used in your code.
--------------------------------------------------------------

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

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/841c5cf2/attachment.html