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 happens if connection is not closed?

Answer Posted / deepak cheela

For suppose if two database connections are available for
two client requests then database server grants all of them
connection after usage of one client request is over that
client must close the connection becoz server create a
session with clent requests.if so we do without clossing the
connection the DBserver thinks client is still processing
then load wil be on DBserver and performance will decrease.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is type 4 jdbc driver?

849


What are the differences between setmaxrows(int) and setfetchsize(int)?

1065


What is the different between ResultSet and RowSet?

1032


How many jdbc driver types are there?

923


Which interface handles transaction management in jdbc?

1115


What is correlated subquery?

2329


What do you understand by jdbc driver and explain its types?

946


Explain the steps in writing a java program using jdbc?

941


What is two-phase commit in the database?

1052


List the common jdbc exceptions ?

1004


Why do we use jdbc in java?

1055


What is “dirty read” in JDBC? Which isolation level prevents dirty read?

1017


What is the difference between execute, executeQuery, executeUpdate?

1033


What is JDBC Connection isolation levels?

1084


What are the steps required to execute a query in jdbc?

951