Re: setFetchSize

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: fschmidt <fschmidt(at)gmail(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: setFetchSize
Date: 2011-10-25 07:57:18
Message-ID: CA+0W9LNzqMnOHQsE+09tS14LL+B+Uu6+Ue1Ufvfb8=pgKbM7FA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On 25 October 2011 19:45, fschmidt <fschmidt(at)gmail(dot)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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message fschmidt 2011-10-25 20:07:42 Re: setFetchSize
Previous Message fschmidt 2011-10-25 06:45:23 setFetchSize