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 the difference between the ‘font’ and ‘fontmetrics’ class?

640


What are externizable interface?

583


What are the diff types of exception?

558


A user of a web application sees a jsessionid argument in the URL whenever a resource is accessed. What does this mean? a. The form must have the field jsessionid b. URL rewriting is used as the session method c. Cookies are used for managing sessions

1814


what is handle?

1856






What is prototype?

609


What is RMI and what are the services in RMI?

608


How are the elements of a borderlayout organized?

596


What is scalable, portability in the view of J2EE?

1876


What is TL and its use?

1991


What is message driven beam?

583


AS a developer will u create a data source in connection pool? If so how will u do that, how to access the object from connection pool using IRAD tool?

1635


What is ioc concept & explain it?

622


What restrictions are placed on the location of a package statement within a source code file?

617


Name the eight primitive java types.

595