what happens if connection is not closed?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the steps to connect to a database in java?

482


What is the difference between jdbc and odbc?

528


How do I disallow NULL values in a table?

543


What are the classes and methods used for sending sql statements to database?

542


Describe the steps needed to execute a sql query using jdbc.

549






Which jdbc drivers will run your program?

518


What is jdbc odbc driver?

575


How to connect multiple database in jdbc?

493


What are the benefits of PreparedStatement over Statement?

528


Explain jdbc savepoint?

567


What is the return type of execute, executequery and executeupdate?

655


Explain the difference between inner and outer join ?

514


How many types of jdbc drivers are there?

555


Why is odbc needed?

497


What is DML?

576