connection pool : Java Glossary
The term is used in two main contexts:
In a simple system, you create a fresh connection for each transaction. However,
there is a fair overhead for doing that, so instead you can create a set of
connection objects and place them in a pool and recycle them. Having a fintite pool
is also a way of preventing the number of simultaneous threads from growing without
bound. In some databases, you pay extra for the extra connections, so you work to
squeeze everything through one or a small number of connections.
- Sharing connections to an SQL (Standard Query Language)
- Reusing socket connections in a servlet.