Using queryWithRowhandler() as Michal suggested is the iBATIS solution. That said, I would seriously consider doing the process with a stored procedure if possible. You will get WAY better performance, and reduce network traffic significantly.
Larry On 7/8/05, Rao, Satish <[EMAIL PROTECTED]> wrote: > > > 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? >
