Re: Resultset holdability

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?

-O