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 14:39:58 GMT
Have you read the documentation?

2010/1/17 Tomáš Procházka <t.prochazka@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.begin@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.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
> >>
> >>
> >
> >
>
> ---------------------------------------------------------------------
> 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