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