Two Laptop Bag
The moose likes JDBC and the fly likes Connection Pooling Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "Connection Pooling" Watch "Connection Pooling" New topic
Author

Connection Pooling

Supri dharshni
Greenhorn

Joined: Jul 14, 2009
Posts: 25
Hi,

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
Rancher

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: 576

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
Greenhorn

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://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: Connection Pooling
 
Similar Threads
Closing of connection object in Stateless Session Beans
Java Database connection
Doubt in Connection Pooling
How do the connections get closed in Connection Pool
Connection Pooling