I have my grails application running on Jboss 6.0. On load we noticed some connections are getting hung and leaving in active session in data base.
Connection management is completely taken care by grails, we are not opening/ closing any connection. To make sure that if any connection is missed to close from code. we added track-statement , <cached-connection-manager debug="true"/> in datasource but we didnot see any problem in log file.
we tried query time out also. It didnot work as DB session is going in active state
So my questions are 1) how to know why it holding? 2)Is there any way to configure connection-time out for connections.