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 |
How to set NULL values in JDBC PreparedStatement?
What is jdbc architecture in java?
What is statement and resultset in jdbc?
write down exceptions those appear in java programs when u write JDBC Programs?
What is the advantage of namedparameterjdbctemplate?
What are the differences between setmaxrows(int) and setfetchsize(int)?
What is jdbc odbc bridge?
What is jndi lookup?
How warnings are retrieved in JDBC?
What are the Isolation level in JDBC transaction?
What is odbc and jdbc?
Difference between JDBC and Hibernate? Give one sample based on the variance?