ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tomáš Procházka <t.procha...@centrum.cz>
Subject Re: read large result set in Ibatis3
Date Sun, 17 Jan 2010 21:23:56 GMT

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