Return-Path: 
 <user-java-return-12773-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 60457 invoked from network); 9 Oct 2007 21:31:39 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 9 Oct 2007 21:31:39 -0000
Received: (qmail 49456 invoked by uid 500); 9 Oct 2007 21:31:25 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 49442 invoked by uid 500); 9 Oct 2007 21:31:25 -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 49431 invoked by uid 99); 9 Oct 2007 21:31:25 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 09 Oct 2007 14:31:25 -0700
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_HELO_PASS,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of lists@nabble.com designates
 216.139.236.158 as permitted sender)
Received: from [216.139.236.158] (HELO kuber.nabble.com) (216.139.236.158)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 09 Oct 2007 21:31:28 +0000
Received: from isper.nabble.com ([192.168.236.156])
	by kuber.nabble.com with esmtp (Exim 4.63)
	(envelope-from <lists@nabble.com>)
	id 1IfMfQ-00026L-OH
	for user-java@ibatis.apache.org; Tue, 09 Oct 2007 14:31:04 -0700
Message-ID: <13125201.post@talk.nabble.com>
Date: Tue, 9 Oct 2007 14:31:04 -0700 (PDT)
From: eznibe <enbertran@gmail.com>
To: user-java@ibatis.apache.org
Subject: RE: resultMap HashMap and with a list
In-Reply-To: 
 <F539936522EC6A4B9F4664D92F902E30C27591@TBDCEXCH02.US.Cingular.Net>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Nabble-From: enbertran@gmail.com
References: <13125000.post@talk.nabble.com>
 <F539936522EC6A4B9F4664D92F902E30C27591@TBDCEXCH02.US.Cingular.Net>
X-Virus-Checked: Checked by ClamAV on apache.org


Because i was looking some xml that do it for me easier

Thks



Arora, Parvinder wrote:
> 
> Why can't you fetch them as a simple list and then iterate over the list
> to create a map?
> 
> ~Parvinder
> 
> -----Original Message-----
> From: eznibe [mailto:enbertran@gmail.com] 
> Sent: Tuesday, October 09, 2007 5:19 PM
> To: user-java@ibatis.apache.org
> Subject: resultMap HashMap and with a list
> 
> 
> Hi All,
> 
> can someone tell me if this can be done...
> 
> QRY
> 
> Select type, name 
> from table
> order by type, name
> 
> where the result will be
> 
> TYPE NAME
> type1 aaa
> type1 bbb
> type2 ccc
> type3 axzd
> 
> 
> I want a map with 3 Keys (type1, type2, and type3) and the value of each
> Key
> is the list or Names?
> 
> can this be done... i tried this and no luck
> 
> <resultMap id="get-types" class="java.util.HashMap" groupBy="key">
> <result property="key" column="name" />
> <result property="val" resultMap="get-names"/>
> </resultMap>
> 
> 
> <resultMap id="get-names" class="java.util.ArrayList">
> <result property="name" resultMap="name" />
> </resultMap>
> 
> 
> <select id="retrieveRelatedTo" resultMap="get-cnt-cnt-connections">
> Select type, name 
> from table
> order by type, name
> </select>
> 
> 
> Thanks
> -- 
> View this message in context:
> http://www.nabble.com/resultMap-HashMap-and-with-a-list-tf4596974.html#a
> 13125000
> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
> 
> 
> 

-- 
View this message in context: http://www.nabble.com/resultMap-HashMap-and-with-a-list-tf4596974.html#a13125201
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.