what happens if connection is not closed?

Answer Posted / 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 ?    24 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Does jdbc use ssl?

490


Which of the attributes in the monitoring tab for a jdbc connection pool in the administrative console tell us how many clients are currently waiting for a connection?

511


code to insert values/rows into oracle database from a java swing textfield when a button is pressed(using preparedstatements)

3875


What are drivers available?

602


What is jdbc odbc bridge in java?

526






What does jdbc stand for?

496


Explain jdbc savepoint?

556


What do you understand by jdbc statements?

507


What is jdbc odbc connection?

495


Is jdbc faster than hibernate?

561


What is odbc. how is it related to sql cli?

594


What is the fastest type of JDBC driver?

582


What is jdbc connection?

642


What are the advantages of using preparedstatement in java?

539


Name the method, which is used to prepare a callablestatement.

494