Thread: Connection Pool

Hi Everyone,

I'm trying to work with connection pools. The example I'm looking at is
lockated here:

http://www.developer.com/img/2009/11/Listing1_ConnectionPoolClass.html

You will notice that the getConnectionFromPool method does not implement
any blocking, and only returns null.

I would like my application to try and get a connection from the pool,
and if there are none free, wait until either one is free or time is up.

What is the best way to do this? Would creating a wrapper method work?
This wrapper method would check for null, and if so, execute a while
loop until a connection is returned. Also, would this wrapper method
need to be synchronised (remembering that multiple threads may be trying
to get a connection)?

Thanks

Jonny

On 11/02/2010 01:42 AM, Jonathan Tripathy wrote:

> I would like my application to try and get a connection from the pool,
> and if there are none free, wait until either one is free or time is up.

Rather than rolling your own connection pool, consider using one of the
well-established existing ones like DBCP. Alternately, you can use the
pooling DataSource offered by the PostgreSQL driver, though it's pretty
minimal as well.

http://commons.apache.org/dbcp/

Alternately you could use server-side pooling with PgPool-II.

--
Craig Ringer