Return-Path: 
 <user-java-return-6159-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 48387 invoked from network); 3 Mar 2006 16:22:08 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 3 Mar 2006 16:22:08 -0000
Received: (qmail 8281 invoked by uid 500); 3 Mar 2006 16:22:53 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 7964 invoked by uid 500); 3 Mar 2006 16:22:51 -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 7951 invoked by uid 99); 3 Mar 2006 16:22:50 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 03 Mar 2006 08:22:50 -0800
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=HTML_MESSAGE,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: domain of graj27@gmail.com designates
 64.233.162.194 as permitted sender)
Received: from [64.233.162.194] (HELO zproxy.gmail.com) (64.233.162.194)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 03 Mar 2006 08:22:50 -0800
Received: by zproxy.gmail.com with SMTP id i1so736390nzh
        for <user-java@ibatis.apache.org>;
 Fri, 03 Mar 2006 08:22:29 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;
        b=TFcfc+IP7+OWpBtCedacfA/OvoI3TQWsRxZpe4YkfA3y4/Ijw7aBqKt3Wxr8QRAeXCFZRB4NEuqh9m4YxT+uYqtJdETinj7bnxla4c8kZzWnT/7bBfROF0uwrvlpCSud0Y48FG81xL11JwTIRw12D3c2NMuMNRf9D14qUE/gO+M=
Received: by 10.35.111.7 with SMTP id o7mr1157850pym;
        Fri, 03 Mar 2006 08:22:28 -0800 (PST)
Received: by 10.35.125.19 with HTTP; Fri, 3 Mar 2006 08:22:28 -0800 (PST)
Message-ID: <53bb0e4a0603030822r18fae455k5a06803d2a219b35@mail.gmail.com>
Date: Fri, 3 Mar 2006 11:22:28 -0500
From: "Rajanikanth Gaddam" <graj27@gmail.com>
To: user-java@ibatis.apache.org
Subject: Re: implementing HashMap of HashMaps in resultMap...
In-Reply-To: <53bb0e4a0603030810h16044adat9f75f6190adb4d13@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_4624_16749793.1141402948362"
References: <53bb0e4a0603030810h16044adat9f75f6190adb4d13@mail.gmail.com>
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

------=_Part_4624_16749793.1141402948362
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

How do I implement map of maps using Ibatis? I have included the sql config
file.
>
> I am expecting a following result:
> HashMap -->    key   --> manager
>                        value --> java.util.Map -->    key     -->
> orderId
>                                                                 value
> -->    List of beans of type test.Trade
>
> I appreciate all the help.
>
> <sqlMap namespace=3D"report">
>  <resultMap id=3D"getDataMap" class=3D"test.ResultHolder" groupBy=3D"mana=
ger">
>   <result property=3D"manager" column=3D"mgr" />
>   <result property=3D"orderIdMap" resultMap=3D"orderIdMap" />
>  </resultMap>
>
>  <resultMap id=3D"orderIdMap" class=3D"java.util.HashMap" groupBy=3D"orde=
rId">
>   <result property=3D"orderId" column=3D"order_id" />
>   <result property=3D"beanList" resultMap=3D"beanList" javaType=3D"
> java.util.ArrayList"/>
>  </resultMap>
>
>  <resultMap id=3D"beanList" class=3D"test.Trade">
>   <result property=3D"txnId" column=3D"txn_id" />
>   <result property=3D"tradeDisplayType" column=3D"trd_display_id" />
>   <result property=3D"tradeType" column=3D"trd_type" />
>   <result property=3D"numberOfShares" column=3D"shr_face" javaType=3D"dou=
ble" />
>   <result property=3D"sharePrice" column=3D"u_price" javaType=3D"double" =
/>
>   <result property=3D"tradeDate" column=3D"txn_date" javaType=3D"java.uti=
l.Date"
> />
>   <result property=3D"settleDate" column=3D"set_date" javaType=3D"java.ut=
il.Date"
> />
>  </resultMap>
>
>  <select id=3D"getData" resultMap=3D"getDataMap">
>  select
>   mgr,
>   order_id,
>   oms_order_id ,
>   gloss_txn_id ,
>   trd_display_id,
>   trd_type,
>   shr_face,
>   u_price,
>   txn_date
>      from
>   Tab_A
>  </select>
> </sqlMap>
>
> Thanks and Regards
> Raj
>

------=_Part_4624_16749793.1141402948362
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

<div><span class=3D"gmail_quote"></span><font face=3D"Arial" size=3D"2"><sp=
an>How do I implement=20
map of maps using Ibatis? I have included the sql config=20
file.</span></font><blockquote class=3D"gmail_quote" style=3D"border-left: =
1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;=
"><div style=3D"direction: ltr;">
<div><font size=3D"-0"><span></span></font><font face=3D"Arial" size=3D"2">=
<span>I am expecting a following=20
result:</span></font></div>
<div><font face=3D"Arial" size=3D"2"><span>HashMap --&gt;&nbsp;&nbsp;&nbsp;=
=20
key&nbsp;&nbsp;&nbsp;--&gt; manager</span></font></div>
<div><font face=3D"Arial" size=3D"2"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;value --&gt; java.util.Map=20
--&gt;&nbsp;&nbsp;&nbsp; key&nbsp;&nbsp;&nbsp;&nbsp; --&gt;&nbsp;&nbsp;&nbs=
p;&nbsp; orderId</span></font></div>
<div><font face=3D"Arial" size=3D"2"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
value&nbsp;&nbsp;&nbsp; --&gt;&nbsp;&nbsp;&nbsp;&nbsp;List of beans of type=
 test.Trade&nbsp;</span></font></div>
<div><font face=3D"Arial" size=3D"2"><span></span></font>&nbsp;</div>
<div><font face=3D"Arial" size=3D"2"><span>I appreciate all the=20
help.</span></font></div>
<div>&nbsp;</div>
<div><font face=3D"Arial" size=3D"2">&lt;sqlMap namespace=3D&quot;report&qu=
ot;&gt;<br>&nbsp;&lt;resultMap=20
id=3D&quot;getDataMap&quot; class=3D&quot;test.ResultHolder&quot; groupBy=
=3D&quot;manager&quot;&gt;<br>&nbsp;&nbsp;&lt;result=20
property=3D&quot;manager&quot; column=3D&quot;mgr&quot; /&gt;<br>&nbsp;&nbs=
p;&lt;result property=3D&quot;orderIdMap&quot;=20
resultMap=3D&quot;orderIdMap&quot; /&gt;<br>&nbsp;&lt;/resultMap&gt;</font>=
</div>
<div>&nbsp;</div>
<div><font face=3D"Arial" size=3D"2">&nbsp;&lt;resultMap id=3D&quot;orderId=
Map&quot;=20
class=3D&quot;java.util.HashMap&quot; groupBy=3D&quot;orderId&quot;&gt;<br>=
&nbsp;&nbsp;&lt;result=20
property=3D&quot;orderId&quot; column=3D&quot;order_id&quot; /&gt;<br>&nbsp=
;&nbsp;&lt;result property=3D&quot;beanList&quot;=20
resultMap=3D&quot;beanList&quot;=20
javaType=3D&quot;java.util.ArrayList&quot;/&gt;<br>&nbsp;&lt;/resultMap&gt;=
</font></div>
<div>&nbsp;</div>
<div><font face=3D"Arial" size=3D"2">&nbsp;&lt;resultMap id=3D&quot;beanLis=
t&quot;=20
class=3D&quot;test.Trade&quot;&gt;<br>&nbsp;&nbsp;&lt;result property=3D&qu=
ot;txnId&quot; column=3D&quot;txn_id&quot;=20
/&gt;<br>&nbsp;&nbsp;&lt;result property=3D&quot;tradeDisplayType&quot; col=
umn=3D&quot;trd_display_id&quot;=20
/&gt;<br>&nbsp;&nbsp;&lt;result property=3D&quot;tradeType&quot; column=3D&=
quot;trd_type&quot;=20
/&gt;<br>&nbsp;&nbsp;&lt;result property=3D&quot;numberOfShares&quot; colum=
n=3D&quot;shr_face&quot;=20
javaType=3D&quot;double&quot; /&gt;<br>&nbsp;&nbsp;&lt;result property=3D&q=
uot;sharePrice&quot; column=3D&quot;u_price&quot;=20
javaType=3D&quot;double&quot; /&gt;<br>&nbsp;&nbsp;&lt;result property=3D&q=
uot;tradeDate&quot; column=3D&quot;txn_date&quot;=20
javaType=3D&quot;java.util.Date&quot; /&gt;<br>&nbsp;&nbsp;&lt;result prope=
rty=3D&quot;settleDate&quot;=20
column=3D&quot;set_date&quot; javaType=3D&quot;java.util.Date&quot;=20
/&gt;<br>&nbsp;&lt;/resultMap&gt;</font></div>
<div>&nbsp;</div>
<div><font face=3D"Arial" size=3D"2">&nbsp;&lt;select id=3D&quot;getData&qu=
ot;=20
resultMap=3D&quot;getDataMap&quot;&gt;<br>&nbsp;select=20
<br>&nbsp;&nbsp;mgr,<br>&nbsp;&nbsp;order_id,<br>&nbsp;&nbsp;oms_order_id ,=
 <br>&nbsp;&nbsp;gloss_txn_id=20
,<br>&nbsp;&nbsp;trd_display_id,<br>&nbsp;&nbsp;trd_type,<br>&nbsp;&nbsp;sh=
r_face,<br>&nbsp;&nbsp;u_price,<br>&nbsp;&nbsp;txn_date<br>&nbsp;&nbsp;&nbs=
p;&nbsp;=20
from <br>&nbsp;&nbsp;Tab_A <br>&nbsp;&lt;/select&gt;<br>&lt;/sqlMap&gt;</fo=
nt></div>
<div>&nbsp;</div>
<div><span><font face=3D"Arial" size=3D"2">Thanks and=20
Regards</font></span></div>
<div><span><font face=3D"Arial" size=3D"2">Raj</font></span></div>

</div></blockquote></div><br>

------=_Part_4624_16749793.1141402948362--