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?

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


Please Help Members By Posting Answers For Below Questions

What does the connection object represents?

1005


What protocol does jdbc use?

921


What is data source in java?

895


How many categories of jdbc drivers are there?

849


How can you make a connection?

929


How does jdbc driver work?

924


Explain jdbc savepoint?

907


Which interface handles transaction management in jdbc?

1049


How to use JDBC API to call Stored Procedures?

975


Why do we need jdbc driver?

832


Is oracle client required for jdbc connection?

915


What is difference between odbc and jdbc?

939


Describe the steps needed to execute a sql query using jdbc.

916


Differentiate between stored procedure and functions?

1002


Is jdbc database independent?

907