| From: | Craig Ringer <craig(at)2ndquadrant(dot)com> |
|---|---|
| To: | John R Pierce <pierce(at)hogranch(dot)com>, pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: [ODBC] BIRT report opening multiple connections |
| Date: | 2014-08-15 09:17:36 |
| Message-ID: | 53EDD030.3010700@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christian Schlichtherle | 2014-08-15 11:43:05 | java.sql.Statement.isClosed() throws an SQLException if the statement is closed |
| Previous Message | John R Pierce | 2014-08-14 23:34:17 | Re: [ODBC] BIRT report opening multiple connections |