Thread: Why we have to close connection, statement, prepared statement

Why we have to close connection, statement, prepared statement, What will happen if we dont close staement and prepared statement

Question asked by visitor sreedhar

then only trafic conjuction will be avoided

for security reasons

once we aquire the result.we no more need the connection.So inorder to improve safety of u r application and performance u need to close the connection.

Without close connection, it may be affect another object.
so we need close connection/stmt/pmst.

share if another reason

not closing connections to DB server will soon result in no managed connections available exception i.e. other threads/programs needing to use connections will not find any as all connections are already in use (not closed)

For beter managemnet of objects. again it is always recommended to close the connection for security reason.

having connections open is like programmer sitting on beach(doing nothing) now wud that not be a waste of resource?

Hi ,
Holding any ref. un-necessary will impact on system.
When you claose connection etc. , its available for Garbage Collection.

As per my understanding:

while a connection object is created, it locks the database. related to that connection object. when the developer does not close the connection, the lock to the database will not be released. so no other thread can access the database.
when a statement object is created, it locks the table.
same as when resultset object is created, it locks the row.

when these objects are not closed after use, these locks will never ve released. hence reduces the performance.