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 Wed, 24 Feb 2010 15:05:15 GMT
Ibatis shouldn't block that way.  Can you confirm that it's not a table lock?

On 2010-02-24, Tomáš Procházka <t.prochazka@centrum.cz> wrote:
>
> I don't need expose JDBC. I only continuously read large table as queue and
> process every item.
>
> I already used ResultHandler and ArrayBlockingQueue in handleResult(). If
> the ArrayBlockingQueue is full reading is stoped until consuper thread
> process all items.
>
> But when ArrayBlockingQueue block reading I can't call another iBatis
> request. Ibatis are blocked during whole query processing with
> ResultHandler? I don't use the same Db.getSession();
>
> ______________________________________________________________
>> Od: "Guy Rouillier" <guyr-ml1@burntmail.com>
>> Komu: user-java@ibatis.apache.org
>> Datum: 18.02.2010 18:45
>> Předmět: Re: read large result set in Ibatis3
>>
>>On 2/18/2010 10:16 AM, Tomáš Procházka wrote:
>>> Ideal will be possibility to add method to mapper will return object
>>> on which I can call something like getNext(), hasNext() and close().
>>> Statement will be open and Ibatis will be read and convert to object
>>> only one Object for every getNext call.
>>
>>That is very JDBC-ish.  From my perspective, iBATIS attempts to hide all
>> that so that the programmer can just deal with lists of objects.
>> ResultHandler lets you change how the list gets built.  What you are
>> asking is for JDBC to be exposed again, something like ResultSetHandler.
>> I guess it would be possible to make that pluggable, but then you are
>> undoing much of the framework.
>>
>>-- Guy Rouillier
>>
>>---------------------------------------------------------------------
>>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
>
>

-- 
Sent from my mobile device

---------------------------------------------------------------------
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