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

Which Java and java.sql data types map to my specific database types?

542


Why do we use jdbc statements?

511


How many locking systems are there in jdbc?

560


How many types of JDBC Drivers are present and what are they?

510


What is difference between jdbc and odbc?

500






What is jdbc odbc driver?

580


What is db client?

499


What is two-phase commit in the database?

525


What is an odbc driver?

490


Which type of JDBC driver is the fastest one?

576


How do we load the drivers?

554


How data can be inserted into long row column of database?

1710


How does jdbc driver work?

537


What is jdbc in dbms?

503


What are types of jdbc drivers?

530