Postgres Pro
Downloads
Home   >   mailing lists

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

From Barry Bell
Subject [ODBC] BIRT report opening multiple connections
Date
Msg-id 7d652dd9937d4221805e16bc611c1a7e@BY2PR08MB281.namprd08.prod.outlook.com
Whole thread Raw
Responses Re: [ODBC] BIRT report opening multiple connections  (Dave Cramer <pg@fastcrypt.com>)
Re: [ODBC] BIRT report opening multiple connections  (John R Pierce <pierce@hogranch.com>)
List pgsql-jdbc
Tree view 

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

pgsql-jdbc by date:

Previous
From: Craig Ringer
Date:
Subject: Re: PreparedStatement error upon trying to set a '?' after interval keyword
Next
From: Dave Cramer
Date:
Subject: Re: [ODBC] BIRT report opening multiple connections