Answer Posted / ramesh s
In software engineering, a connection pool is a cache of
database connections maintained by the database so that the
connections can be reused when the database receives future
requests for data. Connection pools are used to enhance the
performance of executing commands on a database. Opening and
maintaining a database connection for each user, especially
requests made to a dynamic database-driven website
application, is costly and wastes resources. In connection
pooling, after a connection is created, it is placed in the
pool and it is used over again so that a new connection does
not have to be established. If all the connections are being
used, a new connection is made and is added to the pool.
Connection pooling also cuts down on the amount of time a
user must wait to establish a connection to the database.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Why are some of the class and element names counter-intuitive?
What is the diffrence between a local-tx-datasource and a xa-datasource?
For which statements does it make sense to use a label?
What is difference between object state and behavior?
If I wanted to use a solarisui for just a jtabbedpane, and the metal ui for everything else, how would I do that?
What’s jboss cache in short?
Are enterprise beans allowed to use thread.sleep()?
What is meant by method chaining?
What is the highest-level event class of the event-delegation model?
Is it possible to stop the execution of a method before completion in a sessionbean?
How would you detect a keypress in a jcombobox?
Name three subclasses of the component class?
What are the call back methods in entity bean?
Why doesn’t the focus feature on the tag work in every circumstance?
What is the relationship between an event-listener interface and an event-adapter class?
