Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 32250 invoked from network); 9 Sep 2009 14:06:29 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 9 Sep 2009 14:06:29 -0000 Received: (qmail 15074 invoked by uid 500); 9 Sep 2009 14:06:29 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 15041 invoked by uid 500); 9 Sep 2009 14:06:29 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 15033 invoked by uid 99); 9 Sep 2009 14:06:28 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 09 Sep 2009 14:06:28 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of clinton.begin@gmail.com designates 209.85.222.188 as permitted sender) Received: from [209.85.222.188] (HELO mail-pz0-f188.google.com) (209.85.222.188) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 09 Sep 2009 14:06:17 +0000 Received: by pzk26 with SMTP id 26so4230707pzk.0 for ; Wed, 09 Sep 2009 07:05:56 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:content-type; bh=Fmtf/19W83c+EWsbQX5C+HoqlWzUG/0DQIE91gCLlWE=; b=syNe5YywJCGTH2IIPQudyZEDCEviCV5s9RMEFW4NoFyO9oEwvxO0cmqFRmIfdKgTHL pYIWXaZ8nzlmYO7jlrnFc/jj/CCpJ5+y8/jkgN5QTRgB9IiRZYLPFo4QxgQ56xwojBfV pgSeMQ5shLQFd5iATxpXEZU4we2vvUf5WFA+E= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; b=X8pIKXRlHHIm48Y0jNX2IhHg6OR0lq8DKFjUaLs10fYJ04/ArDASSei1ZkoJ9cZpz2 mFA7vdp5yquaICKgmXbsmnjg6ZPrae9Kz0rqTsQfCTNICfOMiuem0TxSJBBBaOXxElQo jY8J9yjSAIIXftDd3iP9QhJGQWFF5KDB4evT8= MIME-Version: 1.0 Received: by 10.140.187.14 with SMTP id k14mr58582rvf.212.1252505155823; Wed, 09 Sep 2009 07:05:55 -0700 (PDT) In-Reply-To: <25363810.post@talk.nabble.com> References: <25341354.post@talk.nabble.com> <25342084.post@talk.nabble.com> <16178eb10909080635u18bcf1b2vf54bd18169c8b35d@mail.gmail.com> <25359001.post@talk.nabble.com> <16178eb10909090509j3da15a5dnb4adf21bb5bd77ad@mail.gmail.com> <25363810.post@talk.nabble.com> Date: Wed, 9 Sep 2009 08:05:55 -0600 Message-ID: <16178eb10909090705n1125f44dnfa61f42c6905e53d@mail.gmail.com> Subject: Re: From Ibatis-2- to Ibtais-3- From: Clinton Begin To: user-java@ibatis.apache.org Content-Type: multipart/alternative; boundary=000e0cd2950ce4e66a047325946c X-Virus-Checked: Checked by ClamAV on apache.org --000e0cd2950ce4e66a047325946c Content-Type: text/plain; charset=ISO-8859-1 My best guess is that you might have duplicate records. iBATIS 3 supports limited object identity, so if you are returning duplicates, it will consume them. If you think it's a bug, then the best thing to do is to write a failing unit test using hsqldb or Derby (Java DB) and attach it to a Jira ticket. Clinton On Wed, Sep 9, 2009 at 6:21 AM, faresz wrote: > > Did you tried before to select 2000 records one shot using ibatis3? > All what i am doing is retrieving 2000 records from an Oracle table using > session.selectList("nameSpace.mappeStatementId") this function is always > returning an ArrayList of 1000 records. > > But If i am using Ibatis 2 > [sqlMap.queryForList("nameSpace.mappeStatementId") ] The size of the > ArrayList returned by this function is 2000 records > > ????????????? > > > > > > Clinton Begin wrote: > > > > I don't know if this is a language barrier issue or what. If so, I'm > > sorry, but we don't understand you. > > > > You keep repeating the same thing over and over. No examples, no > > further description, no error. > > > > We've already told you that ibatis does not intentionally have this > limit. > > > > We cannot help you, unless you find a better way to explain the issue. > > > > Clinton > > > > On 2009-09-08, faresz wrote: > >> > >> I have a table with more than 1000 records, i used the ibatis queryList > >> method the returned collection has always 1000 records only, the old > >> version > >> of ibatis was retrieving all the data from the database. > >> Did i miss something, or this is the case of the new version? > >> > >> > >> > >> > >> Clinton Begin wrote: > >>> > >>> iBATIS 3 doesn't limit you to 1000 records... where is this limitation > >>> coming from? > >>> > >>> Clinton > >>> > >>> On Tue, Sep 8, 2009 at 2:41 AM, faresz > >>> wrote: > >>> > >>>> > >>>> Hello man, > >>>> I was testing the new ibatis version and in some cases in our > >>>> application > >>>> and for some business it recommends to gather all available data that > >>>> it > >>>> could be more than 1000 > >>>> > >>>> > >>>> > >>>> > >>>> Sameeh Harfoush wrote: > >>>> > > >>>> > Fares man, > >>>> > you need to add in your post some server stack trace and error > logs.. > >>>> > why you need to load more than 1000 records ? > >>>> > > >>>> > Sameeh Harfoush > >>>> > > >>>> > On Tue, Sep 8, 2009 at 10:47 AM, faresz > >>>> > wrote: > >>>> > > >>>> >> > >>>> >> We are in the process of testing the new version of Ibatis 3.0 Beta > >>>> and > >>>> >> we > >>>> >> are facing the following problems: > >>>> >> > >>>> >> 1. Mapping Syntax changes like do not exist > >>>> anymore > >>>> in > >>>> >> Ibatis 3 Beta > >>>> >> The migration from version 2 to 3 Beta will affect all our > >>>> >> mapping/query definitions and will cause a big overhead for the > >>>> company. > >>>> >> Is > >>>> >> there any possibility to migrate without doing all the changes > >>>> listed, > >>>> or > >>>> >> is > >>>> >> there any tool that will help us to minimize this overhead? > >>>> >> 2. In the previous version, we used to have the ibatis jar in the > >>>> >> domain > >>>> >> libraries, no need for it to be in the level of the web > application. > >>>> In > >>>> >> the > >>>> >> new version we are obliged to include the ibatis jar in the same > >>>> library > >>>> >> folder of our internal jars. Are we missing anything here? > >>>> >> 3. In the older version, queries could retrieve more than 1,000 > >>>> >> records. > >>>> >> This will cause a problem in case we need to get more records and > >>>> this > >>>> >> case > >>>> >> is very common. Is there any possible fix for this problem? > >>>> >> > >>>> >> We really appreciate your cooperation with us on the points listed > >>>> above > >>>> >> and > >>>> >> are looking forward to use Ibatis 3 in our suite. > >>>> >> -- > >>>> >> View this message in context: > >>>> >> > >>>> > http://www.nabble.com/From-Ibatis-2--to-Ibtais-3--tp25341354p25341354.html > >>>> >> Sent from the iBATIS - User - Java mailing list archive at > >>>> Nabble.com. > >>>> >> > >>>> >> > >>>> >> > >>>> --------------------------------------------------------------------- > >>>> >> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org > >>>> >> For additional commands, e-mail: user-java-help@ibatis.apache.org > >>>> >> > >>>> >> > >>>> > > >>>> > > >>>> > >>>> -- > >>>> View this message in context: > >>>> > http://www.nabble.com/From-Ibatis-2--to-Ibtais-3--tp25341354p25342084.html > >>>> Sent from the iBATIS - User - Java mailing list archive at Nabble.com. > >>>> > >>>> > >>>> --------------------------------------------------------------------- > >>>> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org > >>>> For additional commands, e-mail: user-java-help@ibatis.apache.org > >>>> > >>>> > >>> > >>> > >> > >> -- > >> View this message in context: > >> > http://www.nabble.com/From-Ibatis-2--to-Ibtais-3--tp25341354p25359001.html > >> Sent from the iBATIS - User - Java mailing list archive at Nabble.com. > >> > >> > >> --------------------------------------------------------------------- > >> 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 > > > > > > > > -- > View this message in context: > http://www.nabble.com/From-Ibatis-2--to-Ibtais-3--tp25341354p25363810.html > Sent from the iBATIS - User - Java mailing list archive at Nabble.com. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org > For additional commands, e-mail: user-java-help@ibatis.apache.org > > --000e0cd2950ce4e66a047325946c Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable My best guess is that you might have duplicate records. =A0iBATIS 3 support= s limited object identity, so if you are returning duplicates, it will cons= ume them. =A0

If you think it's a bug, then the best= thing to do is to write a failing unit test using hsqldb or Derby (Java DB= ) and attach it to a Jira ticket.

Clinton

On Wed, Sep 9= , 2009 at 6:21 AM, faresz <fares.zgheib@ibs-softsolutions.com> wrote:

Did you tried before to select 2000 records one shot using ibatis3?
All what i am doing is retrieving 2000 records from an Oracle table using session.selectList("nameSpace.mappeStatementId") =A0this function= is always
returning an ArrayList of 1000 records.

But If i am using Ibatis 2
[sqlMap.queryForList("nameSpace.mappeStatementId") ] =A0The size = of the
ArrayList returned by this function is 2000 records

?????????????





Clinton Begin wrote:
>
> I don't know if this is a language barrier issue or what. =A0If so= , I'm
> sorry, but we don't understand you.
>
> You keep repeating the same thing over and over. =A0No examples, no > further description, no error.
>
> We've already told you that ibatis does not intentionally have thi= s limit.
>
> We cannot help you, unless you find a better way to explain the issue.=
>
> Clinton
>
> On 2009-09-08, faresz <fares.zgheib@ibs-softsolutions.com> wrote:
>>
>> I have a table with more than 1000 records, i used the ibatis quer= yList
>> method the returned collection has always 1000 records only, the o= ld
>> version
>> of ibatis was retrieving all the data from the database.
>> Did i miss something, or this is the case of the new version?
>>
>>
>>
>>
>> Clinton Begin wrote:
>>>
>>> iBATIS 3 doesn't limit you to 1000 records... where is thi= s limitation
>>> coming from?
>>>
>>> Clinton
>>>
>>> On Tue, Sep 8, 2009 at 2:41 AM, faresz
>>> <fare= s.zgheib@ibs-softsolutions.com>wrote:
>>>
>>>>
>>>> Hello man,
>>>> I was testing the new ibatis version and in some cases in = our
>>>> application
>>>> and for some business it recommends to gather all availabl= e data that
>>>> it
>>>> could be more than 1000
>>>>
>>>>
>>>>
>>>>
>>>> Sameeh Harfoush wrote:
>>>> >
>>>> > Fares man,
>>>> > you need to add in your post some server stack trace = and error logs..
>>>> > why you need to load more than 1000 records ?
>>>> >
>>>> > Sameeh Harfoush
>>>> >
>>>> > On Tue, Sep 8, 2009 at 10:47 AM, faresz
>>>> > <fares.zgheib@ibs-softsolutions.com>wrote:
>>>> >
>>>> >>
>>>> >> We are in the process of testing the new version = of Ibatis 3.0 Beta
>>>> and
>>>> >> we
>>>> >> are facing the following problems:
>>>> >>
>>>> >> =A0 1. Mapping Syntax changes like <isNotNull.= ../> do not exist
>>>> anymore
>>>> in
>>>> >> Ibatis 3 Beta
>>>> >> =A0 =A0 =A0The migration from version 2 to 3 Beta= will affect all our
>>>> >> mapping/query definitions and will cause a big ov= erhead for the
>>>> company.
>>>> >> Is
>>>> >> there any possibility to migrate without doing al= l the changes
>>>> listed,
>>>> or
>>>> >> is
>>>> >> there any tool that will help us to minimize this= overhead?
>>>> >> =A0 2. In the previous version, we used to have t= he ibatis jar in the
>>>> >> domain
>>>> >> libraries, no need for it to be in the level of t= he web application.
>>>> In
>>>> >> the
>>>> >> new version we are obliged to include the ibatis = jar in the same
>>>> library
>>>> >> folder of our internal jars. Are we missing anyth= ing here?
>>>> >> =A0 3. In the older version, queries could retrie= ve more than 1,000
>>>> >> records.
>>>> >> This will cause a problem in case we need to get = more records and
>>>> this
>>>> >> case
>>>> >> is very common. Is there any possible fix for thi= s problem?
>>>> >>
>>>> >> We really appreciate your cooperation with us on = the points listed
>>>> above
>>>> >> and
>>>> >> are looking forward to use Ibatis 3 in our suite.=
>>>> >> --
>>>> >> View this message in context:
>>>> >>
>>>> http://www.nabble.com/From-I= batis-2--to-Ibtais-3--tp25341354p25341354.html
>>>> >> Sent from the iBATIS - User - Java mailing list a= rchive at
>>>> Nabble.com.
>>>> >>
>>>> >>
>>>> >>
>>>> ----------------------------------------------------------= -----------
>>>> >> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
>>>> >> For additional commands, e-mail: user-java-help@ibatis.apache.org >>>> >>
>>>> >>
>>>> >
>>>> >
>>>>
>>>> --
>>>> View this message in context:
>>>> http://www.nabble.com/From-I= batis-2--to-Ibtais-3--tp25341354p25342084.html
>>>> Sent from the iBATIS - User - Java mailing list archive at= Nabble.com.
>>>>
>>>>
>>>> ----------------------------------------------------------= -----------
>>>> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
>>>> For additional commands, e-mail: user-java-help@ibatis.apache.org
>>>>
>>>>
>>>
>>>
>>
>> --
>> View this message in context:
>> http://www.nabble.com/From-Ibatis-2-= -to-Ibtais-3--tp25341354p25359001.html
>> Sent from the iBATIS - User - Java mailing list archive at Nabble.= com.
>>
>>
>> ------------------------------------------------------------------= ---
>> 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
>
> ---------------------------------------------------------------------<= br> > To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@ibatis.apache.org
>
>
>

--
View this message in context: htt= p://www.nabble.com/From-Ibatis-2--to-Ibtais-3--tp25341354p25363810.html=
Sent from the iBATIS - User - Java mailin= g list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org


--000e0cd2950ce4e66a047325946c--