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
How do I check in my code whether a maximum limit of database connections have been reached?
What is the use of setFetchSize() and setMaxRows() methods in Statement?
Which Java and java.sql data types map to my specific database types?
Explain the difference between rowset vs. Resultset in jdbc?
How can I know when I reach the last record in a table, since JDBC doesn't provide an EOF method?
What is metadata in programming?
What is the return type of execute, executequery and executeupdate?
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?
Where is mysql jdbc driver located?
Once I have the Java 2 SDK, Standard Edition, from Sun, what else do I need to connect to a database?
What are common JDBC Exceptions?
What is jdbc and jdbc drivers?
What is encrypted connection?
What is the advantage of namedparameterjdbctemplate?
Explain jdbc savepoint?