Thread: [ODBC] BIRT report opening multiple connections

[ODBC] BIRT report opening multiple connections

From
Barry Bell
Date:

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


Re: [ODBC] BIRT report opening multiple connections

From
Dave Cramer
Date:
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

Re: [ODBC] BIRT report opening multiple connections

From
John R Pierce
Date:
On 8/14/2014 1:20 PM, Barry Bell 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)

sounds like a broken application to me.   very broken.   the API calls
to JDBC are the same regardless of what database you're connecting to.
I would be talking with the application developers or support crew.



--
john r pierce                                      37N 122W
somewhere on the middle of the left coast



Re: [ODBC] BIRT report opening multiple connections

From
Craig Ringer
Date:
On 08/15/2014 07:34 AM, John R Pierce wrote:
>>
>>
>>   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)
>
> sounds like a broken application to me.   very broken.   the API calls
> to JDBC are the same regardless of what database you're connecting to.
> I would be talking with the application developers or support crew.

Indeed; I struggle to see how it could make new connections with Pg, but
not with MySQL.

Unless perhaps you've configured a pooling DataSource with MySQL, and
you're using the simple DataSource with PostgreSQL?

Please show the full connection configuration, with
usernames/IPs/passwords obscured, for both MySQL and PostgreSQL setups
please.

--
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services


Re: [ODBC] BIRT report opening multiple connections

From
Dave Cramer
Date:
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

https://4b2685446389bc779b46-5f66fbb59518cc4fcae8900db28267f5.ssl.cf2.rackcdn.com/email-sig-hh.png

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

 


Attachment

Re: [ODBC] BIRT report opening multiple connections

From
Dave Cramer
Date:
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

https://4b2685446389bc779b46-5f66fbb59518cc4fcae8900db28267f5.ssl.cf2.rackcdn.com/email-sig-hh.png

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

https://4b2685446389bc779b46-5f66fbb59518cc4fcae8900db28267f5.ssl.cf2.rackcdn.com/email-sig-hh.png

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

 

 


Attachment

Re: [ODBC] BIRT report opening multiple connections

From
Barry Bell
Date:

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

https://4b2685446389bc779b46-5f66fbb59518cc4fcae8900db28267f5.ssl.cf2.rackcdn.com/email-sig-hh.png

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

 

Attachment

Re: [ODBC] BIRT report opening multiple connections

From
Barry Bell
Date:

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

https://4b2685446389bc779b46-5f66fbb59518cc4fcae8900db28267f5.ssl.cf2.rackcdn.com/email-sig-hh.png

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

https://4b2685446389bc779b46-5f66fbb59518cc4fcae8900db28267f5.ssl.cf2.rackcdn.com/email-sig-hh.png

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

 

 

Attachment

Re: [ODBC] BIRT report opening multiple connections

From
Barry Bell
Date:

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

https://4b2685446389bc779b46-5f66fbb59518cc4fcae8900db28267f5.ssl.cf2.rackcdn.com/email-sig-hh.png

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

https://4b2685446389bc779b46-5f66fbb59518cc4fcae8900db28267f5.ssl.cf2.rackcdn.com/email-sig-hh.png

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

https://4b2685446389bc779b46-5f66fbb59518cc4fcae8900db28267f5.ssl.cf2.rackcdn.com/email-sig-hh.png

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

 

 

 

Attachment

Re: [ODBC] BIRT report opening multiple connections

From
"Lussier, Denis"
Date:
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

https://4b2685446389bc779b46-5f66fbb59518cc4fcae8900db28267f5.ssl.cf2.rackcdn.com/email-sig-hh.png

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

https://4b2685446389bc779b46-5f66fbb59518cc4fcae8900db28267f5.ssl.cf2.rackcdn.com/email-sig-hh.png

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

https://4b2685446389bc779b46-5f66fbb59518cc4fcae8900db28267f5.ssl.cf2.rackcdn.com/email-sig-hh.png

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

 

 

 


Attachment

Re: [ODBC] BIRT report opening multiple connections

From
Dave Cramer
Date:
So do MySql and Oracle do something different here ?

Dave Cramer

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


On 15 August 2014 09:49, Lussier, Denis <denisl@openscg.com> 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.

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

https://4b2685446389bc779b46-5f66fbb59518cc4fcae8900db28267f5.ssl.cf2.rackcdn.com/email-sig-hh.png

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

https://4b2685446389bc779b46-5f66fbb59518cc4fcae8900db28267f5.ssl.cf2.rackcdn.com/email-sig-hh.png

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

https://4b2685446389bc779b46-5f66fbb59518cc4fcae8900db28267f5.ssl.cf2.rackcdn.com/email-sig-hh.png

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

 

 

 



Attachment

Re: [ODBC] BIRT report opening multiple connections

From
"Lussier, Denis"
Date:
I'm guessing on the specifics here, but based on what I've seen in other circumstances..  Perhaps the poolers for the other RDBMS's are being more agressive re-using connections.

Re: [ODBC] BIRT report opening multiple connections

From
Barry Bell
Date:

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

 

Barry Bell

 

From: Lussier, Denis [mailto:denisl@openscg.com]
Sent: Friday, August 15, 2014 9:49 AM
To: Barry Bell
Cc: Dave Cramer; pgsql-jdbc@postgresql.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.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

https://4b2685446389bc779b46-5f66fbb59518cc4fcae8900db28267f5.ssl.cf2.rackcdn.com/email-sig-hh.png

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

https://4b2685446389bc779b46-5f66fbb59518cc4fcae8900db28267f5.ssl.cf2.rackcdn.com/email-sig-hh.png

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

https://4b2685446389bc779b46-5f66fbb59518cc4fcae8900db28267f5.ssl.cf2.rackcdn.com/email-sig-hh.png

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

 

 

 

 

Attachment

Re: [ODBC] BIRT report opening multiple connections

From
Craig Ringer
Date:
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


Re: [ODBC] BIRT report opening multiple connections

From
Dave Cramer
Date:
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@2ndquadrant.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