Prepare for your Next Interview

• GeekInterview
• Knowledge base
• Interview Questions
• Tech FAQs

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...

Geeks Talk > Software Development > Java Why we have to close connection, statement, prepared statement

User Name Remember Me? Password

Register

FAQ

Members List

Calendar

Mark Forums Read

Thread Tools

Display Modes

#1 (permalink)   05-05-2007

Geek_Guest Expert Member   Join Date: Feb 2007 Posts: 1,279 Thanks: 0 Thanked 155 Times in 134 Posts

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:

balagece

Sponsored Links

#2 (permalink)   06-15-2007

bharanikumariyer Junior Member   Join Date: Jun 2007 Location: india Posts: 2 Thanks: 0 Thanked 0 Times in 0 Posts

Re: Why we have to close connection, statement, prepared statement then only trafic conjuction will be avoided

#3 (permalink)   06-18-2007

umeshap Junior Member   Join Date: May 2007 Location: Mysore Posts: 16 Thanks: 1 Thanked 0 Times in 0 Posts

Re: Why we have to close connection, statement, prepared statement for security reasons

#4 (permalink)   06-27-2007

satishk Junior Member   Join Date: Jun 2007 Location: pune Posts: 13 Thanks: 5 Thanked 0 Times in 0 Posts

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.

#5 (permalink)   06-30-2007

Sampath_Java Junior Member   Join Date: Jun 2007 Location: Mumbai Posts: 24 Thanks: 9 Thanked 1 Time in 1 Post

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

#6 (permalink)   10-19-2007

rajeshnarkhed Junior Member   Join Date: Jul 2007 Posts: 4 Thanks: 0 Thanked 2 Times in 2 Posts

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)

#7 (permalink)   10-19-2007

debasisdas Moderator   Join Date: Jun 2007 Location: Bangalore,India Posts: 1,330 Thanks: 7 Thanked 120 Times in 108 Posts

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:

sforsree

#8 (permalink)   10-24-2007

prakash_13dec Junior Member   Join Date: Jan 2007 Location: delhi Posts: 22 Thanks: 0 Thanked 1 Time in 1 Post

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?

#9 (permalink)   02-27-2008

rajeevchaturvedi2007 Junior Member   Join Date: Feb 2008 Location: Noida Posts: 1 Thanks: 0 Thanked 0 Times in 0 Posts

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.

Geeks Talk > Software Development > Java

« Constructor and Servlet Config | How Hibernate Works »

Thread Tools

Show Printable Version Email this Page

Display Modes

Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Is this a correct statement	anoop4real	C and C++	13	05-22-2008 06:22 AM
C/C++ Programming : Limitations of switch statement	Lokesh M	C and C++	1	07-17-2007 02:38 AM
How many Case statments can i use in Switch Statement	Geek_Guest	C and C++	9	07-03-2007 04:56 AM
SQL queries inside Callable Statement	Geek_Guest	SQL	1	05-04-2007 08:49 AM
Rules for COPY statement	norman	MainFrame	1	08-14-2006 04:11 AM

All times are GMT -4. The time now is 10:13 AM.