Answer Posted / 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 |
Post New Answer View All Answers
What is abstract schema?
How would you reatach detached objects to a session when the same object has already been loaded into the session?
What class is used to create Server side object ?
What happens when a thread cannot acquire a lock on an object?
How messaging services are done, before release of JMS?
Is the infobus client side only?
Describe, in general, how java's garbage collector works?
What is local interface. How values will be passed?
What modifiers may be used with an interface declaration?
What are the different methods of identifying an object?
whats is mean by connectionpooling
What is ioc concept & explain it?
How would you create a button with rounded edges?
What is JTS?
which book is better for jdbc ,servlets and jsp