| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Barry Bell <Barry(dot)Bell(at)hartehanks(dot)com>, "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: | Re: Postgress, report opening multiple connections |
| Date: | 2014-08-14 19:20:48 |
| Message-ID: | 53ED0C10.6010106@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
On 08/14/2014 09:31 AM, Barry Bell wrote:
> I have a report with a table and child tables. (BIRT)
I am going to guess that BIRT means:
http://www.eclipse.org/birt/about/
If that is the case, the native method of connection is through JDBC and
to use ODBC you have to use a JDBC --> ODBC connector, correct?
> 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)
Are you using the same method of connection?
In other words are using ODBC or JDBC for the respective connections?
>
>
> Is it possible to force the closing of the transaction in the end of
> dataset execution?
Not sure the psqlodbc would know what the end of the dataset execution
is. This would seem to be something that would need to come from the
framework(BIRT).
> The report crash after a while (too much IDLE transactions)
>
> Any ideas?
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Barry Bell | 2014-08-14 19:44:20 | Re: Postgress, report opening multiple connections |
| Previous Message | Barry Bell | 2014-08-14 16:31:34 | Postgress, report opening multiple connections |