Connection Pool - Mailing list pgsql-general

From Jonathan Tripathy
Subject Connection Pool
Date
Msg-id 4CCEFC04.2090803@abpni.co.uk
Whole thread Raw
Responses Re: Connection Pool  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Carlos Mennens
Date:
Subject: Re: 8.4 Data Not Compatible with 9.0.1 Upgrade?
Next
From: Jonathan Tripathy
Date:
Subject: JDBC Transactions