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

Is jdbc database independent?

977


What is a merge field?

945


The new features of the JDBC 2.0 API, will be supported for JDBC-ODBC Bridge?

2261


Explain the importance of drivermanager.

1195


any one can explain about policy file rule? when i connect database with applet then ther is no compile time error but the run time error is occureed.i.e access is denied.policy file rule is related to this problem.

2312


Jdbc-odbc bridge is multi-threaded or not?

971


Why is jdbc needed?

921


What is jdbc in java?

940


Give an example for getXXX method?

996


How do I stop nullpointerexception?

985


What is the benefit of having jdbcrowset implementation?

936


Expalin the method of calling a stored procedure from jdbc.

977


How to set NULL values in JDBC PreparedStatement?

984


Explain how to make updates to the updatable resultsets.

927


What is resultsetmetadata?

916