What will happen when ResultSet is not closed?
- 1 Answers
- 6409 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 is the JDBC?
What are restrictions on triggers?
How can we retrieve the file in the oracle database?
Is jdbc an api?
List the advantages of using datasource?
How do I find jdbc version?
What is the difference between Union, Unionall ?
How can we retrieve data from the resultset?
Does JDBC support stored procedures?
what is call level interface?
how do we get the connection from connection pool
How to retrieve warnings in jdbc?
Core Java 
