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: (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc

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

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-2017 The PostgreSQL Global Development Group