Re: [ODBC] BIRT report opening multiple connections

We are NOT using the connection pooling for the BIRT reports.

Barry Bell

From: Lussier, Denis [mailto:denisl(at)openscg(dot)com]
Sent: Friday, August 15, 2014 9:49 AM
To: Barry Bell
Cc: Dave Cramer; pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [JDBC] [ODBC] BIRT report opening multiple connections

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.
--Luss

On Fri, Aug 15, 2014 at 9:01 AM, Barry Bell <Barry(dot)Bell(at)hartehanks(dot)com<mailto:Barry(dot)Bell(at)hartehanks(dot)com>> wrote:
Since everything is the same besides the DB connection,
Then it must be the how BIRT is using the JDBC driver?

Barry Bell
Senior Developer/Analyst
Logistics
Harte Hanks
1525 NW 3rd ST
Deerfield Beach FL, 33442
954-429-3771 Ext 267<tel:954-429-3771%20Ext%20267> office
954-281-1464<tel:954-281-1464> fax
[https://4b2685446389bc779b46-5f66fbb59518cc4fcae8900db28267f5.ssl.cf2.rackcdn.com/email-sig-hh.png]<http://www.hartehanks.com/>
hartehanks.com<http://www.hartehanks.com> / linkedin<http://www.linkedin.com/company/hartehanks> / twitter<http://www.twitter.com/HarteHanks> / facebook<http://www.facebook.com/HarteHanks>

From: davecramer(at)gmail(dot)com<mailto:davecramer(at)gmail(dot)com> [mailto:davecramer(at)gmail(dot)com<mailto:davecramer(at)gmail(dot)com>] On Behalf Of Dave Cramer
Sent: Friday, August 15, 2014 8:59 AM

To: Barry Bell
Cc: pgsql-jdbc(at)postgresql(dot)org<mailto:pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: [JDBC] [ODBC] BIRT report opening multiple connections

Barry,

I think we are all at a loss as to how it could behave differently for postgres since this is just JDBC.

The driver doesn't "control" how people connect to it.

Dave Cramer

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

On 15 August 2014 08:56, Barry Bell <Barry(dot)Bell(at)hartehanks(dot)com<mailto:Barry(dot)Bell(at)hartehanks(dot)com>> wrote:
It creates only 1 connection in ORacle and Mysql.

Under postgees, it creates a connection for each query in the report.
(report may have 50 queries).

Barry Bell
Senior Developer/Analyst
Logistics
Harte Hanks
1525 NW 3rd ST
Deerfield Beach FL, 33442
954-429-3771 Ext 267<tel:954-429-3771%20Ext%20267> office
954-281-1464<tel:954-281-1464> fax
[https://4b2685446389bc779b46-5f66fbb59518cc4fcae8900db28267f5.ssl.cf2.rackcdn.com/email-sig-hh.png]<http://www.hartehanks.com/>
hartehanks.com<http://www.hartehanks.com> / linkedin<http://www.linkedin.com/company/hartehanks> / twitter<http://www.twitter.com/HarteHanks> / facebook<http://www.facebook.com/HarteHanks>

From: davecramer(at)gmail(dot)com<mailto:davecramer(at)gmail(dot)com> [mailto:davecramer(at)gmail(dot)com<mailto:davecramer(at)gmail(dot)com>] On Behalf Of Dave Cramer
Sent: Friday, August 15, 2014 8:49 AM

To: Barry Bell
Cc: pgsql-jdbc(at)postgresql(dot)org<mailto:pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: [JDBC] [ODBC] BIRT report opening multiple connections

Barry,

How can it not create a connection in Oracle or MySql ?

Dave Cramer

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

On 15 August 2014 08:45, Barry Bell <Barry(dot)Bell(at)hartehanks(dot)com<mailto:Barry(dot)Bell(at)hartehanks(dot)com>> wrote:
BIRT is opening the connections in Postgres,
It does not do this in Oracle or MySQL.

Any Ideas how get it to creating a new connection for each query in the BIRT report?

Barry Bell
Senior Developer/Analyst
Logistics
Harte Hanks
1525 NW 3rd ST
Deerfield Beach FL, 33442
954-429-3771 Ext 267<tel:954-429-3771%20Ext%20267> office
954-281-1464<tel:954-281-1464> fax
[https://4b2685446389bc779b46-5f66fbb59518cc4fcae8900db28267f5.ssl.cf2.rackcdn.com/email-sig-hh.png]<http://www.hartehanks.com/>
hartehanks.com<http://www.hartehanks.com> / linkedin<http://www.linkedin.com/company/hartehanks> / twitter<http://www.twitter.com/HarteHanks> / facebook<http://www.facebook.com/HarteHanks>

From: davecramer(at)gmail(dot)com<mailto:davecramer(at)gmail(dot)com> [mailto:davecramer(at)gmail(dot)com<mailto:davecramer(at)gmail(dot)com>] On Behalf Of Dave Cramer
Sent: Thursday, August 14, 2014 7:05 PM
To: Barry Bell
Cc: pgsql-jdbc(at)postgresql(dot)org<mailto:pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: [JDBC] [ODBC] BIRT report opening multiple connections

How would that be possible ? JDBC doesn't open the connections ?

Dave Cramer

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

On 14 August 2014 16:20, Barry Bell <Barry(dot)Bell(at)hartehanks(dot)com<mailto:Barry(dot)Bell(at)hartehanks(dot)com>> wrote:

We have BIRT report with multiple Queries inside the report.
Each Qurery inside the BIRT report is creating a different connection.
Any Ideas how to fix this? (Report may have upto 100 queries)

The problem: Each call of dataset open a connection to the source but
does not close it after dataset execution.
(This does not happen under a different DB like Oracle or Mysql)

Barry Bell

--
Sent via pgsql-jdbc mailing list (pgsql-jdbc(at)postgresql(dot)org<mailto:pgsql-jdbc(at)postgresql(dot)org>)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc