Thanks for the replies.
I checked for unclosed connections. There isn't any, at least from the code.
Where is your close connections code??
I close all in the finally block of the code.
Is there any way I can check for open connections?
Sometimes it can even be a firewall issue. Maybe the firewall settings have changed?
Can you elaborate on this please ?
Also check for the permission on the database if it is allowing multiple connections from your application user.
Where do I check for this?
Thanks