| From: | Craig Ringer <craig(at)2ndquadrant(dot)com> |
|---|---|
| To: | "Lussier, Denis" <denisl(at)openscg(dot)com>, Barry Bell <Barry(dot)Bell(at)hartehanks(dot)com> |
| Cc: | Dave Cramer <pg(at)fastcrypt(dot)com>, "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | Re: [ODBC] BIRT report opening multiple connections |
| Date: | 2014-08-19 01:42:30 |
| Message-ID: | 53F2AB86.7030502@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Cramer | 2014-08-19 01:47:46 | Re: [ODBC] BIRT report opening multiple connections |
| Previous Message | Josh Berkus | 2014-08-18 17:12:49 | Re: [DOCS] JDBC documentation - issue report |