Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


what happens if connection is not closed?

Answers were Sorted based on User's Feedback



what happens if connection is not closed?..

Answer / pooja

if we don't close the connection , it wil lead to
connection memory leakage.unless until application
server/web server is shut down ,connection wil remain
activate even though the user logs out .

Is This Answer Correct ?    65 Yes 2 No

what happens if connection is not closed?..

Answer / srikanth

suppose if there are 10 database connections available with
the database sever and 10 clients request for the connection
if the database sever grants all of them with a connection
and after their usage if they do not close the connections
the database server would not serve for another request for
that reason we need to close the connection and it mandatory
....

Is This Answer Correct ?    23 Yes 8 No

what happens if connection is not closed?..

Answer / siva mukesh

As per my knowledge "We must close the database connection.if not the database will not update even after executing query also.For example our program is to update EMP table from our database.Now check this program without closing the connection and closing the connection."

Is This Answer Correct ?    3 Yes 1 No

what happens if connection is not closed?..

Answer / deepak cheela

For suppose if two database connections are available for
two client requests then database server grants all of them
connection after usage of one client request is over that
client must close the connection becoz server create a
session with clent requests.if so we do without clossing the
connection the DBserver thinks client is still processing
then load wil be on DBserver and performance will decrease.

Is This Answer Correct ?    1 Yes 1 No

what happens if connection is not closed?..

Answer / deepak upadhyay

If we don't close the connection ,we will get memory leakage...and it will open even after log out..and also create distinguish between two user login,it might be interchange...

Is This Answer Correct ?    0 Yes 0 No

what happens if connection is not closed?..

Answer / prathao

nothing wil be happen if the connection wil not closed but
we can close it because it is not mandatory to close the
connection if we can't close connection our application wil
be worked

Is This Answer Correct ?    1 Yes 19 No

what happens if connection is not closed?..

Answer / varma

According to my understanding once we exit java application
then all opened database connections from this application
will be closed automatically

Is This Answer Correct ?    6 Yes 40 No

Post New Answer



More JDBC Interview Questions

Which is best database for java?

0 Answers  


How can I get information about foreign keys used in a table?

0 Answers  


What are JDBC statements?

2 Answers  


How we store procedure in oralce for callable statements in jdbc

0 Answers  


What is database connection pooling? Advantages of using a connection pool?

0 Answers  






How a driver can be loaded?

1 Answers  


What is JDBC Savepoint? How to use it?

0 Answers  


Is it possible to connect to multiple databases simultaneously? Using single statement can one update or extract data from multiple databases?

0 Answers  


Explain in detail about JDBC and its general features?

0 Answers  


Difference between servlet and applet method?

3 Answers  


What is jdbc architecture in java?

0 Answers  


What causes the "No suitable driver" error?

0 Answers  






Categories