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 <[EMAIL PROTECTED]> 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.
