adaiyurnethaji

 Profile Answers by adaiyurnethaji 

• Sep 7th, 2007

 

In Web Application if a connection is not closed,it will keep on adding.
At one point error will be dispalyed that maximum number of connections reached.
Only DBA's can kill the connection at that time.
It is always better to close the connection and make it to null in the finally block.

adaiyurnethaji

 Profile Answers by adaiyurnethaji 

• Dec 3rd, 2008

 

Connection will pile up and one point of time maximum number of connections exceeded error will be thrown.

anand chaubey

• Aug 7th, 2011

 

If you don't close the connection,your application will eat up all your connection and your application will run out of connection and server will give error as no active connection and your application won't work.

madhu

• Sep 5th, 2011

 

Always you should close connection. In some cases exception is thrown. When more processes get active in the same.