ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Clinton Begin <clinton.be...@gmail.com>
Subject Re: read large result set in Ibatis3
Date Sun, 17 Jan 2010 00:10:47 GMT
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
>
>

Mime
View raw message