Connection Busy
843854Nov 19 2004 — edited Nov 23 2004I have connection pool in which there are two vectors storing free connections and busy connections. when getConnection is called, a connection is removed from the free con vector into the busy vector;
then releaseConnection() is called, a connection is removed from the busy con vector into the free con vector:
Now the problem is somewhere in our application after calling the getConnection(), we forgot to call releaseConnection(); that cause the busy connection vector grows quickly. Is there any way to check whether a connection is really busy(being used by a SQL Statement) or not so that I can remove the idle "busy" connection from the busy vector back to the free vector?
Any help will be appreciated
Mark