Re: not fetching all query results - Mailing list pgsql-jdbc

From Radim Kolar
Subject Re: not fetching all query results
Date
Msg-id 500C1477.8010901@filez.com
Whole thread Raw
In response to Re: not fetching all query results  (Kris Jurka <books@ejurka.com>)
List 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.

pgsql-jdbc by date:

Previous
From: "ml-tb"
Date:
Subject: Re: not fetching all query results
Next
From: BJ Freeman
Date:
Subject: upgrade causes psql to not work