Have you read the documentation?
2010/1/17 Tomáš Procházka <t.procha...@centrum.cz>
>
> Thanks you for reply.
> I need read data only from one table (queue), so I have no accociation or
> collection mapping.
>
> But what I must do?
>
> Is this sufficient:
>
> @Select({"SELECT * FROM send)
> List<Send> getAllItems();
> ?
>
> Or I must do anything else, like use some special class instead of List?
>
> ______________________________________________________________
> > Od: "Clinton Begin" <clinton.be...@gmail.com>
> > Komu: user-java@ibatis.apache.org
> > Datum: 17.01.2010 01:11
> > Předmět: Re: read large result set in Ibatis3
> >
> >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
> >>
> >>
> >
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org
> For additional commands, e-mail: user-java-h...@ibatis.apache.org
>
>
