[ODBC] BIRT report opening multiple connections

From: Barry Bell <Barry(dot)Bell(at)hartehanks(dot)com>
To: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: [ODBC] BIRT report opening multiple connections
Date: 2014-08-14 20:20:08
Message-ID: 7d652dd9937d4221805e16bc611c1a7e@BY2PR08MB281.namprd08.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2014-08-14 23:04:49 Re: [ODBC] BIRT report opening multiple connections
Previous Message Craig Ringer 2014-08-12 13:02:08 Re: PreparedStatement error upon trying to set a '?' after interval keyword