Return-Path: 
 <user-java-return-15586-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 14378 invoked from network); 17 Nov 2008 15:57:34 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 17 Nov 2008 15:57:34 -0000
Received: (qmail 41552 invoked by uid 500); 17 Nov 2008 15:57:40 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 41310 invoked by uid 500); 17 Nov 2008 15:57:39 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 41299 invoked by uid 500); 17 Nov 2008 15:57:39 -0000
Delivered-To: apmail-incubator-ibatis-user-java@incubator.apache.org
Received: (qmail 41295 invoked by uid 99); 17 Nov 2008 15:57:39 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 17 Nov 2008 07:57:39 -0800
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of rickcr@gmail.com designates
 64.233.182.190 as permitted sender)
Received: from [64.233.182.190] (HELO nf-out-0910.google.com) (64.233.182.190)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 17 Nov 2008 15:56:17 +0000
Received: by nf-out-0910.google.com with SMTP id c7so1460013nfi.40
        for <ibatis-user-java@incubator.apache.org>;
 Mon, 17 Nov 2008 07:56:51 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=gamma;
        h=domainkey-signature:received:received:message-id:date:from:to
         :subject:mime-version:content-type:content-transfer-encoding
         :content-disposition;
        bh=fMXtJHbRA/hS7jkkN5GK+frCtDi+OGHLAMESsBpRREA=;
        b=Vry+BM/HKoXT/+AA12ccwoK73lvWsJMDPsjeyVVPckIw/EpGoYPlYBQkqBc9eox9fd
         tkCo2ws+nIL8UcfNk6wtuStIsgylbdX0uQx0SehV7Ak49INz8IIwYuN0zjWfTOWjhjXQ
         1wEarF71MM2CGNrboo6K4lG6BB2SgMXIuxfH4=
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:mime-version:content-type
         :content-transfer-encoding:content-disposition;
        b=LsE23iqggffXUCZk+UPEWB5Nmjo5Wspg1HFXaVAnxIi/l7okh1/ARWnb99GU3Ve4tK
         4GkQckHhsJ7MMtOUUDd+Kd/kXUyzLLTL30+LlH4HpQFme53uaHcwd8RMJTAbMyVF45p7
         lsGMwfQdAgnH1LvBYrJ+CpiBgO1OE2OMnqViw=
Received: by 10.210.78.16 with SMTP id a16mr4060769ebb.33.1226937411317;
        Mon, 17 Nov 2008 07:56:51 -0800 (PST)
Received: by 10.210.11.19 with HTTP; Mon, 17 Nov 2008 07:56:51 -0800 (PST)
Message-ID: <583d4dff0811170756lf5c2166v2cbe31bedeaa1490@mail.gmail.com>
Date: Mon, 17 Nov 2008 10:56:51 -0500
From: Rick <rickcr@gmail.com>
To: ibatis-user-java@incubator.apache.org
Subject: Am I missing something really simple? Way to avoid adding all props
 in a map if I decide to add one extra collection to pojo
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
X-Virus-Checked: Checked by ClamAV on apache.org

Hopefully I'm just being a newb and missing something simple. It's
been a while since I worked with iBATIS:)...

My column names and pojo names are the same, so typically I don't even
need a result map created to map my properties (I can just map my
resultClass to the query). Where things break down though is if I want
to nest a collection of another object in one of my pojos. For example
in the code below BusinessEntity can have "Associates" so I've added a
List<Associate> field to my BusinessEntity pojo.  What I'd love to do
now is somehow get my BusinessEntity populated and the nested
Associate lists populated *WITHOUT* having to go through and declare
EVERY SINGLE property in a Map (since my fields match up fine to the
columns.) It seems though that I can't do this? Am I missing an easy
way to avoid this? I wish I could do something like:
	
 <!-- populated all properties on the BusinessEntity class if you can!!!! --->
<resultMap id="beMap2" class="BusinessEntity" groupBy="businessEntityID">
       <!-- directly map a *** resultClass !  ***--->
      <result property="associates" resultClass="BusinessEntity.assMap2"/>
</resultMap>

(Is there a work around?)

Instead of the above I'm currently having to do:

 <!-- example poulating the Value Objects -->
<resultMap id="beMap2" class="BusinessEntity" groupBy="businessEntityID">
   <result property="businessEntityID" column="businessEntityID"/>
   <result property="name" column="name"/>

   ...// *** having to map all my other props?

 <result property="addressLine1" column="addressLine1"/>
   <result property="associates" resultMap="BusinessEntity.assMap2"/>
</resultMap>

<resultMap id="assMap2" class="com.nielsen.ondp.persistence.model.Associate">
   <result property="firstName" column="firstName"/>
   <result property="lastName" column="lastName"/>

    ...// *** having to map all my other props?

</resultMap>

the simple query:

<select id="findBEsWithAssociates2" resultMap="beMap2" cacheModel="beCache">
     SELECT be.*, a.*
     FROM NPPBusinessEntity be, NPPAssociate a
     WHERE a.businessEntityID = be.businessEntityID ORDER BY be.businessEntityID
</select>