Re: setFetchSize - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: setFetchSize
Date
Msg-id CA+0W9LNzqMnOHQsE+09tS14LL+B+Uu6+Ue1Ufvfb8=pgKbM7FA@mail.gmail.com
Whole thread Raw
In response to setFetchSize  (fschmidt <fschmidt@gmail.com>)
Responses Re: setFetchSize
List pgsql-jdbc
On 25 October 2011 19:45, fschmidt <fschmidt@gmail.com> wrote:

> Clearly the ideal is to allow setFetchSize() to work across commits.  I
> don't understand why this is a problem.  Postgres allows one to declare
> cursors WITH HOLD to work across transactions.  Why can't the JDBC driver
> use this?

Because the driver's not using a SQL-level cursor, it is using a
protocol-level portal which can't be declared WITH HOLD.

Oliver

pgsql-jdbc by date:

Previous
From: fschmidt
Date:
Subject: setFetchSize
Next
From: fschmidt
Date:
Subject: Re: setFetchSize