Re: [ODBC] BIRT report opening multiple connections

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(at)openscg(dot)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(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 office
>> 954-281-1464 fax
>>
>> [image:
>> 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] *On Behalf Of
>> *Dave Cramer
>> *Sent:* Friday, August 15, 2014 8:59 AM
>>
>> *To:* Barry Bell
>> *Cc:* 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> 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
>>
>> [image:
>> 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] *On Behalf Of
>> *Dave Cramer
>> *Sent:* Friday, August 15, 2014 8:49 AM
>>
>>
>> *To:* Barry Bell
>> *Cc:* 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> 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
>>
>> [image:
>> 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] *On Behalf Of
>> *Dave Cramer
>> *Sent:* Thursday, August 14, 2014 7:05 PM
>> *To:* Barry Bell
>> *Cc:* 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> 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)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-jdbc
>>
>>
>>
>>
>>
>>
>>
>
>