Return-Path: <Gregg.Bolinger@intrustbank.com>
Mailing-List: contact ibatis-user-java-help@incubator.apache.org; run by ezmlm
Delivered-To: mailing list ibatis-user-java@incubator.apache.org
Received: (qmail 56344 invoked by uid 99); 6 Jan 2005 19:49:29 -0000
X-ASF-Spam-Status: No, hits=0.1 required=10.0
	tests=FORGED_RCVD_HELO
X-Spam-Check-By: apache.org
Received-SPF: pass (hermes.apache.org: local policy)
Received: from mail.intrustbank.com (HELO XCHANGE1.INTRUSTCORP.COM)
 (65.215.131.20)
  by apache.org (qpsmtpd/0.28) with ESMTP; Thu, 06 Jan 2005 11:49:28 -0800
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Subject: Mapping Complex Properties (Load all properties)
X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0
Date: Thu, 6 Jan 2005 13:49:24 -0600
Message-ID: <72EAA13E929BB54FB3CA2FB913281F6A1F3ED4@XCHANGE1.INTRUSTCORP.COM>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: Mapping Complex Properties (Load all properties)
Thread-Index: AcT0KNJ0Y8NexSpjTEiIRpUVNobx+Q==
From: "Bolinger, Gregg D" <Gregg.Bolinger@intrustbank.com>
To: <ibatis-user-java@incubator.apache.org>
X-Virus-Checked: Checked

I have a JavaBean with several properties.  Some of these properties are
other JavaBeans.  Currently with the code I have I can load these
complex properties, however, it is only loading 1 property.  Here is my
file(s)

<resultMap id=3D"get-issue-result"
class=3D"com.intrust.anykey.web.modelbeans.Issue">
        <result property=3D"issueId" column=3D"issue_id"/>
        <result property=3D"dateCreated" column=3D"date_created"
javaType=3D"java.util.Date"/>
        <result property=3D"dateAccepted" column=3D"date_accepted"
javaType=3D"java.util.Date"/>
        <result property=3D"dateResolved" column=3D"date_resolved"
javaType=3D"java.util.Date"/>
        <result property=3D"dateModified" column=3D"date_modified"
javaType=3D"java.util.Date"/>
        <result property=3D"createdByUser.userId"
column=3D"creating_user_id" />
        <result property=3D"issueNumber" column=3D"issue_number"/>
    </resultMap>

    <statement id=3D"getIssue" parameterClass=3D"int"
resultMap=3D"get-issue-result">
        SELECT * FROM t_issue, t_user WHERE creating_user_id =3D user_id
AND issue_id =3D #value#
    </statement>

Now, when I run this and in my java code I want to get the information
about the createdByUser which is of a type User.java.  The only property
in User.java that is being populated in userId.  I need also all the
other properties to be populated.  Now, I understand why only 1 property
is being filled in User.java.  But I don't know how to achieve the
desired functionality I need.

Thanks

Gregg