Yes, you can use ResultHAndler in iBATIS 3.  The key to know is that the large result set will be fine if the query is as simple as you've presented.  However, if you use associations or collections mappings, then you could run into memory issues.

Cheers,
Clinton

2010/1/16 Tomáš Procházka <t.prochazka@centrum.cz>

Hi.

I need read large result set from DB (like 300 000 rows).

It's possible use this:

@Select({"SELECT * FROM send)
List<Send> getAllItems();

?

but instead of read all rows to List use server cursor and read only items which will be accessed by Iterator.

I found some old article about this problem like:

http://stackoverflow.com/questions/1344362/java-retrieving-large-amounts-of-data-from-a-db-using-ibatis

But I don't know, that this is for iBatis 3.0.

Exist same ResultHandler implementation that can do this?


--
 Tomáš Procházka

---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org