I absolutly agree,queryWithRowhandler was my first shot, but if
possible, stored procedure is the right solution; hopefully you can
write it in Java ;)
Michal Malecki
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?
