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
Difference between DurableSubscription and non- DurableSubscription?
Do I have to use jsps with my application?
Which characters may be used as the second character of an identifier, but not as the first character of an identifier?
What is the difference between system.out ,system.err and system.in?
Difference between hashmap and hashtable?
What are the difference between RMI and CORBA?
What is the form of storage space in java?
Can I import same package/class twice? Will the jvm load the package twice at runtime?
Are we allowed to change the transaction isolation property in middle of a transaction?
Why use a datasource when you can directly specify a connection details? (in a J2EE application)
What is the relationship between local interfaces and container-managed relationships?
What are the call back methods in entity bean?
What is local interface. How values will be passed?
Name three component subclasses that support painting?
Explain about local interfaces.