Re: implementing HashMap of HashMaps in resultMap...

[Rajanikanth Gaddam]

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="report">
 <resultMap id="getDataMap" class="test.ResultHolder" groupBy="manager">
  <result property="manager" column="mgr" />
  <result property="orderIdMap" resultMap="orderIdMap" />
 </resultMap>

 

 <resultMap id="orderIdMap" class="java.util.HashMap" groupBy="orderId">
  <result property="orderId" column="order_id" />
  <result property="beanList" resultMap="beanList" javaType="java.util.ArrayList"/>
 </resultMap>

 

 <resultMap id="beanList" class="test.Trade">
  <result property="txnId" column="txn_id" />
  <result property="tradeDisplayType" column="trd_display_id" />
  <result property="tradeType" column="trd_type" />
  <result property="numberOfShares" column="shr_face" javaType="double" />
  <result property="sharePrice" column="u_price" javaType="double" />
  <result property="tradeDate" column="txn_date" javaType="java.util.Date" />
  <result property="settleDate" column="set_date" javaType="java.util.Date" />
 </resultMap>

 

 <select id="getData" resultMap="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