File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes what is connection pool Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "what is connection pool" Watch "what is connection pool" New topic

what is connection pool

chennaisen kumar

Joined: Jul 29, 2005
Posts: 2
its a interview question - can anybody help me
Amol Fuke
Ranch Hand

Joined: Apr 08, 2005
Posts: 129
Connection pool is the group of connection objects.You can implment your own connection pool or can use application servers connection pool.At the start up ,server creates connection pool with connection objects.You can specify pool size.
Whenever you make database transaction ,connection object from pool is used.Once your transaction is over object is returned to the pool.

"There are no mistakes, only lessons"
David O'Meara

Joined: Mar 06, 2001
Posts: 13459

You could also see this recent thread.
Annie Smith
Ranch Hand

Joined: Mar 05, 2005
Posts: 172
An article on connection pooling

Cheers!<br /><b>Annie</b>
I agree. Here's the link:
subject: what is connection pool
jQuery in Action, 3rd edition