Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Date: Thu, 05 Jan 2006 10:16:09 -0700
From: Nathan Maves <Nathan.Maves@Sun.COM>
Subject: Re: sql joins in ibatis
In-reply-to: <20060105164739.21069.qmail@web32508.mail.mud.yahoo.com>
Sender: Nathan.Maves@Sun.COM
To: user-java@ibatis.apache.org
Message-id: <BB2EBC06-BDED-48D4-9C7B-C88B98C50082@sun.com>
MIME-version: 1.0
Content-type: multipart/alternative;
 boundary="Boundary_(ID_Zx0rAYbeQilRhfqFAIiEaQ)"
References: <20060105164739.21069.qmail@web32508.mail.mud.yahoo.com>


--Boundary_(ID_Zx0rAYbeQilRhfqFAIiEaQ)
Content-type: text/plain; format=flowed; delsp=yes; charset=US-ASCII
Content-transfer-encoding: 7BIT

Where to start.....

ClassNotFound is a java error.  You have either misspelled you class  
name and or package.  Check that you full class name including  
package is correct.

The second problem that I see is in your result map.  You specify  
dept.name when there is no property named that in your Dept.class.   
You have deptName so your result map should be dept.deptName.

Nathan

On Jan 5, 2006, at 9:47 AM, radha rukmani wrote:

> Hi
>
> Can you please give more elaborate explanation.
>
> I changed person.java to look like
>
> public class Person
> {
>   private int id;
>   private String firstName;
>   private String lastName;
>   private Date birthDate;
>   private double weightInKilograms;
>   private double heightInMeters;
>   private int deptNumber;
>   private Dept dept;
>
>   public int getId()
>   {
>    return id;
>   }
>
>   public void setId(int id)
>   {
>    this.id = id;
>   }
>   public String getFirstName()
>   {
>    return firstName;
>   }
>
>   public void setFirstName(String firstName)
>   {
>    this.firstName = firstName;
>   }
>   public String getLastName()
>   {
>    return lastName;
>   }
>
>   public void setLastName(String lastName)
>   {
>    this.lastName = lastName;
>   }
>
>   public Date getBirthDate()
>   {
>    return birthDate;
>   }
>
>   public void setBirthDate(Date birthDate)
>   {
>    this.birthDate = birthDate;
>   }
>   public double getWeightInKilograms()
>   {
>    return weightInKilograms;
>   }
>
>   public void setWeightInKilograms(double weightInKilograms)
>   {
>    this.weightInKilograms = weightInKilograms;
>    ;}
>   public double getHeightInMeters()
>   {
>    return heightInMeters;
>   }
>
>   public void setHeightInMeters(double heightInMeters)
>   {
>    this.heightInMeters = heightInMeters;
>   }
>   public int getDeptNumber()
>   {
>    return deptNumber;
>   }
>
>   public void setDeptNumber(int deptNumber)
>   {
>    this.deptNumber = deptNumber;
>   }
>
>   public void setDeptName(String deptName)
>   {
>    this.dept.setDeptName(deptName);
>   }
>   public String getDeptName()
>   {
>    return dept.getDeptName();
>   }
>   public void setDeptId(int deptId)
>   {
>    this.dept.setDeptId(deptId);
>   }
>
>   public int getDeptId()
>   {
>    return dept.getDeptId();
>   }
> }
>
> and Dept.java is,
> public class Dept
> {
>   private int deptId;
>   private String deptName;
>
>   public int getDeptId()
>   {
>    return deptId;
>   }
>
>   public void setDeptId(int deptId)
>   {
>    this.deptId = deptId;
>   }
>   public String getDeptName()
>   {
>    return deptName;
>   }
>
>   public void setDeptName(String deptName)
>   {
>    this.deptName = deptName;
>   }
> }
> and the Person.xml is like
>
> <typeAlias alias="dept" type="com.pfizer.geca.batchProcess.Dept"/>
>
> <resultMap id="personMap" class="com.pfizer.geca.batchProcess.Person">
> <result property="firstName" column="PER_FIRST_NAME"/>
> <result property="dept.name" column="DEPT_NAME"/>
> </resultMap>
>
> <select id="getPersonByDept1" resultMap="personMap">
> SELECT
> PER_FIRST_NAME,
> DEPT_NAME
> FROM PERSON, DEPT
> WHERE DEPT.DEPT_NO = PERSON.DEPT_NO
> AND DEPT.DEPT_NO=#value#
> </select>
>
> It throws me this error,
>
> Caused by: com.ibatis.common.exception.NestedRuntimeException:  
> Error configuring Result. Could not set ResultClass. Cause:  
> java.lang.ClassNotFoundException: com.comp.app.batchProcess.Person
> Caused by: java.lang.ClassNotFoundException:  
> com.comp.app.batchProcess.Person
> at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:53)
> at com.ibatis.sqlmap.engine.builder.xml.SqlMapParser.parse 
> (SqlMapParser.java:45)
> at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser 
> $11.process(SqlMapConfigParser.java:347)
> at com.ibatis.common.xml.NodeletParser.processNodelet 
> (NodeletParser.java:112)
> ... 8 more
> Caused by: com.ibatis.common.exception.NestedRuntimeException:  
> Error parsing XPath '/sqlMap/resultMap'.  
> Cause:com.ibatis.common.exception.NestedRuntimeException: Error  
> configuring Result. Could not set ResultClass. Cause:  
> java.lang.ClassNotFoundException: com.comp.app.batchProcess.Person
> Caused by: java.lang.ClassNotFoundException:  
> com.comp.app.batchProcess.Person
> Caused by: com.ibatis.common.exception.NestedRuntimeException:  
> Error configuring Result. Could not set ResultClass. Cause:  
> java.lang.ClassNotFoundException: com.comp.app.batchProcess.Person
>
> Could you please let me know what should be done
>
> Thanks
>
> Zarar Siddiqi <zarar.siddiqi@utoronto.ca> wrote:
> Consider using composition:
>
> public class Person {
>     private Dept dept;
>     ...
> }
>
> Then you can use a resultMap and assign values to bean properties  
> by doing:
>
> <result property="dept.name" column="PER_DEPT_NAME"/>
>
> So you'll have:
>
> <select id="getPerson" resultMap="personMap">
>     ....
> </select>
>
> <resultMap id="personMap" class="com.comp.app.batchProcess.Person">
>     <result property="dept.name" column="PER_DEPT_NAME"/>
>     ......
> </resultMap>
>
> Zarar
>
> ----- Original Message -----
> From: radha rukmani
> To: user-java@ibatis.apache.org
> Sent: Wednesday, January 04, 2006 5:44 PM
> Subject: sql joins in ibatis
>
> Hi
> I am new to iBATIS. I was able to run the person example in the  
> ibatis website.
> For one table, the example says,
> <select id="getPerson" resultClass="com.comp.app.batchProcess.Person">
>           SELECT
>                PER_ID as id,
>                PER_FIRST_NAME as firstName,
>                PER_LAST_NAME as lastName,
>                PER_BIRTH_DATE as birthDate,
>                PER_WEIGHT_KG as weightInKilograms,
>                PER_HEIGHT_M as heightInMeters
>           FROM PERSON
>           WHERE PER_ID=#value#
>      </select>
> but if i want details from two tables, say person and dept table. I  
> have two bean classes person.java and dept.java
> and if i want to select like,
> select per_id as id, per_first_name as firstname, dept_name as  
> deptname from person,dept where dept_no = 2
> now  resultClass="com.comp.app.batchProcess.Person" and   
> "com.comp.app.batchProcess.Dept"
> how to get around this. Any help is greatly appreciated.
> Thanks
>
> Yahoo! DSL Something to write home about. Just $16.99/mo. or less
>
>
> Yahoo! Photos
> Ring in the New Year with Photo Calendars. Add photos, events,  
> holidays, whatever.


--Boundary_(ID_Zx0rAYbeQilRhfqFAIiEaQ)
Content-type: text/html; charset=ISO-8859-1
Content-transfer-encoding: QUOTED-PRINTABLE

<HTML><BODY style=3D"word-wrap: break-word; -khtml-nbsp-mode: space; =
-khtml-line-break: after-white-space; ">Where to start.....<DIV><BR c=
lass=3D"khtml-block-placeholder"></DIV><DIV>ClassNotFound is a java e=
rror.=A0 You have either=A0misspelled you class name and or package.=
=A0 Check that you full class name including package is correct.</DIV=
><DIV><BR class=3D"khtml-block-placeholder"></DIV><DIV>The second pro=
blem that I see is in your result map.=A0 You specify dept.name when =
there is no property named that in your Dept.class.=A0 You have deptN=
ame so your result map should be dept.deptName.</DIV><DIV><BR class=
=3D"khtml-block-placeholder"></DIV><DIV>Nathan</DIV><DIV><BR><DIV><DI=
V>On Jan 5, 2006, at 9:47 AM, radha rukmani wrote:</DIV><BR class=
=3D"Apple-interchange-newline"><BLOCKQUOTE type=3D"cite"><SPAN class=
=3D"Apple-style-span" style=3D"border-collapse: separate; border-spac=
ing: 0px 0px; color: rgb(0, 0, 0); font-family: Helvetica; font-size:=
 12px; font-style: normal; font-variant: normal; font-weight: normal;=
 letter-spacing: normal; line-height: normal; text-align: auto; -khtm=
l-text-decorations-in-effect: none; text-indent: 0px; -apple-text-siz=
e-adjust: auto; text-transform: none; orphans: 2; white-space: normal=
; widows: 2; word-spacing: 0px; "><DIV>Hi</DIV><DIV>=A0</DIV><DIV>Can=
 you please give more elaborate explanation.</DIV><DIV>=A0</DIV><DIV>=
I changed person.java to look like</DIV><DIV>=A0</DIV><DIV>public cla=
ss Person<BR>{<BR>=A0=A0private int id;<BR>=A0=A0private String first=
Name;<BR>=A0=A0private String lastName;<BR>=A0=A0private Date birthDa=
te;<BR>=A0=A0private double weightInKilograms;<BR>=A0=A0private doubl=
e heightInMeters;<BR>=A0=A0private int deptNumber;<BR>=A0=A0private D=
ept dept;<BR>=A0=A0<BR>=A0=A0public int getId()<BR>=A0=A0{<BR>=A0=
=A0=A0return id;<BR>=A0=A0}<BR>=A0=A0<BR>=A0=A0public void setId(int =
id)<BR>=A0=A0{<BR>=A0=A0=A0this.id =3D id;<SPAN class=3D"Apple-conver=
ted-space">=A0</SPAN><BR>=A0=A0}</DIV><DIV>=A0=A0public String getFir=
stName()<BR>=A0=A0{<BR>=A0=A0=A0return firstName;<BR>=A0=A0}<BR>=A0=
=A0<BR>=A0=A0public void setFirstName(String firstName)<BR>=A0=A0{<BR=
>=A0=A0=A0this.firstName =3D firstName;<SPAN class=3D"Apple-converted=
-space">=A0</SPAN><BR>=A0=A0}</DIV><DIV>=A0=A0public String getLastNa=
me()<BR>=A0=A0{<BR>=A0=A0=A0return lastName;<BR>=A0=A0}<BR>=A0=A0<BR>=
=A0=A0public void setLastName(String lastName)<BR>=A0=A0{<BR>=A0=A0=
=A0this.lastName =3D lastName;<SPAN class=3D"Apple-converted-space">=
=A0</SPAN><BR>=A0=A0}<BR>=A0=A0<BR>=A0=A0public Date getBirthDate()<B=
R>=A0=A0{<BR>=A0=A0=A0return birthDate;<BR>=A0=A0}<BR>=A0=A0<BR>=A0=
=A0public void setBirthDate(Date birthDate)<BR>=A0=A0{<BR>=A0=A0=A0th=
is.birthDate =3D birthDate;<SPAN class=3D"Apple-converted-space">=
=A0</SPAN><BR>=A0=A0}</DIV><DIV>=A0=A0public double getWeightInKilogr=
ams()<BR>=A0=A0{<BR>=A0=A0=A0return weightInKilograms;<BR>=A0=A0}<BR>=
=A0=A0<BR>=A0=A0public void setWeightInKilograms(double weightInKilog=
rams)<BR>=A0=A0{<BR>=A0=A0=A0this.weightInKilograms =3D weightInKilog=
rams;<SPAN class=3D"Apple-converted-space">=A0</SPAN><BR>=A0=A0 ;}</D=
IV><DIV>=A0=A0public double getHeightInMeters()<BR>=A0=A0{<BR>=A0=
=A0=A0return heightInMeters;<BR>=A0=A0}<BR>=A0=A0<BR>=A0=A0public voi=
d setHeightInMeters(double heightInMeters)<BR>=A0=A0{<BR>=A0=A0=A0thi=
s.heightInMeters =3D heightInMeters;<SPAN class=3D"Apple-converted-sp=
ace">=A0</SPAN><BR>=A0=A0}<BR>=A0=A0public int getDeptNumber()<BR>=
=A0=A0{<BR>=A0=A0=A0return deptNumber;<BR>=A0=A0}<BR>=A0=A0<BR>=A0=
=A0public void setDeptNumber(int deptNumber)<BR>=A0=A0{<BR>=A0=A0=
=A0this.deptNumber =3D deptNumber;<SPAN class=3D"Apple-converted-spac=
e">=A0</SPAN><BR>=A0=A0}=A0=A0<BR>=A0=A0<BR>=A0=A0public void setDept=
Name(String deptName)<BR>=A0=A0{<BR>=A0=A0=A0this.dept.setDeptName(de=
ptName);<BR>=A0=A0}</DIV><DIV>=A0=A0public String getDeptName()<BR>=
=A0=A0{<BR>=A0=A0=A0return dept.getDeptName();<BR>=A0=A0}</DIV><DIV>=
=A0=A0public void setDeptId(int deptId)<BR>=A0=A0{<BR>=A0=A0=A0this.d=
ept.setDeptId(deptId);<BR>=A0=A0}<BR>=A0=A0<BR>=A0=A0public int getDe=
ptId()<BR>=A0=A0{<BR>=A0=A0=A0return dept.getDeptId();<BR>=A0=A0}<BR>=
}<BR><BR>and Dept.java is,</DIV><DIV>public class Dept<BR>{<BR>=A0=
=A0private int deptId;<BR>=A0=A0private String deptName;<BR>=A0=A0<BR=
>=A0=A0public int getDeptId()<BR>=A0=A0{<BR>=A0=A0=A0return deptId;<B=
R>=A0=A0}<BR>=A0=A0<BR>=A0=A0public void setDeptId(int deptId)<BR>=
=A0=A0{<BR>=A0=A0=A0this.deptId =3D deptId;<SPAN class=3D"Apple-conve=
rted-space">=A0</SPAN><BR>=A0=A0}</DIV><DIV>=A0=A0public String getDe=
ptName()<BR>=A0=A0{<BR>=A0=A0=A0return deptName;<BR>=A0=A0}<BR>=A0=
=A0<BR>=A0=A0public void setDeptName(String deptName)<BR>=A0=A0{<BR>=
=A0=A0=A0this.deptName =3D deptName;<SPAN class=3D"Apple-converted-sp=
ace">=A0</SPAN><BR>=A0=A0}<BR>}<BR></DIV><DIV>and the Person.xml is l=
ike</DIV><DIV>=A0</DIV><DIV><FONT color=3D"#008080" size=3D"2"><SPAN =
class=3D"Apple-style-span" style=3D"color: rgb(0, 128, 128); font-siz=
e: 10px; "></SPAN></FONT><DIV><FONT color=3D"#008080" size=3D"2"><SPA=
N class=3D"Apple-style-span" style=3D"color: rgb(0, 128, 128); font-s=
ize: 10px; ">&lt;</SPAN></FONT><FONT color=3D"#3f7f7f" size=3D"2"><SP=
AN class=3D"Apple-style-span" style=3D"color: rgb(63, 127, 127); font=
-size: 10px; ">typeAlias </SPAN></FONT><FONT color=3D"#7f007f" size=
=3D"2"><SPAN class=3D"Apple-style-span" style=3D"color: rgb(127, 0, 1=
27); font-size: 10px; ">alias</SPAN></FONT><FONT size=3D"2"><SPAN cla=
ss=3D"Apple-style-span" style=3D"font-size: 10px; ">=3D</SPAN></FONT>=
<FONT color=3D"#2a00ff" size=3D"2"><SPAN class=3D"Apple-style-span" s=
tyle=3D"color: rgb(42, 0, 255); font-size: 10px; ">"dept" </SPAN></FO=
NT><FONT color=3D"#7f007f" size=3D"2"><SPAN class=3D"Apple-style-span=
" style=3D"color: rgb(127, 0, 127); font-size: 10px; ">type</SPAN></F=
ONT><FONT size=3D"2"><SPAN class=3D"Apple-style-span" style=3D"font-s=
ize: 10px; ">=3D</SPAN></FONT><FONT color=3D"#2a00ff" size=3D"2"><SPA=
N class=3D"Apple-style-span" style=3D"color: rgb(42, 0, 255); font-si=
ze: 10px; ">"com.pfizer.geca.batchProcess.Dept"</SPAN></FONT><FONT co=
lor=3D"#008080" size=3D"2"><SPAN class=3D"Apple-style-span" style=
=3D"color: rgb(0, 128, 128); font-size: 10px; ">/&gt;</SPAN></FONT></=
DIV><DIV><FONT color=3D"#008080" size=3D"2"><SPAN class=3D"Apple-styl=
e-span" style=3D"color: rgb(0, 128, 128); font-size: 10px; ">=A0</SPA=
N></FONT></DIV><FONT color=3D"#008080" size=3D"2"></FONT></DIV><FONT =
size=3D"2"><SPAN class=3D"Apple-style-span" style=3D"font-size: 10px;=
 "></SPAN></FONT><DIV><FONT size=3D"2"></FONT><FONT color=3D"#008080"=
 size=3D"2"><SPAN class=3D"Apple-style-span" style=3D"color: rgb(0, 1=
28, 128); font-size: 10px; ">&lt;</SPAN></FONT><FONT color=3D"#3f7f7f=
" size=3D"2"><SPAN class=3D"Apple-style-span" style=3D"color: rgb(63,=
 127, 127); font-size: 10px; ">resultMap </SPAN></FONT><FONT color=
=3D"#7f007f" size=3D"2"><SPAN class=3D"Apple-style-span" style=3D"col=
or: rgb(127, 0, 127); font-size: 10px; ">id</SPAN></FONT><FONT size=
=3D"2"><SPAN class=3D"Apple-style-span" style=3D"font-size: 10px; ">=
=3D</SPAN></FONT><FONT color=3D"#2a00ff" size=3D"2"><SPAN class=3D"Ap=
ple-style-span" style=3D"color: rgb(42, 0, 255); font-size: 10px; ">"=
personMap" </SPAN></FONT><FONT color=3D"#7f007f" size=3D"2"><SPAN cla=
ss=3D"Apple-style-span" style=3D"color: rgb(127, 0, 127); font-size: =
10px; ">class</SPAN></FONT><FONT size=3D"2"><SPAN class=3D"Apple-styl=
e-span" style=3D"font-size: 10px; ">=3D</SPAN></FONT><FONT color=3D"#=
2a00ff" size=3D"2"><SPAN class=3D"Apple-style-span" style=3D"color: r=
gb(42, 0, 255); font-size: 10px; ">"com.pfizer.geca.batchProcess.Pers=
on"</SPAN></FONT><FONT color=3D"#008080" size=3D"2"><SPAN class=3D"Ap=
ple-style-span" style=3D"color: rgb(0, 128, 128); font-size: 10px; ">=
&gt;</SPAN></FONT></DIV><FONT color=3D"#008080" size=3D"2"></FONT><FO=
NT size=3D"2"><SPAN class=3D"Apple-style-span" style=3D"font-size: 10=
px; "></SPAN></FONT><DIV><FONT size=3D"2"></FONT><FONT color=3D"#0080=
80" size=3D"2"><SPAN class=3D"Apple-style-span" style=3D"color: rgb(0=
, 128, 128); font-size: 10px; ">&lt;</SPAN></FONT><FONT color=3D"#3f7=
f7f" size=3D"2"><SPAN class=3D"Apple-style-span" style=3D"color: rgb(=
63, 127, 127); font-size: 10px; ">result </SPAN></FONT><FONT color=
=3D"#7f007f" size=3D"2"><SPAN class=3D"Apple-style-span" style=3D"col=
or: rgb(127, 0, 127); font-size: 10px; ">property</SPAN></FONT><FONT =
size=3D"2"><SPAN class=3D"Apple-style-span" style=3D"font-size: 10px;=
 ">=3D</SPAN></FONT><FONT color=3D"#2a00" ff=3D"" size=3D"2"><SPAN cl=
ass=3D"Apple-style-span" style=3D"color: rgb(42, 0, 0); font-size: 10=
px; ">"firstName" </SPAN></FONT><FONT color=3D"#7f007f" size=3D"2"><S=
PAN class=3D"Apple-style-span" style=3D"color: rgb(127, 0, 127); font=
-size: 10px; ">column</SPAN></FONT><FONT size=3D"2"><SPAN class=3D"Ap=
ple-style-span" style=3D"font-size: 10px; ">=3D</SPAN></FONT><FONT co=
lor=3D"#2a00ff" size=3D"2"><SPAN class=3D"Apple-style-span" style=
=3D"color: rgb(42, 0, 255); font-size: 10px; ">"PER_FIRST_NAME"</SPAN=
></FONT><FONT color=3D"#008080" size=3D"2"><SPAN class=3D"Apple-style=
-span" style=3D"color: rgb(0, 128, 128); font-size: 10px; ">/&gt;</SP=
AN></FONT></DIV><FONT color=3D"#008080" size=3D"2"></FONT><FONT size=
=3D"2"><SPAN class=3D"Apple-style-span" style=3D"font-size: 10px; "><=
/SPAN></FONT><DIV><FONT size=3D"2"></FONT><FONT color=3D"#008080" siz=
e=3D"2"><SPAN class=3D"Apple-style-span" style=3D"color: rgb(0, 128, =
128); font-size: 10px; ">&lt;</SPAN></FONT><FONT color=3D"#3f7f7f" si=
ze=3D"2"><SPAN class=3D"Apple-style-span" style=3D"color: rgb(63, 127=
, 127); font-size: 10px; ">result </SPAN></FONT><FONT color=3D"#7f007=
f" size=3D"2"><SPAN class=3D"Apple-style-span" style=3D"color: rgb(12=
7, 0, 127); font-size: 10px; ">property</SPAN></FONT><FONT size=3D"2"=
><SPAN class=3D"Apple-style-span" style=3D"font-size: 10px; ">=3D</SP=
AN></FONT><FONT color=3D"#2a00ff" size=3D"2"><SPAN class=3D"Apple-sty=
le-span" style=3D"color: rgb(42, 0, 255); font-size: 10px; ">"dept.na=
me" </SPAN></FONT><FONT color=3D"#7f007f" size=3D"2"><SPAN class=3D"A=
pple-style-span" style=3D"color: rgb(127, 0, 127); font-size: 10px; "=
>column</SPAN></FONT><FONT size=3D"2"><SPAN class=3D"Apple-style-span=
" style=3D"font-size: 10px; ">=3D</SPAN></FONT><FONT color=3D"#2a00ff=
" size=3D"2"><SPAN class=3D"Apple-style-span" style=3D"color: rgb(42,=
 0, 255); font-size: 10px; ">"DEPT_NAME"</SPAN></FONT><FONT color=
=3D"#008080" size=3D"2"><SPAN class=3D"Apple-style-span" style=3D"col=
or: rgb(0, 128, 128); font-size: 10px; ">/&gt;</SPAN></FONT></DIV><FO=
NT color=3D"#008080" size=3D"2"></FONT><FONT size=3D"2"><SPAN class=
=3D"Apple-style-span" style=3D"font-size: 10px; "></SPAN></FONT><DIV>=
<FONT size=3D"2"></FONT><FONT color=3D"#008080" size=3D"2"><SPAN clas=
s=3D"Apple-style-span" style=3D"color: rgb(0, 128, 128); font-size: 1=
0px; ">&lt;/</SPAN></FONT><FONT color=3D"#3f7f7f" size=3D"2"><SPAN cl=
ass=3D"Apple-style-span" style=3D"color: rgb(63, 127, 127); font-size=
: 10px; ">resultMap</SPAN></FONT><FONT color=3D"#008080" size=3D"2"><=
SPAN class=3D"Apple-style-span" style=3D"color: rgb(0, 128, 128); fon=
t-size: 10px; ">&gt;</SPAN></FONT></DIV><DIV><FONT color=3D"#008080" =
size=3D"2"><SPAN class=3D"Apple-style-span" style=3D"color: rgb(0, 12=
8, 128); font-size: 10px; ">=A0</SPAN></FONT></DIV><FONT color=3D"#00=
8080" size=3D"2"></FONT><FONT size=3D"2"><SPAN class=3D"Apple-style-s=
pan" style=3D"font-size: 10px; "></SPAN></FONT><DIV><FONT size=3D"2">=
</FONT><FONT color=3D"#008080" size=3D"2"><SPAN class=3D"Apple-style-=
span" style=3D"color: rgb(0, 128, 128); font-size: 10px; ">&lt;</SPAN=
></FONT><FONT color=3D"#3f7f7f" size=3D"2"><SPAN class=3D"Apple-style=
-span" style=3D"color: rgb(63, 127, 127); font-size: 10px; ">select <=
/SPAN></FONT><FONT color=3D"#7f007f" size=3D"2"><SPAN class=3D"Apple-=
style-span" style=3D"color: rgb(127, 0, 127); font-size: 10px; ">id</=
SPAN></FONT><FONT size=3D"2"><SPAN class=3D"Apple-style-span" style=
=3D"font-size: 10px; ">=3D</SPAN></FONT><FONT color=3D"#2a00ff" size=
=3D"2"><SPAN class=3D"Apple-style-span" style=3D"color: rgb(42, 0, 25=
5); font-size: 10px; ">"getPersonByDept1" </SPAN></FONT><FONT color=
=3D"#7f007f" size=3D"2"><SPAN class=3D"Apple-style-span" style=3D"col=
or: rgb(127, 0, 127); font-size: 10px; ">resultMap</SPAN></FONT><FONT=
 size=3D"2"><SPAN class=3D"Apple-style-span" style=3D"font-size: 10px=
; ">=3D</SPAN></FONT><FONT color=3D"#2a00ff" size=3D"2"><SPAN class=
=3D"Apple-style-span" style=3D"color: rgb(42, 0, 255); font-size: 10p=
x; ">"personMap"</SPAN></FONT><FONT color=3D"#008080" size=3D"2"><SPA=
N class=3D"Apple-style-span" style=3D"color: rgb(0, 128, 128); font-s=
ize: 10px; ">&gt;</SPAN></FONT></DIV><FONT color=3D"#008080" size=
=3D"2"></FONT><FONT size=3D"2"><SPAN class=3D"Apple-style-span" style=
=3D"font-size: 10px; "></SPAN><DIV style=3D"font-size: 10px; "><SPAN =
class=3D"Apple-style-span" style=3D"font-size: 10px; ">SELECT</SPAN><=
/DIV><DIV style=3D"font-size: 10px; "><SPAN class=3D"Apple-style-span=
" style=3D"font-size: 10px; ">PER_FIRST_NAME,</SPAN></DIV><DIV style=
=3D"font-size: 10px; "><SPAN class=3D"Apple-style-span" style=3D"font=
-size: 10px; ">DEPT_NAME</SPAN></DIV><DIV style=3D"font-size: 10px; "=
><SPAN class=3D"Apple-style-span" style=3D"font-size: 10px; ">FROM PE=
RSON, DEPT</SPAN></DIV><DIV style=3D"font-size: 10px; "><SPAN class=
=3D"Apple-style-span" style=3D"font-size: 10px; ">WHERE DEPT.DEPT_NO =
=3D PERSON.DEPT_NO</SPAN></DIV><DIV style=3D"font-size: 10px; "><SPAN=
 class=3D"Apple-style-span" style=3D"font-size: 10px; ">AND DEPT.DEPT=
_NO=3D#value#</SPAN></DIV></FONT><DIV><FONT size=3D"2"></FONT><FONT c=
olor=3D"#008080" size=3D"2"><SPAN class=3D"Apple-style-span" style=
=3D"color: rgb(0, 128, 128); font-size: 10px; ">&lt;/</SPAN></FONT><F=
ONT color=3D"#3f7f7f" size=3D"2"><SPAN class=3D"Apple-style-span" sty=
le=3D"color: rgb(63, 127, 127); font-size: 10px; ">select</SPAN></FON=
T><FONT color=3D"#008080" size=3D"2"><SPAN class=3D"Apple-style-span"=
 style=3D"color: rgb(0, 128, 128); font-size: 10px; ">&gt;</SPAN></FO=
NT><FONT size=3D"2"><SPAN class=3D"Apple-style-span" style=3D"font-si=
ze: 10px; "></SPAN></FONT></DIV><DIV><FONT size=3D"2"></FONT>=A0</DIV=
><DIV><FONT size=3D"2"><SPAN class=3D"Apple-style-span" style=3D"font=
-size: 10px; ">It throws me this error,</SPAN></FONT></DIV><DIV><FONT=
 size=3D"2"></FONT>=A0</DIV><FONT size=3D"2"><FONT color=3D"#ff0000" =
size=3D"2"><SPAN class=3D"Apple-style-span" style=3D"color: rgb(255, =
0, 0); font-size: 10px; "></SPAN></FONT><DIV style=3D"font-size: 10px=
; "><FONT color=3D"#ff0000" size=3D"2"><SPAN class=3D"Apple-style-spa=
n" style=3D"color: rgb(255, 0, 0); font-size: 10px; ">Caused by: </SP=
AN></FONT><U style=3D"font-size: 10px; -khtml-text-decorations-in-eff=
ect: underline; "><FONT color=3D"#000080" size=3D"2"><SPAN class=3D"A=
pple-style-span" style=3D"color: rgb(0, 0, 128); font-size: 10px; -kh=
tml-text-decorations-in-effect: underline; ">com.ibatis.common.except=
ion.NestedRuntimeException</SPAN></FONT></U><FONT color=3D"#000080" s=
ize=3D"2"></FONT><FONT color=3D"#ff0000" size=3D"2"><SPAN class=3D"Ap=
ple-style-span" style=3D"color: rgb(255, 0, 0); font-size: 10px; ">: =
Error configuring Result. Could not set ResultClass. Cause: </SPAN></=
FONT><U style=3D"font-size: 10px; -khtml-text-decorations-in-effect: =
underline; "><FONT color=3D"#000080" size=3D"2"><SPAN class=3D"Apple-=
style-span" style=3D"color: rgb(0, 0, 128); font-size: 10px; -khtml-t=
ext-decorations-in-effect: underline; ">java.lang.ClassNotFoundExcept=
ion</SPAN></FONT></U><FONT color=3D"#000080" size=3D"2"></FONT><FONT =
color=3D"#ff0000" size=3D"2"><SPAN class=3D"Apple-style-span" style=
=3D"color: rgb(255, 0, 0); font-size: 10px; ">: com.comp.app.batchPro=
cess.Person</SPAN></FONT></DIV><FONT color=3D"#ff0000" size=3D"2"><SP=
AN class=3D"Apple-style-span" style=3D"color: rgb(255, 0, 0); font-si=
ze: 10px; "></SPAN></FONT><DIV style=3D"font-size: 10px; "><FONT colo=
r=3D"#ff0000" size=3D"2"><SPAN class=3D"Apple-style-span" style=3D"co=
lor: rgb(255, 0, 0); font-size: 10px; ">Caused by: </SPAN></FONT><U s=
tyle=3D"font-size: 10px; -khtml-text-decorations-in-effect: underline=
; "><FONT color=3D"#000080" size=3D"2"><SPAN class=3D"Apple-style-spa=
n" style=3D"color: rgb(0, 0, 128); font-size: 10px; -khtml-text-decor=
ations-in-effect: underline; ">java.lang.ClassNotFoundException</SPAN=
></FONT></U><FONT color=3D"#000080" size=3D"2"></FONT><FONT color=
=3D"#ff0000" size=3D"2"><SPAN class=3D"Apple-style-span" style=3D"col=
or: rgb(255, 0, 0); font-size: 10px; ">: com.comp.app.batchProcess.Pe=
rson</SPAN></FONT></DIV><FONT color=3D"#ff0000" size=3D"2"><SPAN clas=
s=3D"Apple-style-span" style=3D"color: rgb(255, 0, 0); font-size: 10p=
x; "></SPAN></FONT><DIV style=3D"font-size: 10px; "><FONT color=3D"#f=
f0000" size=3D"2"><SPAN class=3D"Apple-style-span" style=3D"color: rg=
b(255, 0, 0); font-size: 10px; ">at com.ibatis.common.xml.NodeletPars=
er.parse(</SPAN></FONT><U style=3D"font-size: 10px; -khtml-text-decor=
ations-in-effect: underline; "><FONT color=3D"#000080" size=3D"2"><SP=
AN class=3D"Apple-style-span" style=3D"color: rgb(0, 0, 128); font-si=
ze: 10px; -khtml-text-decorations-in-effect: underline; ">NodeletPars=
er.java:53</SPAN></FONT></U><FONT color=3D"#000080" size=3D"2"></FONT=
><FONT color=3D"#ff0000" size=3D"2"><SPAN class=3D"Apple-style-span" =
style=3D"color: rgb(255, 0, 0); font-size: 10px; ">)</SPAN></FONT></D=
IV><FONT color=3D"#ff0000" size=3D"2"><SPAN class=3D"Apple-style-span=
" style=3D"color: rgb(255, 0, 0); font-size: 10px; "></SPAN></FONT><D=
IV style=3D"font-size: 10px; "><FONT color=3D"#ff0000" size=3D"2"><SP=
AN class=3D"Apple-style-span" style=3D"color: rgb(255, 0, 0); font-si=
ze: 10px; ">at com.ibatis.sqlmap.engine.builder.xml.SqlMapParser.pars=
e(</SPAN></FONT><U style=3D"font-size: 10px; -khtml-text-decorations-=
in-effect: underline; "><FONT color=3D"#000080" size=3D"2"><SPAN clas=
s=3D"Apple-style-span" style=3D"color: rgb(0, 0, 128); font-size: 10p=
x; -khtml-text-decorations-in-effect: underline; ">SqlMapParser.java:=
45</SPAN></FONT></U><FONT color=3D"#000080" size=3D"2"></FONT><FONT c=
olor=3D"#ff0000" size=3D"2"><SPAN class=3D"Apple-style-span" style=
=3D"color: rgb(255, 0, 0); font-size: 10px; ">)</SPAN></FONT></DIV><F=
ONT color=3D"#ff0000" size=3D"2"><SPAN class=3D"Apple-style-span" sty=
le=3D"color: rgb(255, 0, 0); font-size: 10px; "></SPAN></FONT><DIV st=
yle=3D"font-size: 10px; "><FONT color=3D"#ff0000" size=3D"2"><SPAN cl=
ass=3D"Apple-style-span" style=3D"color: rgb(255, 0, 0); font-size: 1=
0px; ">at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser$11.=
process(</SPAN></FONT><U style=3D"font-size: 10px; -khtml-text-decora=
tions-in-effect: underline; "><FONT color=3D"#000080" size=3D"2"><SPA=
N class=3D"Apple-style-span" style=3D"color: rgb(0, 0, 128); font-siz=
e: 10px; -khtml-text-decorations-in-effect: underline; ">SqlMapConfig=
Parser.java:347</SPAN></FONT></U><FONT color=3D"#000080" size=3D"2"><=
/FONT><FONT color=3D"#ff0000" size=3D"2"><SPAN class=3D"Apple-style-s=
pan" style=3D"color: rgb(255, 0, 0); font-size: 10px; ">)</SPAN></FON=
T></DIV><FONT color=3D"#ff0000" size=3D"2"><SPAN class=3D"Apple-style=
-span" style=3D"color: rgb(255, 0, 0); font-size: 10px; "></SPAN></FO=
NT><DIV style=3D"font-size: 10px; "><FONT color=3D"#ff0000" size=3D"2=
"><SPAN class=3D"Apple-style-span" style=3D"color: rgb(255, 0, 0); fo=
nt-size: 10px; ">at com.ibatis.common.xml.NodeletParser.processNodele=
t(</SPAN></FONT><U style=3D"font-size: 10px; -khtml-text-decorations-=
in-effect: underline; "><FONT color=3D"#000080" size=3D"2"><SPAN clas=
s=3D"Apple-style-span" style=3D"color: rgb(0, 0, 128); font-size: 10p=
x; -khtml-text-decorations-in-effect: underline; ">NodeletParser.java=
:112</SPAN></FONT></U><FONT color=3D"#000080" size=3D"2"></FONT><FONT=
 color=3D"#ff0000" size=3D"2"><SPAN class=3D"Apple-style-span" style=
=3D"color: rgb(255, 0, 0); font-size: 10px; ">)</SPAN></FONT></DIV><F=
ONT color=3D"#ff0000" size=3D"2"><SPAN class=3D"Apple-style-span" sty=
le=3D"color: rgb(255, 0, 0); font-size: 10px; "></SPAN><DIV style=
=3D"color: rgb(255, 0, 0); font-size: 10px; "><SPAN class=3D"Apple-st=
yle-span" style=3D"color: rgb(255, 0, 0); font-size: 10px; ">... 8 mo=
re</SPAN></DIV></FONT><DIV style=3D"font-size: 10px; "><FONT color=
=3D"#ff0000" size=3D"2"><SPAN class=3D"Apple-style-span" style=3D"col=
or: rgb(255, 0, 0); font-size: 10px; ">Caused by: </SPAN></FONT><U st=
yle=3D"font-size: 10px; -khtml-text-decorations-in-effect: underline;=
 "><FONT color=3D"#000080" size=3D"2"><SPAN class=3D"Apple-style-span=
" style=3D"color: rgb(0, 0, 128); font-size: 10px; -khtml-text-decora=
tions-in-effect: underline; ">com.ibatis.common.exception.NestedRunti=
meException</SPAN></FONT></U><FONT color=3D"#000080" size=3D"2"></FON=
T><FONT color=3D"#ff0000" size=3D"2"><SPAN class=3D"Apple-style-span"=
 style=3D"color: rgb(255, 0, 0); font-size: 10px; ">: Error parsing X=
Path '/sqlMap/resultMap'. Cause:</SPAN></FONT><U style=3D"font-size: =
10px; -khtml-text-decorations-in-effect: underline; "><FONT color=
=3D"#000080" size=3D"2"><SPAN class=3D"Apple-style-span" style=3D"col=
or: rgb(0, 0, 128); font-size: 10px; -khtml-text-decorations-in-effec=
t: underline; ">com.ibatis.common.exception.NestedRuntimeException</S=
PAN></FONT></U><FONT color=3D"#000080" size=3D"2"></FONT><FONT color=
=3D"#ff0000" size=3D"2"><SPAN class=3D"Apple-style-span" style=3D"col=
or: rgb(255, 0, 0); font-size: 10px; ">: Error configuring Result. Co=
uld not set ResultClass. Cause: </SPAN></FONT><U style=3D"font-size: =
10px; -khtml-text-decorations-in-effect: underline; "><FONT color=
=3D"#000080" size=3D"2"><SPAN class=3D"Apple-style-span" style=3D"col=
or: rgb(0, 0, 128); font-size: 10px; -khtml-text-decorations-in-effec=
t: underline; ">java.lang.ClassNotFoundException</SPAN></FONT></U><FO=
NT color=3D"#000080" size=3D"2"></FONT><FONT color=3D"#ff0000" size=
=3D"2"><SPAN class=3D"Apple-style-span" style=3D"color: rgb(255, 0, 0=
); font-size: 10px; ">: com.comp.app.batchProcess.Person</SPAN></FONT=
></DIV><FONT color=3D"#ff0000" size=3D"2"><SPAN class=3D"Apple-style-=
span" style=3D"color: rgb(255, 0, 0); font-size: 10px; "></SPAN></FON=
T><DIV style=3D"font-size: 10px; "><FONT color=3D"#ff0000" size=3D"2"=
><SPAN class=3D"Apple-style-span" style=3D"color: rgb(255, 0, 0); fon=
t-size: 10px; ">Caused by: </SPAN></FONT><U style=3D"font-size: 10px;=
 -khtml-text-decorations-in-effect: underline; "><FONT color=3D"#0000=
80" size=3D"2"><SPAN class=3D"Apple-style-span" style=3D"color: rgb(0=
, 0, 128); font-size: 10px; -khtml-text-decorations-in-effect: underl=
ine; ">java.lang.ClassNotFoundException</SPAN></FONT></U><FONT color=
=3D"#000080" size=3D"2"></FONT><FONT color=3D"#ff0000" size=3D"2"><SP=
AN class=3D"Apple-style-span" style=3D"color: rgb(255, 0, 0); font-si=
ze: 10px; ">: com.comp.app.batchProcess.Person</SPAN></FONT></DIV><FO=
NT color=3D"#ff0000" size=3D"2"><SPAN class=3D"Apple-style-span" styl=
e=3D"color: rgb(255, 0, 0); font-size: 10px; "></SPAN></FONT><DIV sty=
le=3D"font-size: 10px; "><FONT color=3D"#ff0000" size=3D"2"><SPAN cla=
ss=3D"Apple-style-span" style=3D"color: rgb(255, 0, 0); font-size: 10=
px; ">Caused by: </SPAN></FONT><U style=3D"font-size: 10px; -khtml-te=
xt-decorations-in-effect: underline; "><FONT color=3D"#000080" size=
=3D"2"><SPAN class=3D"Apple-style-span" style=3D"color: rgb(0, 0, 128=
); font-size: 10px; -khtml-text-decorations-in-effect: underline; ">c=
om.ibatis.common.exception.NestedRuntimeException</SPAN></FONT></U><F=
ONT color=3D"#000080" size=3D"2"></FONT><FONT color=3D"#ff0000" size=
=3D"2"><SPAN class=3D"Apple-style-span" style=3D"color: rgb(255, 0, 0=
); font-size: 10px; ">: Error configuring Result. Could not set Resul=
tClass. Cause: </SPAN></FONT><U style=3D"font-size: 10px; -khtml-text=
-decorations-in-effect: underline; "><FONT color=3D"#000080" size=
=3D"2"><SPAN class=3D"Apple-style-span" style=3D"color: rgb(0, 0, 128=
); font-size: 10px; -khtml-text-decorations-in-effect: underline; ">j=
ava.lang.ClassNotFoundException</SPAN></FONT></U><FONT color=3D"#0000=
80" size=3D"2"></FONT><FONT color=3D"#ff0000" size=3D"2"><SPAN class=
=3D"Apple-style-span" style=3D"color: rgb(255, 0, 0); font-size: 10px=
; ">: com.comp.app.batchProcess.Person</SPAN></FONT></DIV><DIV style=
=3D"font-size: 10px; "><FONT color=3D"#ff0000" size=3D"2"></FONT><SPA=
N class=3D"Apple-style-span" style=3D"font-size: 10px; ">=A0</SPAN></=
DIV><DIV style=3D"font-size: 10px; "><FONT size=3D"2"><SPAN class=
=3D"Apple-style-span" style=3D"font-size: 10px; ">Could you please le=
t me know what should be done</SPAN></FONT></DIV><DIV style=3D"font-s=
ize: 10px; "><FONT size=3D"2"></FONT><SPAN class=3D"Apple-style-span"=
 style=3D"font-size: 10px; ">=A0</SPAN></DIV><DIV style=3D"font-size:=
 10px; "><FONT size=3D"2"><SPAN class=3D"Apple-style-span" style=3D"f=
ont-size: 10px; ">Thanks</SPAN></FONT></DIV><FONT size=3D"2"></FONT><=
/FONT><DIV>=A0</DIV><DIV><B style=3D"font-weight: bold; "><I style=
=3D"font-style: italic; font-weight: bold; "><SPAN class=3D"Apple-sty=
le-span" style=3D"font-style: italic; font-weight: bold; ">Zarar Sidd=
iqi &lt;<A href=3D"mailto:zarar.siddiqi@utoronto.ca">zarar.siddiqi@ut=
oronto.ca</A>&gt;</SPAN></I></B><SPAN class=3D"Apple-converted-space"=
>=A0</SPAN>wrote:</DIV><BLOCKQUOTE class=3D"replbq" style=3D"PADDING-=
LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid"><DIV><FO=
NT face=3D"Arial" size=3D"2"><SPAN class=3D"Apple-style-span" style=
=3D"font-family: Arial; font-size: 10px; ">Consider using composition=
:</SPAN></FONT></DIV><DIV><FONT face=3D"Arial" size=3D"2"></FONT>=
=A0</DIV><DIV><FONT face=3D"Arial" size=3D"2"><SPAN class=3D"Apple-st=
yle-span" style=3D"font-family: Arial; font-size: 10px; ">public clas=
s Person {</SPAN></FONT></DIV><DIV><FONT face=3D"Arial" size=3D"2"><S=
PAN class=3D"Apple-style-span" style=3D"font-family: Arial; font-size=
: 10px; ">=A0=A0=A0 private Dept dept;</SPAN></FONT></DIV><DIV><FONT =
face=3D"Arial" size=3D"2"><SPAN class=3D"Apple-style-span" style=3D"f=
ont-family: Arial; font-size: 10px; ">=A0=A0=A0 ...</SPAN></FONT></DI=
V><DIV><FONT face=3D"Arial" size=3D"2"><SPAN class=3D"Apple-style-spa=
n" style=3D"font-family: Arial; font-size: 10px; ">}</SPAN></FONT></D=
IV><DIV><FONT face=3D"Arial" size=3D"2"></FONT>=A0</DIV><DIV><FONT fa=
ce=3D"Ar" ial=3D"" size=3D"2"><SPAN class=3D"Apple-style-span" style=
=3D"font-family: Ar; font-size: 10px; ">Then you can use a resultMap =
and assign values to bean properties by doing:</SPAN></FONT></DIV><DI=
V><FONT face=3D"Arial" size=3D"2"></FONT>=A0</DIV><DIV><FONT face=
=3D"Arial" size=3D"2"><SPAN class=3D"Apple-style-span" style=3D"font-=
family: Arial; font-size: 10px; ">&lt;result property=3D"dept.name" c=
olumn=3D"PER_DEPT_NAME"/&gt;</SPAN></FONT></DIV><DIV><FONT face=3D"Ar=
ial" size=3D"2"></FONT>=A0</DIV><DIV><FONT face=3D"Arial" size=3D"2">=
<SPAN class=3D"Apple-style-span" style=3D"font-family: Arial; font-si=
ze: 10px; ">So you'll have:</SPAN></FONT></DIV><DIV><FONT face=3D"Ari=
al" size=3D"2"></FONT>=A0</DIV><DIV><FONT face=3D"Arial" size=3D"2"><=
SPAN class=3D"Apple-style-span" style=3D"font-family: Arial; font-siz=
e: 10px; ">&lt;select id=3D"getPerson" resultMap=3D"personMap"&gt;</S=
PAN></FONT></DIV><DIV><FONT face=3D"Arial" size=3D"2"><SPAN class=
=3D"Apple-style-span" style=3D"font-family: Arial; font-size: 10px; "=
>=A0=A0=A0 ....</SPAN></FONT></DIV><DIV><FONT face=3D"Arial" size=
=3D"2"><SPAN class=3D"Apple-style-span" style=3D"font-family: Arial; =
font-size: 10px; ">&lt;/select&gt;</SPAN></FONT></DIV><DIV><FONT face=
=3D"Arial" size=3D"2"></FONT>=A0</DIV><DIV><FONT face=3D"Arial" size=
=3D"2"><SPAN class=3D"Apple-style-span" style=3D"font-family: Arial; =
font-size: 10px; ">&lt;resultMap id=3D"personMap" class=3D"com.comp.a=
pp.batchProcess.Person"&gt;</SPAN></FONT></DIV><DIV><FONT face=3D"Ari=
al" size=3D"2"><SPAN class=3D"Apple-style-span" style=3D"font-family:=
 Arial; font-size: 10px; ">=A0=A0=A0 &lt;result property=3D"dept.name=
" column=3D"PER_DEPT_NAME"/&gt;</SPAN></FONT></DIV><DIV><FONT face=
=3D"Arial" size=3D"2"><SPAN class=3D"Apple-style-span" style=3D"font-=
family: Arial; font-size: 10px; ">=A0=A0=A0 ......</SPAN></FONT></DIV=
><DIV><FONT face=3D"Arial" size=3D"2"><SPAN class=3D"Apple-style-span=
" style=3D"font-family: Arial; font-size: 10px; ">&lt;/resultMap&gt;<=
/SPAN></FONT></DIV><DIV><FONT face=3D"Arial" size=3D"2"></FONT>=A0</D=
IV><DIV><FONT face=3D"Arial" size=3D"2"><SPAN class=3D"Apple-style-sp=
an" style=3D"font-family: Arial; font-size: 10px; ">Zarar</SPAN></FON=
T></DIV><DIV><FONT face=3D"Arial" size=3D"2"></FONT>=A0</DIV><BLOCKQU=
OTE style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px;=
 BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px"><DIV style=3D"FON=
T: 10pt arial; font-family: arial; font-size: 13.3333px; "><SPAN clas=
s=3D"Apple-style-span" style=3D"font-family: arial; font-size: 13.333=
3px; ">----- Original Message -----</SPAN></DIV><DIV style=3D"BACKGRO=
UND: #e4e4e4; FONT: 10pt arial; font-color: black; font-family: arial=
; font-size: 13.3333px; "><B style=3D"font-family: arial; font-size: =
13.3333px; font-weight: bold; "><SPAN class=3D"Apple-style-span" styl=
e=3D"font-family: arial; font-size: 13.3333px; font-weight: bold; ">F=
rom:</SPAN></B><SPAN class=3D"Apple-style-span" style=3D"font-family:=
 arial; font-size: 13.3333px; "> </SPAN><A title=3D"radharukmani@yaho=
o.com" href=3D"mailto:radharukmani@yahoo.com"><SPAN class=3D"Apple-st=
yle-span" style=3D"color: rgb(0, 0, 238); font-family: arial; font-si=
ze: 13.3333px; -khtml-text-decorations-in-effect: underline; ">radha =
rukmani</SPAN></A><SPAN class=3D"Apple-style-span" style=3D"font-fami=
ly: arial; font-size: 13.3333px; "></SPAN></DIV><DIV style=3D"FONT: 1=
0pt arial; font-family: arial; font-size: 13.3333px; "><B style=3D"fo=
nt-family: arial; font-size: 13.3333px; font-weight: bold; "><SPAN cl=
ass=3D"Apple-style-span" style=3D"font-family: arial; font-size: 13.3=
333px; font-weight: bold; ">To:</SPAN></B><SPAN class=3D"Apple-style-=
span" style=3D"font-family: arial; font-size: 13.3333px; "> </SPAN><A=
 title=3D"user-java@ibatis.apache.org" href=3D"mailto:user-java@ibati=
s.apache.org"><SPAN class=3D"Apple-style-span" style=3D"color: rgb(0,=
 0, 238); font-family: arial; font-size: 13.3333px; -khtml-text-decor=
ations-in-effect: underline; ">user-java@ibatis.apache.org</SPAN></A>=
<SPAN class=3D"Apple-style-span" style=3D"font-family: arial; font-si=
ze: 13.3333px; "></SPAN></DIV><DIV style=3D"FONT: 10pt arial; font-fa=
mily: arial; font-size: 13.3333px; "><B style=3D"font-family: arial; =
font-size: 13.3333px; font-weight: bold; "><SPAN class=3D"Apple-style=
-span" style=3D"font-family: arial; font-size: 13.3333px; font-weight=
: bold; ">Sent:</SPAN></B><SPAN class=3D"Apple-style-span" style=3D"f=
ont-family: arial; font-size: 13.3333px; "> Wednesday, January 04, 20=
06 5:44 PM</SPAN></DIV><DIV style=3D"FONT: 10pt arial; font-family: a=
rial; font-size: 13.3333px; "><B style=3D"font-family: arial; font-si=
ze: 13.3333px; font-weight: bold; "><SPAN class=3D"Apple-style-span" =
style=3D"font-family: arial; font-size: 13.3333px; font-weight: bold;=
 ">Subject:</SPAN></B><SPAN class=3D"Apple-style-span" style=3D"font-=
family: arial; font-size: 13.3333px; "> sql joins in ibatis</SPAN></D=
IV><DIV><FONT face=3D"Arial" size=3D"2"></FONT><FONT face=3D"Arial" s=
ize=3D"2"></FONT><BR></DIV><DIV id=3D"RTEContent">Hi<SPAN class=3D"Ap=
ple-converted-space">=A0</SPAN><BR>I am new to iBATIS. I was able to =
run the person example in the ibatis website.<SPAN class=3D"Apple-con=
verted-space">=A0</SPAN><BR>For one table, the example says,<BR>&lt;s=
elect id=3D"getPerson" resultClass=3D"com.comp.app.batchProcess.Perso=
n"&gt;<BR>=A0=A0=A0=A0=A0=A0=A0=A0=A0 SELECT<SPAN class=3D"Apple-conv=
erted-space">=A0</SPAN><BR>=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0 PER_ID as id,<BR>=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 PER_F=
IRST_NAME as firstName,<BR>=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0 PER_LAST_NAME as lastName,<BR>=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0 PER_BIRTH_DATE as birthDate,<BR>=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0=A0 PER_WEIGHT_KG as weightInKilograms,<BR>=A0=A0=A0=
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 PER_HEIGHT_M as heightInMeters<BR>=
=A0=A0=A0=A0=A0=A0=A0=A0=A0 FROM PERSON<BR>=A0=A0=A0=A0=A0=A0=A0=A0=
=A0 WHERE PER_ID=3D#value#<BR>=A0=A0=A0=A0 &lt;/select&gt;<BR>but if =
i want details from two tables, say person and dept table. I have two=
 bean classes person.java and dept.java<BR>and if i want to select li=
ke,<BR>select per_id as id, per_first_name as firstname, dept_name as=
 deptname from person,dept where dept_no =3D 2<BR>now=A0 resultClass=
=3D"com.comp.app.batchProcess.Person" and=A0 "com.comp.app.batchProce=
ss.Dept"<BR>how to get around this. Any help is greatly appreciated.<=
BR>Thanks</DIV><DIV>=A0</DIV><DIV><HR size=3D"1"><A href=3D"http://pa=
.yahoo.com/*http://us.rd.yahoo.com/evt=3D37474/*http://promo.yahoo.co=
m/broadband/"><SPAN class=3D"Apple-style-span" style=3D"color: rgb(0,=
 0, 238); -khtml-text-decorations-in-effect: underline; ">Yahoo! DSL<=
/SPAN></A><SPAN class=3D"Apple-converted-space">=A0</SPAN>Something t=
o write home about. Just $16.99/mo. or less</DIV></BLOCKQUOTE></BLOCK=
QUOTE><DIV><BR></DIV><DIV><BR class=3D"khtml-block-placeholder"></DIV=
><HR size=3D"1">Yahoo! Photos<BR>Ring in the New Year with<SPAN class=
=3D"Apple-converted-space">=A0</SPAN><A href=3D"http://us.rd.yahoo.co=
m/mail_us/taglines/photos/*http://pg.photos.yahoo.com/ph//page?.file=
=3Dcalendar_splash.html&.dir=3D"><SPAN class=3D"Apple-style-span" sty=
le=3D"color: rgb(0, 0, 238); -khtml-text-decorations-in-effect: under=
line; ">Photo Calendars</SPAN></A>. Add photos, events, holidays, wha=
tever.</SPAN></BLOCKQUOTE></DIV><BR></DIV></BODY></HTML>

--Boundary_(ID_Zx0rAYbeQilRhfqFAIiEaQ)--