Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
Why we have to close connection, statement, prepared statement
This is a discussion on Why we have to close connection, statement, prepared statement within the Java forums, part of the Software Development category; 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...
|
|||||||
05-05-2007
|
|||
|
|||
|
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 
|
| The Following User Says Thank You to Geek_Guest For This Useful Post: | ||
| Sponsored Links |
|
06-15-2007
|
|||
|
|||
|
Re: Why we have to close connection, statement, prepared statement
then only trafic conjuction will be avoided
|
|
06-27-2007
|
|||
|
|||
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.
|
|
06-30-2007
|
|||
|
|||
|
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
|
|
10-19-2007
|
|||
|
|||
|
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)
|
|
10-19-2007
|
|||
|
|||
|
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.
|
| The Following User Says Thank You to debasisdas For This Useful Post: | ||
|
10-24-2007
|
|||
|
|||
|
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?
|
|
02-27-2008
|
|||
|
|||
|
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.
|
 |
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Is this a correct statement | anoop4real | C and C++ | 13 | 05-22-2008 07:22 AM |
| C/C++ Programming : Limitations of switch statement | Lokesh M | C and C++ | 1 | 07-17-2007 03:38 AM |
| How many Case statments can i use in Switch Statement | Geek_Guest | C and C++ | 9 | 07-03-2007 05:56 AM |
| SQL queries inside Callable Statement | Geek_Guest | SQL | 1 | 05-04-2007 09:49 AM |
| Rules for COPY statement | norman | MainFrame | 1 | 08-14-2006 05:11 AM |
All times are GMT -4. The time now is 11:11 AM.
