Java Glossary : connection pool

Java definitions: 0-9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

You are here : home : Java Glossary : C words : connection pool.

The term is used in two main contexts:

Sharing connections to an SQL database.
Reusing socket connections in a servlet.

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.

JDBC Pooling

, dbtool.

home	Canadian Mind Products
	mindprod.com IP:[24.87.56.253]
	Your IP:[80.134.30.163]
	You are visitor number 1965.
	Please send errors, omissions and suggestions
	to improve this page to Roedy Green.
	You can get a fresh copy of this page from:	or possibly from your local J: drive mirror:
	http://mindprod.com/jgloss/connectionpool.html	J:\mindprod\jgloss\connectionpool.html