Hi jhking,
Im sorry to say that "rule_desc" is not a property of
ResponseFilesDataPOJO.it is a property of some other class,please dont get
confused...
1> bstatic.rule_desc is coming from another table "BusinessRule_StaticData
bstatic"
2> bres.rule_id,bres.remarks,bres.response is coming from another table "
BusinessRule_ResFiles_Data bres"
Then i perform a join as shown below.
select bres.rule_id,
bstatic.rule_desc,bres.remarks,bres.response
from BusinessRule_ResFiles_Data bres, BusinessRule_StaticData
bstatic
where project_Code = ? and files_id = ?
and bres.rule_id = bstatic.rule_id and bres.rule_id not like
('%CD%')
public class StaticDataPOJO {
private String rule_Desc;
//getters and setters
}
class ResponseFilesDataPOJO{
private String rule_id;
private String response;
private String remarks;
// constructor , getters , setters
}
please help me now.....
how should i change my query.xml file to get the correct fetch.....could you
please modify my code below and let me know how to proceed
-------------------------------------------------------
query.xml
<parameterMap id="FileDetails" class="java.util.Map" >
<parameter property="Project_Code" jdbcType="VARCHAR" />
<parameter property="Files_ID" jdbcType="INT" />
</parameterMap>
<resultMap id="get_list" class="com.hcl.fpTool.pojo.ResponseFilesDataPOJO">
<result property="rule_Id" column="Rule_Id"/>
<result property="response" column="Response"/>
<result property="remarks" column="Remarks"/>
/resultMap>
<select id="getFileResponses"
resultClass="com.hcl.fpTool.pojo.ResponseFilesDataPOJO"
parameterMap="FileDetails" resultMap="get_list">
select bres.rule_id, bstatic.rule_desc,bres.remarks,
bres.response
from BusinessRule_ResFiles_Data bres, BusinessRule_StaticData
bstatic
where project_Code = ? and files_id = ?
and bres.rule_id = bstatic.rule_id and bres.rule_id not like
('%CD%')
</select>
Please need help forum people..im stuck with this for quite a while some
time....
i will be highly thankful to you guys if could help me with this.....
Thanks in advance for your quick replies...
:confused:
jhking wrote:
>
> Your query gets the 4 columns you need from the appropriate tables.
> You just need to change your resultmap and ResponseFilesDataPOJO to have
> all 4 values.
>
> class ResponseFilesDataPOJO{
> private String rule_id;
> private String response;
> private String remarks;
> private String rule_desc;
> // constructor , getters , setters
> }
> <resultMap id="get_list"
> class="com.hcl.fpTool.pojo.ResponseFilesDataPOJO">
> <result property="rule_Id" column="Rule_Id"/>
> <result property="response" column="Response"/>
>
> <result property="remarks" column="Remarks"/>
>
> <result property="rule_desc" column="Rule_desc"/>
> /resultMap>
>
>
> --- deepakl_2...@yahoo.com wrote:
>
> From: deepakl_2000 <deepakl_2...@yahoo.com>
> To: dev@ibatis.apache.org
> Subject: Issue with join of 2 tables in Ibatis
> Date: Wed, 2 Dec 2009 09:30:06 -0800 (PST)
>
>
> Hi,
>
> I have to fetch a list from 2 tables based on below condition.
>
>
>
> [code]
>
> -------------------
>
> Service class
>
> -------------------
>
> fileParameters.put("Project_Code",projectCode);
>
> fileParameters.put("Files_ID",filePk);
>
> responseFileData =
> (List)sqlMap.queryForList("getFileResponses",fileParameters);
>
>
>
> -------------------------------------------------------
> query.xml
>
> <parameterMap id="FileDetails" class="java.util.Map" >
>
> <parameter property="Project_Code" jdbcType="VARCHAR" />
> <parameter property="Files_ID" jdbcType="INT" />
> </parameterMap>
>
>
>
> <resultMap id="get_list"
> class="com.hcl.fpTool.pojo.ResponseFilesDataPOJO">
> <result property="rule_Id" column="Rule_Id"/>
> <result property="response" column="Response"/>
>
> <result property="remarks" column="Remarks"/>
>
> /resultMap>
>
> <select id="getFileResponses"
> resultClass="com.hcl.fpTool.pojo.ResponseFilesDataPOJO"
> parameterMap="FileDetails" resultMap="get_list">
>
> select bres.rule_id, bstatic.rule_desc,bres.remarks,
> bres.response
> from BusinessRule_ResFiles_Data bres, BusinessRule_StaticData
> bstatic
> where project_Code = ? and files_id = ?
> and bres.rule_id = bstatic.rule_id and bres.rule_id not like
> ('%CD%')
> </select>
>
>
>
> The problem lies here is
> 1> i need to select "bstatic.rule_desc" from my another table
> "BusinessRule_StaticData"
> 2>i need to select "bres.rule_id" from my another table
> "BusinessRule_ResFiles_Data"
>
> so i have a total select of 4 columns based on a join of 2 tables.
>
> so please help me to correct the "query.xml" file such that i can
> accomplish
> the selection of 4 columns and retrieve it back as a list in my service
> class
>
>
>
> --
> View this message in context:
> http://old.nabble.com/Issue-with-join-of-2-tables-in-Ibatis-tp26612861p26612861.html
> Sent from the iBATIS - Dev mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscr...@ibatis.apache.org
> For additional commands, e-mail: dev-h...@ibatis.apache.org
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscr...@ibatis.apache.org
> For additional commands, e-mail: dev-h...@ibatis.apache.org
>
>
>
--
View this message in context:
http://old.nabble.com/Issue-with-join-of-2-tables-in-Ibatis-tp26612861p26621512.html
Sent from the iBATIS - Dev mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@ibatis.apache.org
For additional commands, e-mail: dev-h...@ibatis.apache.org
