Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


What will happen when ResultSet is not closed?



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

Post New Answer

More JDBC Interview Questions

After creating conntinpool in weblogic how to write the code in programe where i can use that pool object in the programe connecting to the database and how to debug programe withou eclipse

2 Answers   Wipro,


How do I check in my code whether a maximum limit of database connections have been reached?

0 Answers  


Explain in detail about JDBC and its general features?

0 Answers  


what is callable statement?

6 Answers   Infogain,


What is jdbc driver in java?

0 Answers  


When you will get error like ?No suitable driver??

2 Answers  


What are the different types of resultset?

0 Answers  


What is db client?

0 Answers  


explain about special characters?

0 Answers  


Can I use JDBC to execute non-standard features that my DBMS provides?

0 Answers  


What are the different types of 2 tier and 3 tier architecture ?

2 Answers   Honeywell,


What is encrypted connection?

0 Answers  


Categories