PostgreSQL, WebObjects and fetchSize - Mailing list pgsql-jdbc

From Jan Willem Luiten
Subject PostgreSQL, WebObjects and fetchSize
Date
Msg-id 1DC92299-A6C8-4C81-A1F2-54FA837FDC39@secondmove.com
Whole thread Raw
Responses Re: PostgreSQL, WebObjects and fetchSize
List pgsql-jdbc
Hello,

I just recently installed PostgreSQL. I'm using this in combination
with WebObjects 5.2. and am fairly impressed with Postgres.
Unfortunately I ran into a problem. I have a table containing a large
number of rows ( > 600.000). When using a displaygroup for batched
access I get an Out of Memory error.

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?

Kind regards,

Jan Willem Luiten

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: Translation update: pt_BR
Next
From: Oliver Jowett
Date:
Subject: Re: PostgreSQL, WebObjects and fetchSize