Thread: [ODBC] BIRT report opening multiple connections

[ODBC] BIRT report opening multiple connections

From

Barry Bell

Date:

14 August 2014, 23:54:41


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:

15 August 2014, 02:05:16

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:

15 August 2014, 02:34:36

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:

15 August 2014, 12:17:51

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:

15 August 2014, 15:49:08

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

Attachment

image001.png

Re: [ODBC] BIRT report opening multiple connections

From

Dave Cramer

Date:

15 August 2014, 15:59:07

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

Attachment

Re: [ODBC] BIRT report opening multiple connections

From

Barry Bell

Date:

15 August 2014, 16:19:10

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

Attachment

image001.png

Re: [ODBC] BIRT report opening multiple connections

From

Barry Bell

Date:

15 August 2014, 16:19:47

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

Attachment

Re: [ODBC] BIRT report opening multiple connections

From

Barry Bell

Date:

15 August 2014, 16:20:04

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

Attachment

Re: [ODBC] BIRT report opening multiple connections

From

"Lussier, Denis"

Date:

15 August 2014, 16:50:15

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

Attachment

Re: [ODBC] BIRT report opening multiple connections

From

Dave Cramer

Date:

15 August 2014, 16:53:14

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

Attachment

Re: [ODBC] BIRT report opening multiple connections

From

"Lussier, Denis"

Date:

15 August 2014, 16:57:04

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:

15 August 2014, 19:24:24

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

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

Attachment

image001.png

Re: [ODBC] BIRT report opening multiple connections

From

Craig Ringer

Date:

19 August 2014, 04:42:55

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:

19 August 2014, 04:48:14

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