Re: [ODBC] BIRT report opening multiple connections

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