-
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
-
Junior Member
Re: Why we have to close connection, statement, prepared statement
then only trafic conjuction will be avoided
-
Junior Member
Re: Why we have to close connection, statement, prepared statement
-
Junior Member
Re: Why we have to close connection, statement, prepared statement
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.
-
Junior Member
Re: Why we have to close connection, statement, prepared statement
Without close connection, it may be affect another object.
so we need close connection/stmt/pmst.
share if another reason
-
Junior Member
Re: Why we have to close connection, statement, prepared statement
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)
-
Re: Why we have to close connection, statement, prepared statement
For beter managemnet of objects. again it is always recommended to close the connection for security reason.
-
Junior Member
Re: Why we have to close connection, statement, prepared statement
having connections open is like programmer sitting on beach(doing nothing) now wud that not be a waste of resource?
-
Junior Member
Re: Why we have to close connection, statement, prepared statement
Hi ,
Holding any ref. un-necessary will impact on system.
When you claose connection etc. , its available for Garbage Collection.
-
Junior Member
Re: Why we have to close connection, statement, prepared statement
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules