Is there some tool to find out the code where the connection is not closed properly? I am getting connection issues and have huge applicaation where I cannot look into each and every program to find whether the connection is closed.any advice will be highly appreciated. thanks
instead of checking the closing of connection,make your that the code which deals with the connection , is kept in try block and in the finally block close the connections,especially check the transction part , whether you have ended the transaction or not.
A have solved this kind of problem with a single class which handles the connection with the database and also closes the connection. This class is tested and I know for sure that the resultset and the needed connection is closed.
If you've a huge application it's important to have a good design in which you have a separation of concern.