ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From George Dawoud <gdaw...@real.com>
Subject Map of Lists
Date Tue, 14 Aug 2007 01:28:49 GMT
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
George		


Mime
View raw message