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