Connection Pooling with Java....

Remember to close the Statement, PrepareStatement & ResultSet before returning the connection back to the connection pool.

Otherwise, you'll more than likely get "Open cursors exceeded" and that connection will be useless. Even if you return it to the pool, more than likely those will not be closed.