This is the preferred way of closing the db resources.
posted 14 years ago
yes i agreee to that i have tried that too, but still no luck. What happens is when i create a new connection the server takes a existing opened connection from the Container connection pool, and the only way to get this resourse back to the container is to close the connection after use which we are doing by using the connection.close() method.
But, i think the connections are not getting replace back to the connection pool, cause the pool size that we have fixed is 30 and it exceeds this 30 connection when we check the connections opened from the database side....
I think we are missing something here, if any body can help me out with this issue that it would be very great!
Don't play dumb with me! But you can try this tiny ad: