What is Connection Pooling?

Answer Posted / suraj kumar

Connection pooling is conceptually similar to any other form
of object pooling. Database connections are often expensive to
create because of the overhead of establishing a network
connection and initializing a database connection session. In
turn, connection session initialization often requires time
consuming processing to perform user authentication, establish
transactional contexts and establish other aspects of the
session that are required for subsequent database usage.
Hence, sharing of connection object helps to both alleviate
connection management overhead and decrease development tasks
for data access. The sharing and storing mechanism of
connection object is known as connection pooling.

Is This Answer Correct ?    16 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is in-memory replication?

560


What is the difference between the ‘font’ and ‘fontmetrics’ class?

645


Why won’t the jvm terminate when I close all the application windows?

756


What is the argument type of a programs main() method?

567


Should synchronization primitives be used on bean methods?

558






Do you think that java should have had pointers?

606


What are the benefits of detached objects?

588


Describe responsibilities of Activator?

1679


what is meant by JRMP?

1811


Why a client should be multithreading? Explain.

598


What is bean? Where can it be used?

584


What are various types of class loaders used by jvm?

501


Difference between DurableSubscription and non- DurableSubscription?

1717


Is there a guarantee of uniqueness for entity beans?

572


How many times may an objects finalize() method be invoked by the garbage collector?

676