Re: Use, Set Catalog and JDBC questions

On 02/25/2013 10:59 AM, John R Pierce wrote:
> On 2/25/2013 10:34 AM, Adrian Klaver wrote:
>>
>> Not sure if this will do what want?:
>> http://jdbc.postgresql.org/documentation/91/datasource.html#ds-intro
>
> a connection pool is something completely different. pools are used
> when you have many client threads connecting and disconnecting to the
> same database, you can use a pool to reduce the actual number of
> connections by sharing a pool of ready-made connections.

From here:
http://jdbc.postgresql.org/documentation/91/ds-ds.html

Table 11.2. DataSource Implementations

Pooling Implementation Class
No org.postgresql.ds.PGSimpleDataSource
Yes org.postgresql.ds.PGPoolingDataSource

There seems to a no pooling version that allows you to aggregate
datasources.

>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com