Interested to Buy Any Domain ? << Click Here >> for more details...
whats is mean by connectionpooling
- 2 Answers
- 5246 Views
- SolutionNET, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ramesh s
In software engineering, a connection pool is a cache of
database connections maintained by the database so that the
connections can be reused when the database receives future
requests for data. Connection pools are used to enhance the
performance of executing commands on a database. Opening and
maintaining a database connection for each user, especially
requests made to a dynamic database-driven website
application, is costly and wastes resources. In connection
pooling, after a connection is created, it is placed in the
pool and it is used over again so that a new connection does
not have to be established. If all the connections are being
used, a new connection is made and is added to the pool.
Connection pooling also cuts down on the amount of time a
user must wait to establish a connection to the database.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / b.raja
Connections made via a DataSource object that is
implemented to work with a middle tier connection pool
manager will participate in connection pooling. This can
improve the performance dramatically because creating a new
connection is very expensive.
Connection Pool provides following features:
• Substantial improvement in the performance of DB
application can be accomplished by pre-caching the DB
connection objects
• CPM supplied DB connections are remote enable
• CPM supplied DB connections are cluster aware
• CPM supplied DB connections supports DTM
(distributed TXs)
• CPM supplied DB connections are not actual DB
Connection objects, in turn they are remote object, hence
even though client closes DB connection using con.close()
the actual connection may not be closed instead RMI
connection between client to CPM are closed
• CPM supplied DB connection objects are
serializable, hence client from any where in the network
can access DB connections
The classes and interfaces used for connection pooling are:
1. ConnectionPoolDataSource
2. PooledConnection
3. ConnectionEvent
4. ConnectionEventListener
Connection Pool Manager resided on middle tier
system uses these classes and interfaces behind the scenes.
When the ConnectionPooledDataSource object is called on to
create PooledConnection object, the connection pool manager
will register as a ConnectionEventListener object with the
new PooledConnection object. When the connection is closed
or there is an error, the connection pool manager (being
listener) gets a notification that includes a
ConnectionEvent object.
| Is This Answer Correct ? | 0 Yes | 0 No |
Can I use multiple html form elements with the same name?
What restrictions are placed on the location of a package statement within a source code file?
Which are the different segments of memory?
Difference Between getRequest and PostRequest?
What is clustering? What are the different algorithms used for clustering?
In RMI, inorder to sent the stub reference to the client, is we have to load the server object first into the memory or can we directly sent reference to the client?
what is difference between checked exception & unchecked exception in java?
diff between jsp include directive and jsp action include?
What is the difference between the session.get() method and the session.load() method?
What is ioc concept?
what's the main difference between unix os and linux os?
What is a tasks priority and how is it used in scheduling?
Core Java 
