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
Can we return resultset in java?
What is executeupdate in java?
What are the advantages of using preparedstatement over statement?
Why do you use a data source object for a connection?
What is metadata in jdbc?
What is an escape syntax?
What are the different classes through which JDBC represents statements?
If you are given a choice to implement the code to either insert a record or update if already exist, which approach will you follow ?
What is odbc and jdbc in dbms?
How do I load a database driver with JDBC 4.0 / Java 6?
What is the difference between client and server database cursors?
How do I start debugging problems related to the JDBC API?
List some new features available in jdbc 4.0?
What isolation level is used by the DBMS when inserting, updating and selecting rows from a database?
What does connection pooling mean ?
