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.procha...@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-unsubscr...@ibatis.apache.org
> For additional commands, e-mail: user-java-h...@ibatis.apache.org
>
>
