Interested to Buy Any Domain ? << Click Here >> for more details...
What will happen when ResultSet is not closed?
- 1 Answers
- 7024 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 to use CallableStatement? specially how to use their index given ..
Write an sql to find all records having all upper case alphanumeric characters in a field ?
What is the significance of DataBaseMetaData.tableIndexStatistics? How to obtain and use it?
Is it possible to connect to multiple databases? Using single statement can we update or extract data from two or three or many databases?
How to check jdbc connection in linux?
How do I insert an image file (or other raw data) into a database?
How to retrieve warnings in jdbc?
What does the connection object represents?
What class.forname will do while loading drivers of jdbc?
Hi to all.. well i want to make a standalone application which can use the concept of connection pooling, constraint is that i have not to use any application server like weblogic etc. Please help me out. Thaks in advance.
When do we get java.sql.SQLException: No suitable driver found?
How the JDBC application works?
Core Java 
