From: | Geert Bevin <gbevin(at)uwyn(dot)com> |
---|---|
To: | Oliver Jowett <oliver(at)opencloud(dot)com> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Resultset holdability |
Date: | 2005-10-21 23:10:35 |
Message-ID: | 2041867A-0398-48A3-872E-05049E9722F5@uwyn.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Thanks a lot Oliver, turning off autocommit seems to work :-)
On 22-okt-05, at 01:01, Oliver Jowett wrote:
> 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
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
>
--
Geert Bevin Uwyn bvba
"Use what you need" Avenue de Scailmont 34
http://www.uwyn.com 7170 Manage, Belgium
gbevin[remove] at uwyn dot com Tel +32 64 84 80 03
PGP Fingerprint : 4E21 6399 CD9E A384 6619 719A C8F4 D40D 309F D6A9
Public PGP key : available at servers pgp.mit.edu, wwwkeys.pgp.net
From | Date | Subject | |
---|---|---|---|
Next Message | Mike Clements | 2005-10-22 20:57:02 | JDBC keygen select |
Previous Message | Oliver Jowett | 2005-10-21 23:01:24 | Re: Resultset holdability |