Re: PostgreSQL, WebObjects and fetchSize

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Jan Willem Luiten <jwl(at)secondmove(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: PostgreSQL, WebObjects and fetchSize
Date: 2005-05-11 21:49:23
Message-ID: 42827DE3.90802@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Jan Willem Luiten wrote:

> Besides that, on the TODO list it says under "Performance":
>
> Allow scrollable ResultSets to not fetch all results in one batch.
>
> Could this have to do with the problem I encountered?

Possibly. As I originally said:

> Yes: Statement.setFetchSize(). Currently it only takes effect with
> autocommit off and TYPE_FORWARD_ONLY resultsets.

Perhaps WebObjects is using resultsets of a different type, or has
autocommit on. I couldn't say without seeing the code in question.

-O

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2005-05-11 21:53:00 Re: bytea encoding
Previous Message Jesse Eichar 2005-05-11 20:37:29 bytea encoding