Connection Pool

Поиск
Список
Период
Сортировка
От Jonathan Tripathy
Тема Connection Pool
Дата
Msg-id 4CCEFC04.2090803@abpni.co.uk
обсуждение исходный текст
Ответы Re: Connection Pool  (Craig Ringer <craig@postnewspapers.com.au>)
Список 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 по дате отправления:

Предыдущее
От: Carlos Mennens
Дата:
Сообщение: Re: 8.4 Data Not Compatible with 9.0.1 Upgrade?
Следующее
От: Jonathan Tripathy
Дата:
Сообщение: JDBC Transactions