On Mon, 26 Jan 2004, [ISO-8859-2] Fischer Krisztin 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