Interested to Buy Any Domain ? << Click Here >> for more details...
What will happen when ResultSet is not closed?
- 1 Answers
- 6957 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 |
How can I use the JDBC API to access a desktop database like Microsoft Access over the network?
Explain about Join?
What are the methods which can verify the cursor particular position?
How to execute bulk number of queries at once?
Is jdbc a web technology?
Discuss the significances of jdbc.
Give a way to check that all result sets have bin accessed and update counts are generated by execute method.
How to check jdbc connection in linux?
what is meant by connection pooling?
What is the use of statement in jdbc?
How to insert an image or raw data into database?
preparedstatement p= new preparedstatement is it possible ?
10 Answers Fidelity, IBM, Infrasys,
Core Java 
