| From: | Craig Ringer <craig(at)postnewspapers(dot)com(dot)au> |
|---|---|
| To: | Jonathan Tripathy <jonnyt(at)abpni(dot)co(dot)uk>, "List, Postgres" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Connection Pool |
| Date: | 2010-11-02 07:53:09 |
| Message-ID: | 4CCFC365.1080203@postnewspapers.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Radosław Smogura | 2010-11-02 09:09:59 | Re: JDBC Transactions |
| Previous Message | Jonathan Tripathy | 2010-11-02 06:59:27 | Re: Replication |