Postgres Pro
Downloads
Home   >   mailing lists

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

From Oliver Jowett
Subject Re: PostgreSQL, WebObjects and fetchSize
Date
Msg-id 42820FAC.8030806@opencloud.com
Whole thread Raw
In response to PostgreSQL, WebObjects and fetchSize  (Jan Willem Luiten <jwl@secondmove.com>)
Responses Re: PostgreSQL, WebObjects and fetchSize
List pgsql-jdbc
Tree view 
Jan Willem Luiten wrote:

> This seems to be caused by the jdbc adaptor reading the complete
> resultset instead of using a scrollable cursor. Is there a way to  solve
> this, eg by setting the fetchsize in some way?

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

-O

pgsql-jdbc by date:

Previous
From: Jan Willem Luiten
Date:
Subject: PostgreSQL, WebObjects and fetchSize
Next
From: Jan Willem Luiten
Date:
Subject: Re: PostgreSQL, WebObjects and fetchSize