Can't you divide your result into pages with smaller number of records ?
queryForList with proper parameters should do that.
----- Original Message -----
From: Rao, Satish
Sent: Friday, July 08, 2005 4:10 PM
Subject: Best mechanism to read large datasets

I have a situation where I might be retrieving thousands of rows from Oracle. I am using a queryForList() and I am assuming it stores the rows in memory. As a result I am quickly running out of memory.

Is there a way for ibatis to read each row from table and discard it as soon as it is processed, so I don't run into out of memory issues?