What will happen when ResultSet is not closed?
Answer / sekhar reddy
It also depends on the JDBC driver and it would also not happen if it is a pooled connection. A pooled connection is returned to the pool and would only actually be closed later when its lifetime has expired. In the meanwhile easily more than thousands statements and/or resultsets might have been opened and left unclosed.
However that presumes
- That the driver does do that.
- That the connection close actually cleans the resources.
There was an Oracle driver that did not do the second.
| Is This Answer Correct ? | 0 Yes | 3 No |
After creating conntinpool in weblogic how to write the code in programe where i can use that pool object in the programe connecting to the database and how to debug programe withou eclipse
How do I check in my code whether a maximum limit of database connections have been reached?
Explain in detail about JDBC and its general features?
what is callable statement?
What is jdbc driver in java?
When you will get error like ?No suitable driver??
What are the different types of resultset?
What is db client?
explain about special characters?
Can I use JDBC to execute non-standard features that my DBMS provides?
What are the different types of 2 tier and 3 tier architecture ?
What is encrypted connection?