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 09:22:35 GMT

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