Return-Path: 
 <user-java-return-19048-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 90597 invoked from network); 7 Apr 2010 02:22:44 -0000
Received: from unknown (HELO mail.apache.org) (140.211.11.3)
  by 140.211.11.9 with SMTP; 7 Apr 2010 02:22:44 -0000
Received: (qmail 62981 invoked by uid 500); 7 Apr 2010 02:22:43 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 62962 invoked by uid 500); 7 Apr 2010 02:22:43 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 62955 invoked by uid 99); 7 Apr 2010 02:22:43 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 07 Apr 2010 02:22:43 +0000
X-ASF-Spam-Status: No, hits=2.2 required=10.0
	tests=FREEMAIL_FROM,HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: domain of clinton.begin@gmail.com
 designates 209.85.217.223 as permitted sender)
Received: from [209.85.217.223] (HELO mail-gx0-f223.google.com)
 (209.85.217.223)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 07 Apr 2010 02:22:36 +0000
Received: by gxk23 with SMTP id 23so344448gxk.15
        for <user-java@ibatis.apache.org>;
 Tue, 06 Apr 2010 19:22:15 -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
         :from:date:received:message-id:subject:to:content-type;
        bh=DBbrXrLUN/j9k/VW5E5Ap8d+FR5kH4Yyhnyy5g8pdUI=;
        b=HzIH12R6VsSoxSDwANmED9QJHkvATZeWoLTeCkqSncP4Mu7WKMzaScL8nKQhiVSWP5
         CPTjVbbeFylYpAi1kGl1T4ROY37cokOnnNlbyxvikk2Pp62Uues9JMjxvgRsvkDuI2bV
         p2AFF04McGXgl+Pc4I/ZAtESn9M2qWl3jUow8=
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:from:date:message-id:subject:to
         :content-type;
        b=WDSC7E/BhFKshCowxpmTMozpiDbYp6TRJPrzuy7sGeCpWW0EKR/9uA9DL67aDABRzG
         C4LETHKo9idMO6FuvE3yW1Rox8G0iQ59NjSM3GI1wGvtEX63opW4B3HtIW7IJfRxLJNI
         RCyqjNDNjTOBTH/GcHidacN8D4rdzupM/VG6c=
MIME-Version: 1.0
Received: by 10.231.19.193 with HTTP; Tue, 6 Apr 2010 19:21:55 -0700 (PDT)
In-Reply-To: <82A8ED22-22E3-4FDB-B500-BDD8822E3D00@peoplepowerco.com>
References: <4BBA1202.9070302@bbs.darktech.org>
 <C58926B1-0D43-4AA4-B55F-28E95F164E7B@gmail.com>
	<r2r16178eb11004052034o5661948fx523c31910adbc33e@mail.gmail.com>
	<E6C104EA-B804-4FCF-85D4-1BF6136EF45E@peoplepowerco.com>
 <4BBBC713.3090306@burntmail.com>
	<82A8ED22-22E3-4FDB-B500-BDD8822E3D00@peoplepowerco.com>
From: Clinton Begin <clinton.begin@gmail.com>
Date: Tue, 6 Apr 2010 20:21:55 -0600
Received: by 10.231.162.85 with SMTP id u21mr440477ibx.95.1270606935411; Tue,
	06 Apr 2010 19:22:15 -0700 (PDT)
Message-ID: <t2l16178eb11004061921naf36895anef6f4785e0e3553e@mail.gmail.com>
Subject: Re: [IBatis3-beta10] nested results for collection
To: user-java@ibatis.apache.org
Content-Type: multipart/alternative; boundary=005045013ed808cba304839c3be0
X-Virus-Checked: Checked by ClamAV on apache.org

--005045013ed808cba304839c3be0
Content-Type: text/plain; charset=ISO-8859-1

If iBATIS finds ANY values for the mapped properties, it will create the
object.  Is it possible that the desc column is populated even when the
index is null?

On Tue, Apr 6, 2010 at 7:52 PM, Viv Kapadekar <vivek@peoplepowerco.com>wrote:

> Hi
> I have a Class X containing a List of Class Y
>
> Class X {
> String a
> List<Y> b
> }
>
> Class Y {
> String index
> String desc
> }
>
> The resultMap I have is
>
> <resultMap id="someID" type="X">
>                <id property="a" column="id"/>
>                        <collection property="b" ofType="Y">
>                                      <id property="index" column="index" />
>                                        <result property="desc"
> column="desc"/>  -->
>                        </collection>
> </resultMap>
>
> This is fine, but I don't want the resulting X to have the collection b
> set, if the "index" value is null. If index is null, even the value of b in
> X should be null.  I tried using <discriminator> and also tried creating a
> separate sql, but no luck. Any ideas?
>
> -V
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@ibatis.apache.org
>
>

--005045013ed808cba304839c3be0
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

If iBATIS finds ANY values for the mapped properties, it will create the ob=
ject.=A0 Is it possible that the desc column is populated even when the ind=
ex is null?<br><br><div class=3D"gmail_quote">On Tue, Apr 6, 2010 at 7:52 P=
M, Viv Kapadekar <span dir=3D"ltr">&lt;<a href=3D"mailto:vivek@peoplepowerc=
o.com">vivek@peoplepowerco.com</a>&gt;</span> wrote:<br>

<blockquote class=3D"gmail_quote" style=3D"margin: 0pt 0pt 0pt 0.8ex; borde=
r-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">Hi<br>
I have a Class X containing a List of Class Y<br>
<br>
Class X {<br>
String a<br>
List&lt;Y&gt; b<br>
}<br>
<br>
Class Y {<br>
String index<br>
String desc<br>
}<br>
<br>
The resultMap I have is<br>
<br>
&lt;resultMap id=3D&quot;someID&quot; type=3D&quot;X&quot;&gt;<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0&lt;id property=3D&quot;a&quot; column=3D&q=
uot;id&quot;/&gt;<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0&lt;collection property=3D&=
quot;b&quot; ofType=3D&quot;Y&quot;&gt;<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0&lt;id property=3D&quot;index&quot; column=3D&quot;index&quot; /&gt;<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0&lt;result property=3D&quot;desc&quot; column=3D&quot;desc&quot;/&gt=
; =A0--&gt;<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0&lt;/collection&gt;<br>
&lt;/resultMap&gt;<br>
<br>
This is fine, but I don&#39;t want the resulting X to have the collection b=
 set, if the &quot;index&quot; value is null. If index is null, even the va=
lue of b in X should be null. =A0I tried using &lt;discriminator&gt; and al=
so tried creating a separate sql, but no luck. Any ideas?<br>


<br>
-V<br>
<br>
<br>
<br>
---------------------------------------------------------------------<br>
To unsubscribe, e-mail: <a href=3D"mailto:user-java-unsubscribe@ibatis.apac=
he.org" target=3D"_blank">user-java-unsubscribe@ibatis.apache.org</a><br>
For additional commands, e-mail: <a href=3D"mailto:user-java-help@ibatis.ap=
ache.org" target=3D"_blank">user-java-help@ibatis.apache.org</a><br>
<br>
</blockquote></div><br>

--005045013ed808cba304839c3be0--