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 restrictions are placed on the values of each case of a switch statement?

710


Name three component subclasses that support painting?

785


What are JTA/JTS and how they used by client?

1904


What are the services in RMI ?

2058


What is an abstract method?

766






What is jboss?

741


Can I map more than one table in a cmp?

768


What is scalable, portability in the view of J2EE?

2133


Name three subclasses of the component class?

799


What is abstract schema?

730


What do you mean by Socket Programming?

727


What if the static modifier is removed from the signature of the main method?

917


How are the elements of a cardlayout organized?

745


How a component can be placed on Windows?

2455


In our urls and in the text of the buttons we have comma. Its causing an error. Is there a way to change the delimiting character for the menu arguments?

805