Re: [ODBC] BIRT report opening multiple connections - Mailing list pgsql-jdbc

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.Bell@hartehanks.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 office
954-281-1464 fax

hartehanks.com / linkedin / twitter / facebook

 

From: davecramer@gmail.com [mailto:davecramer@gmail.com] On Behalf Of Dave Cramer
Sent: Friday, August 15, 2014 8:59 AM

To: Barry Bell
Cc: pgsql-jdbc@postgresql.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.Bell@hartehanks.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 office
954-281-1464 fax

hartehanks.com / linkedin / twitter / facebook

 

From: davecramer@gmail.com [mailto:davecramer@gmail.com] On Behalf Of Dave Cramer
Sent: Friday, August 15, 2014 8:49 AM

To: Barry Bell
Cc: pgsql-jdbc@postgresql.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.Bell@hartehanks.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 office
954-281-1464 fax

hartehanks.com / linkedin / twitter / facebook

 

From: davecramer@gmail.com [mailto:davecramer@gmail.com] On Behalf Of Dave Cramer
Sent: Thursday, August 14, 2014 7:05 PM
To: Barry Bell
Cc: pgsql-jdbc@postgresql.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.Bell@hartehanks.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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc