Re: Bug in setFetchSize

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Dave Smith <dave(dot)smith(at)candata(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Bug in setFetchSize
Date: 2004-12-03 20:40:34
Message-ID: 41B0CF42.3080907@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2004-12-03 20:50:56 Re: connection timeout?
Previous Message Antonini Roberto 2004-12-03 16:03:35 connection timeout?