Re: Resultset holdability

Oliver Jowett wrote:
> Geert Bevin wrote:
>
>> I have a resultset that has many rows with bytea data.
>>
>> It looks like me that when I iterate through the rows, the previous
>> rows are only garbage collectable when the resultset is closed, even
>> if I setup the statement like this:
>> statement.setFetchDirection(ResultSet.FETCH_FORWARD);
>> statement.setFetchSize(1);
>>
>> Since it's bytea data, this fills up the memory very quickly. Any
>> thoughts on how to reduce this memory overhead and have the resultset
>> discard any previously fetched data?
>
>
> What driver version are you using?
> What server version are you using?
> Have you turned autocommit off?

One more:

Is the statement/resultset TYPE_FORWARD_ONLY?

-O