Explain Connection Pooling?

Question Posted / guest

3 Answers
9014 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Explain Connection Pooling?..

Answer / ravikiran(aptech mumbai)

connectin pooling is maintaing a pool of connection which
will allow us to resuse the connection without creating a
new one

Is This Answer Correct ?

7 Yes

0 No

Explain Connection Pooling?..

Answer / sudhakartalluri

Connection Pooling it was nothing but a pool of connection
objects to communicate to database.Generally we will create
our own objects for interacting with databases but,in some
times there is a necessary to create more connection objects
even if they not needed that much.So in this times we will
go for connection pooling mechanism.

In this we will create connection pool in application server
and we will store some connection objects to connection pool
When ever the client or user needs to access database then
with help of Intialcontext lookup() method we can reffer to
connection object.

Is This Answer Correct ?

5 Yes

1 No

Explain Connection Pooling?..

Answer / p.nandakishore

the most time consuming process when we work with a
database is to create a connection object. when application
goes out of scope the object becomes a candidate for
grabage collector. every time we create and every it will
be destroyed. this as effect on a distributed application,
where n no clients are waiting for the response. Connection
pooling is a concept of object reusability.This is a
service provided by application servers.

Is This Answer Correct ?

4 Yes

0 No

Post New Answer