whats is mean by connectionpooling
- 2 Answers
- 4408 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 a static method be overridden
wahts is mean by dynavalidatorform in struts/
what is the diffrence between banking and insurance domain?
What is the relationship between the canvas class and the graphics class?
Connection Pooling with different type of databases?
Where can I ask questions and make suggestions about seam?
What is the purpose of the finally clause of a try-catch-finally statement?
Explain about local interfaces.
How do you set security in applets?
To identify IDL language what mapping mechanism is used?
Explain the advantages and disadvantages of detached objects.
What are different types of layout managers in java.awt package?
Core Java 
