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 is connection pooling?

Answer Posted / m.m.reddy

A group of objects is called as a pool of objects. Object
pooling technique is used mainly to deal with the objects
that are expensive to create.An application using object
pooling technique follows the steps given below.
1).An application creates n'number of objects and places
these objects in the pool(assume n=10).
2).If the application has to use an object it picks up the
objects from the pool, uses the objects and returns the
objects to the pool(the objects return to the pool can be
reused)
3).At any point of time, if the number of objects are
available is not enough the application can add few more
objects to the pool.This is called as expanding the pool.
If there are more objects in the pool(100)but most of the
time a maximum upto 15 objects are used than the
application can be removed upto 90 objects from the pool.
This is called as SHRINKING the pool.
DriverManager.getConnection method establishes the
connection with the server and creates a connection object.
This operation is expensive(takes more amount of time).
When the connection is created using
DriverManager.getConnection calling con.close() closes the
connection.
As the creation of connection object is a expensive it is
recommanded to use connection pooling technique.
The J2EE servers like weblogic,JBoss,websphere etc manages
the connection pool as their own.

Is This Answer Correct ?    7 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I connect to jdbc?

950


What is jdbc odbc in java?

1092


Is jpa faster than jdbc?

887


Is it possible to connect to multiple databases simultaneously?

1070


Which constraint cannot be specified as an explicit constraint and should be specified with the column only ?

932


How can we set null value in jdbc preparedstatement?

967


What is a lock in jdbc?

958


How can I instantiate and load a new CachedRowSet object from a non-JDBC source?

990


What are different types of ResultSet?

1066


Give an example for getXXX method?

992


Does sql allow null values ? Can we use it within where clause ?

982


How does jdbc connect to database?

883


Why do I have to reaccess the database for Array, Blob, and Clob data?

1073


Describe odbc?

979


Which jdbc driver type s is are the jdbc odbc bridge?

879