Re: Bug in setFetchSize - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: Bug in setFetchSize
Date
Msg-id 41B0CF42.3080907@opencloud.com
Whole thread Raw
In response to Re: Bug in setFetchSize  (Dave Smith <dave.smith@candata.com>)
List pgsql-jdbc
Dave Smith wrote:
> Does it matter if the setAutoCommit is true or false .. or is it just an
> explicit commit(); call that would close the portal?

If autocommit is true then the driver shouldn't be using cursors at all
in theory (since they'd become invalid immediately).

Note that setAutoCommit() will do an implicit commit(), so if you're
running with autocommit off, doing some queries, calling setAutoCommit,
then trying to use the resultsets, then you will see similar problems.

Example code showing the problem?

-O

pgsql-jdbc by date:

Previous
From: Antonini Roberto
Date:
Subject: connection timeout?
Next
From: Oliver Jowett
Date:
Subject: Re: connection timeout?