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?