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 21:54:34 GMT
That's correct.  At this time, you have to call it through sqlSession.

I don't think it would be too hard to add mapper support.  If it's really
important for you, then file a Jira ticket and I'll see what I can do.

Clinton

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

>
> Yes.
>
> And I found ResultHandler only in this method:
>
> void select
> (String statement, Object parameter, RowBounds rowBounds,
> ResultHandler handler)
>
> which is directly in SqlSession. No possibilities to use ResultHandler in
> mapper class.
>
> ______________________________________________________________
> > Od: "Clinton Begin" <clinton.begin@gmail.com>
> > Komu: user-java@ibatis.apache.org
> > Datum: 17.01.2010 15:40
> > Předmět: Re: read large result set in Ibatis3
> >
> >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
> >>
> >>
> >
> >
>
> ---------------------------------------------------------------------
> 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