jQuery in Action, 3rd edition
The moose likes JDBC and Relational Databases and the fly likes Connection Pooling Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Connection Pooling" Watch "Connection Pooling" New topic

Connection Pooling

Supri dharshni

Joined: Jul 14, 2009
Posts: 25

Instead of creating and opening new connections for each and every request we have the connections in a connection pool.But what happens when the number requests exceeds the pool size limit.Will any exception is thrown? If so then how we have to handle such situation.Please reply.
David O'Meara

Joined: Mar 06, 2001
Posts: 13459

What sort of connections?
The best answer is 'it depends'.

It is acceptable to force a thread to wait if a connection is not available, but a Thread should not be starved and should not be forced to wait forever.
Saifuddin Merchant
Ranch Hand

Joined: Feb 08, 2009
Posts: 607

Most of the times the connection pool object would have this documented. Most of the time I suspect they wait put you in wait with some timeout. All of this is configurable. Most of the times the max required connection can be safely set. If not most connection pool allow you to set maxConnection to no limit.

P.S - When I say connectionPool I mean a DataBase Connection Pool.

Cheers - Sam.
Twisters - The new age Java Quiz || My Blog
Hardik N Shah

Joined: Jul 14, 2010
Posts: 7
Apache Common DBCP manages all this things very well

Hardik Shah
Java/J2ee Expert
I agree. Here's the link: http://aspose.com/file-tools
subject: Connection Pooling
It's not a secret anymore!