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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general