Skip site navigation (1) Skip section navigation (2)

Re: Resultset holdability

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Geert Bevin <gbevin(at)uwyn(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Resultset holdability
Date: 2005-10-21 23:01:24
Message-ID: 43597344.3080005@opencloud.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
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

In response to

Responses

pgsql-jdbc by date

Next:From: Geert BevinDate: 2005-10-21 23:10:35
Subject: Re: Resultset holdability
Previous:From: Geert BevinDate: 2005-10-21 21:57:44
Subject: Re: Resultset holdability

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group