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