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

Are we allowed to change the transaction isolation property in middle of a transaction?

552


How will you pass parameters in RMI? Why do you serialize?

682


What is permgen or permanent generation?

575


What is jboss?

564


What is ripple effect?

627






In inglish: How to convert jar to exe files? Em português: Como converter arquivos .jar para .exe?

2147


Will the general public have access to the infobus apis?

519


what are the advantages of JTA over JTS?

1661


What is the relation between the infobus and rmi?

549


which type of objects reference will be given to client?

2018


Have you used threads in Servelet?

1924


Difference between new operator and class.forname().newinstance()?

589


What are the types of scaling?

543


How are commas used in the intialization and iteration parts of a for statement?

573


What is the difference between static and non-static with examples?

1346