| From: | Jonathan Tripathy <jonnyt(at)abpni(dot)co(dot)uk> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Connection Pool |
| Date: | 2010-11-01 17:42:28 |
| Message-ID: | 4CCEFC04.2090803@abpni.co.uk |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Carlos Mennens | 2010-11-01 17:49:08 | Re: 8.4 Data Not Compatible with 9.0.1 Upgrade? |
| Previous Message | Jonathan Tripathy | 2010-11-01 17:37:54 | JDBC Transactions |