Re: Resultset holdability

Geert Bevin wrote:

>> Have you turned autocommit off?
>
> No

The driver won't use portal-based resultsets unless you turn off
autocommit. This is because it can't create the equivalent of a WITH
HOLD cursor via protocol-level portals, so any portal created will be
closed at the end of the creating transaction. With autocommit on, the
transaction ends immediately after statement execution, so using a
portal is pointless.

Otherwise it sounds like you meet all the requirements (V3 protocol,
TYPE_FORWARD_ONLY, and fetchsize > 0).

-O