Return-Path: 
 <user-java-return-7741-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 91936 invoked from network); 3 Jul 2006 22:22:01 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 3 Jul 2006 22:22:01 -0000
Received: (qmail 3376 invoked by uid 500); 3 Jul 2006 22:21:59 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 3356 invoked by uid 500); 3 Jul 2006 22:21:59 -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 3344 invoked by uid 99); 3 Jul 2006 22:21:59 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 03 Jul 2006 15:21:59 -0700
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received-SPF: neutral (asf.osuosl.org: local policy)
Received: from [216.193.202.245] (HELO waseda.lunarpages.com)
 (216.193.202.245)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 03 Jul 2006 15:21:58 -0700
Received: from i-global254.qualcomm.com ([199.106.103.254] helo=RICK2)
	by waseda.lunarpages.com with esmtp (Exim 4.52)
	id 1FxWoG-00051I-Jx; Mon, 03 Jul 2006 15:22:28 -0700
From: "Rick" <ricks_mailinglists@arc-mind.com>
To: <user-java@ibatis.apache.org>,
	<lmeadors@apache.org>
Subject: RE: Employee self-join one to many relationship (iBatis)
Date: Mon, 3 Jul 2006 15:21:35 -0700
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Mailer: Microsoft Office Outlook, Build 11.0.5510
In-Reply-To: <a10a823c0607031518h40c6dbccycb3f1ce6e445a0d7@mail.gmail.com>
Thread-Index: Acae7s1GhFhMljonQuOO8TP3/5rrmwAACW+w
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
X-AntiAbuse: This header was added to track abuse,
 please include it with any abuse report
X-AntiAbuse: Primary Hostname - waseda.lunarpages.com
X-AntiAbuse: Original Domain - ibatis.apache.org
X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12]
X-AntiAbuse: Sender Address Domain - arc-mind.com
X-Source: 
X-Source-Args: 
X-Source-Dir: 
X-Virus-Checked: Checked by ClamAV on apache.org
Message-Id: <20060703222158.E760D10FB016@asf.osuosl.org>
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

Bingo!

Yep. Employee has a directReports list which is a list of Employees.



-----Original Message-----
From: Larry Meadors [mailto:lmeadors@apache.org] 
Sent: Monday, July 03, 2006 3:19 PM
To: user-java@ibatis.apache.org
Subject: Re: Employee self-join one to many relationship (iBatis)

Hey Rick, I am not 100% sure I understand what you are trying to do,
but let me try to restate it and see..

Do you want a list of employees, each one with another list of
employees (direct reports), and a list of contacts on each one - both
the main employee list and the child employees?

Larry


On 7/3/06, Rick <ricks_mailinglists@arc-mind.com> wrote:
>
>
>
>
> I just want to use iBatis in the cleanest way possible. I have a
workaround
> but wonder if iBatis support self-joined one to many relationships.
>
>
>
> Let me explain..
>
>
>
>
>
> I have a query that returns employees.
>
>
>
> Employees have Boss's who are Employees.
>
>
>
> Currently I have Employees have Contacts who have Phone Numbers.
>
>
>
> (Where Employee, Contact and Phone number are objects.)
>
>
>
> I'd like to have Employees have Employees (directReports) and Employees
have
> Contacts who have Phone Numbers.
>
>
>
> Does iBatis support a self join?
>
>
>
>
>
> Here is my current mapping and how I get around this lack of support (or
is
> this support lacking)...
>
>
>
> , i.e.,
>
>
>
>       <resultMap id="employee"
> class="qcom.cas.mysourcej.poc.model.Employee"
> groupBy="emplid">
>
>             <result property="emplid" column="emplid" />
>
>             <result property="name" column="name" />
>
>             <result property="contacts" resultMap="employee.contacts"/>
>
>             <result property="bossId" column="bossId"/>
>
>       </resultMap>
>
>
>
>       <resultMap id="contacts"
> class="qcom.cas.mysourcej.poc.model.Contact">
>
>             <result property="name" column="contact_name"/>
>
>             <result property="primaryContact" column="primary_contact"
>
>
> typeHandler="qcom.cas.commons.ibatis.typehandler.StringBooleanTypeHandler"
> />
>
>             <result property="relationship" column="relation"/>
>
>             <result property="phoneNumber1.number" column="phone1"/>
>
>             <result property="phoneNumber2.number" column="phone2"/>
>
>             <result property="phoneNumber3.number" column="phone3"/>
>
>             <result property="phoneNumber4.number" column="phone4"/>
>
>             <result property="phoneNumber1.areaCode" column="areaCode1"/>
>
>             <result property="phoneNumber2.areaCode" column="areaCode2"/>
>
>             <result property="phoneNumber3.areaCode" column="areaCode3"/>
>
>             <result property="phoneNumber4.areaCode" column="areaCode4"/>
>
>       </resultMap>
>
>
>
>
>
>
>
>       <select
> id="getEmployeeEmergencyContactsUsingDirectSort"
> resultMap="employee">
>
>
>
>
>
> If so, any pointers or references where I can learn to do this..
>
>
>
> Currently I have a method that turns the list of employees into a
hierarchy
> of Employees as follows:
>
>
>
>       /**
>
>        * Turns a list of employees into a hierarchy of employees.
>
>        * @param employees
>
>        * @param removeChild
>
>        */
>
>       private void buildEmployeeObjectHierarchy(List
> employees, boolean removeChild) {
>
>             Map employeeIDMap = new HashMap(employees.size());
>
>
>
>             for (Iterator iter = employees.iterator(); iter.hasNext();) {
>
>                   Employee employee = (Employee) iter.next();
>
>                   employeeIDMap.put(employee.getEmplid(), employee);
>
>             }
>
>
>
>             for (Iterator iter = employees.iterator(); iter.hasNext();) {
>
>                   Employee employee = (Employee) iter.next();
>
>                   Employee boss = (Employee)
> employeeIDMap.get(employee.getBossId());
>
>                   if (boss != null) {
>
>                         boss.addEmployee(employee);
>
>                         iter.remove(); //If a boss is found, remove this
> employee from the list.
>
>                   }
>
>             }
>
>       }
>
>
>
> The above is a bit expensive and I'd like to get it out of my code if
> possible. If not, no worries. I just want to use iBatis in the cleanest
way
> possible.