Re: not fetching all query results

From: Radim Kolar <hsn(at)filez(dot)com>
To:
Cc: PostgreSQL JDBC <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: not fetching all query results
Date: 2012-07-22 14:55:51
Message-ID: 500C1477.8010901@filez.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc


> A transaction is required to keep the portal (protocol level cursor)
> open. In autocommit mode, each batch fetched runs in its own
> transaction. So after the first batch is fetched, the autocommit
> transaction ends and the cursor is destroyed. So the next batch fetch
> cannot work.
what about to create transaction for each Statement in autocommit mode.
after calling statement.close() close automatically created transaction.

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message BJ Freeman 2012-07-26 19:40:07 upgrade causes psql to not work
Previous Message ml-tb 2012-07-20 09:26:53 Re: not fetching all query results