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