Re: PostgreSQL, WebObjects and fetchSize - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: PostgreSQL, WebObjects and fetchSize
Date
Msg-id 42827DE3.90802@opencloud.com
Whole thread Raw
In response to Re: PostgreSQL, WebObjects and fetchSize  (Jan Willem Luiten <jwl@secondmove.com>)
List 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

pgsql-jdbc by date:

Previous
From: Jesse Eichar
Date:
Subject: bytea encoding
Next
From: Oliver Jowett
Date:
Subject: Re: bytea encoding