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

Compare jdbc and odbc and how is jdbc required in this context.

992


What is the reason why we need a jdbcrowset like the wrapper around resultset?

1026


What are the packages are used in jdbc?

1102


What is a datasource in java?

1012


How can we execute stored procedures?

1075


What are the considerations for deciding on transaction boundaries?

1062


State the three different ways in which you can create a table?

1039


How many jdbc driver types are there?

972


Discuss the procedure of retrieving warnings?

1036


Is it possible to connect to multiple databases simultaneously? Using single statement can one update or extract data from multiple databases?

1063


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

1013


What is the JDBC?

1161


How to connect html page to database using jdbc?

932


What are the components of jdbc?

1040


Why we use while rs next ())?

1015