Skip site navigation (1) Skip section navigation (2)

PostgreSQL, WebObjects and fetchSize

From: Jan Willem Luiten <jwl(at)secondmove(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: PostgreSQL, WebObjects and fetchSize
Date: 2005-05-11 13:47:12
Message-ID: 1DC92299-A6C8-4C81-A1F2-54FA837FDC39@secondmove.com (view raw or flat)
Thread:
Lists: 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

Responses

pgsql-jdbc by date

Next:From: Oliver JowettDate: 2005-05-11 13:59:08
Subject: Re: PostgreSQL, WebObjects and fetchSize
Previous:From: Kris JurkaDate: 2005-05-11 07:42:20
Subject: Re: Translation update: pt_BR

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group