Postgress, report opening multiple connections

From: Barry Bell <Barry(dot)Bell(at)hartehanks(dot)com>
To: "Hiroshi Inoue (inoue(at)tpf(dot)co(dot)jp)" <inoue(at)tpf(dot)co(dot)jp>, "Hiroshi Saito (hiroshi(at)winpg(dot)jp)" <hiroshi(at)winpg(dot)jp>, "'pgsql-odbc(at)postgresql(dot)org'" <pgsql-odbc(at)postgresql(dot)org>
Cc: Pablo Portnoj <Pablo(dot)Portnoj(at)hartehanks(dot)com>
Subject: Postgress, report opening multiple connections
Date: 2014-08-14 16:31:34
Message-ID: 8672d81953e44ba9936ecf5530681871@BY2PR08MB281.namprd08.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

I have a report with a table and child tables. (BIRT)
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)

Is it possible to force the closing of the transaction in the end of dataset execution?
The report crash after a while (too much IDLE transactions)

Any ideas?

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Adrian Klaver 2014-08-14 19:20:48 Re: Postgress, report opening multiple connections
Previous Message Keith Handlon 2014-08-12 19:26:19 09.03.0300 aix build, the archive no longer conatins the shared object