Re: [ODBC] BIRT report opening multiple connections

On 08/15/2014 07:34 AM, John R Pierce wrote:
>>
>>
>>   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.

Indeed; I struggle to see how it could make new connections with Pg, but
not with MySQL.

Unless perhaps you've configured a pooling DataSource with MySQL, and
you're using the simple DataSource with PostgreSQL?

Please show the full connection configuration, with
usernames/IPs/passwords obscured, for both MySQL and PostgreSQL setups
please.

--
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services