Re: [ODBC] BIRT report opening multiple connections

Ya, I had a similar WAG

Dave Cramer

dave.cramer(at)credativ(dot)ca
http://www.credativ.ca

On 18 August 2014 21:42, Craig Ringer <craig(at)2ndquadrant(dot)com> wrote:

> On 08/15/2014 09:49 PM, Lussier, Denis wrote:
> > My suspicion is that Barry is deploying his BIRT reports in a web
> > container that is using connection pooling to the RDBMS. Since the
> > BIRT report doesn't seem to be issuing a a close(), the connection
> > pooler keeps using a new physical connection for each subquery.
>
> My own WAG is that they've configured PgJDBC using org.postgresql.Driver
> or org.postgresql.ds.PGSimpleDataSource but have used DataSource
> implementations with internal pooling on other vendors' drivers.
>
> All we can do is hand-wave, guess, and waste time without at minimum
> seeing:
>
> - The code; and
> - the database connection configuration details
>
> so Barry, please provide those details.
>
> --
> Craig Ringer http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Training & Services
>