Interested to Buy Any Domain ? << Click Here >> for more details...
What will happen when ResultSet is not closed?
- 1 Answers
- 7022 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Discuss the significances of jdbc.
Write an sql to find all records having all numeric characters in a field ?
Expalin the method of calling a stored procedure from jdbc.
What are collection pools?
What is jdbc class forname?
What is “dirty read” in JDBC? Which isolation level prevents dirty read?
What is the difference between jdbc and jndi?
What are the factors that the jdbc driver performance depends upon?
What is transaction processing in jdbc?
What port does jdbc use?
explain about special characters?
Is it possible to connect to multiple databases simultaneously?
What is an SQL Locator?
Is it possible to connect to multiple databases simultaneously? Using single statement can one update or extract data from multiple databases?
What driver should I use for scalable Oracle JDBC applications?
