Struts 2 - IBatis - MySQL - Jasper report combination

[siva np]

Hi All,

I am using the Struts 2 - IBatis - MySQL - Jasper report 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>
 

It works fine in the ireport3.0.0. ie I am getting the report and sub report.

Because we use the query in the report server

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 
 

But it does not work in the struts 2 file. I am getting the report file. The field are b.id, b.company_id, b.buyer_id values are null. We can get the values of bd.branch_id, bd.buyername, bd.buyer_addr1 and also We did not get the subreport.

Because we have configured the resultMap="BuyerDetailsResult" in the ibatis query.

How do you get the report and subreport ?

Please guide on this issue.

Thanks & regards,

Siva N P