Struts 2 - IBatis - MySQL combination

[siva np]

Hi All,

I am using the Struts 2 - IBatis - MySQL combination.

My Master.xml file will be......

 

<resultMap id="BuyerResult" class="model.Master.BuyerVO">   
        <result property="id" column="id"></result>   
        <result property="buyerId" column="buyer_id"></result>   
        <result property="companyId" column="company_id"></result>   
        <result property="branchId" column="branch_id"></result>   
    </resultMap>   
    <resultMap id="BuyerDetailsResult" class="model.Master.BuyerDetailsVO">           
        <result property="buyerId" column="buyer_id"></result>   
        <result property="buyerName" column="buyer_name"></result>   
        <result property="buyerAddr1" column="buyer_addr1"></result>   
    </resultMap>   
  
<select id="listBuyer" resultMap="BuyerDetailsResult">   
select b.id, b.buyer_id, b.company_id, b.branch_id, bd.buyer_id, bd.buyername, bd.buyer_addr1   
from ccat.buyer b JOIN ccat.buyer_details bd ON   
ccat.buyer.buyer_id=ccat.buyer_details.buyer_id </select>   
   

 

I need all the details from BuyerVO to the BuyerDetailsVO.

It works fine in the query browser. But it does not work in the ibatis file. Because we have configured the resultMap="BuyerDetailsResult".

How do you get the values of "BuyerResult" ?

Please guide on this issue.

Thanks & regards,

Siva N P