Re: OutOfMemoryError - bug or human error? - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: OutOfMemoryError - bug or human error?
Date
Msg-id Pine.LNX.4.33.0401260838010.18726-100000@leary.csoft.net
Whole thread Raw
In response to OutOfMemoryError - bug or human error?  (Fischer Krisztián <fischer@borganization.com>)
List pgsql-jdbc

On Mon, 26 Jan 2004, [ISO-8859-2] Fischer Kriszti�n wrote:

> Hi all!
>
> I execute a select on a table which contains large rows. None the less i
> use the setFetchSize() method i get an OutOfMemeoryError.
> In my test I craeted a table with an 'int' and a 'text' column. The text
> column - in each row - is filled with a string constructed of 65536
> characters. The problem is there even if I use a fetch size of 2 rows!

The problem is that the fetch size is ignored when using a ResultSet of
TYPE_SCROLL_INSENSITIVE.  This only works for TYPE_FORWARD_ONLY.

Kris Jurka


pgsql-jdbc by date:

Previous
From: Fischer Krisztián
Date:
Subject: Re: executeUpdate() deadlock
Next
From: Barry Lind
Date:
Subject: Re: Using gettext for JDBC translations