Interested to Buy Any Domain ? << Click Here >> for more details...
What will happen when ResultSet is not closed?
- 1 Answers
- 6948 Views
- CTS, I also Faced
- E-Mail Answers
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 |
What causes no suitable driver error?
What is the return type of class.forname() method?
DB2 Universal claims to support JDBC 2.0, But I can only get JDBC 1.0 functionality. What can I do?
What are the differences between execute, executequery, and executeupdate?
What is jdbc connection interface?
What are clob and blob data types in jdbc?
How does jdbc driver work?
What is meant by jdbc and odbc?
What type of drivers have you used?
What is metadata in programming?
What is use of connection pooling?
What is CLOB and BLOB datatypes in JDBC?
Core Java 
