Resultset holdability

Hello,

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?

Thanks for the help,

Geert

--
Geert Bevin                       Uwyn bvba
"Use what you need"               Avenue de Scailmont 34
http://www.uwyn.com               7170 Manage, Belgium
gbevin[remove] at uwyn dot com    Tel +32 64 84 80 03

PGP Fingerprint : 4E21 6399 CD9E A384 6619  719A C8F4 D40D 309F D6A9
Public PGP key  : available at servers pgp.mit.edu, wwwkeys.pgp.net