Return-Path: 
 <user-java-return-7772-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 22296 invoked from network); 5 Jul 2006 18:06:09 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 5 Jul 2006 18:06:09 -0000
Received: (qmail 86488 invoked by uid 500); 5 Jul 2006 18:06:07 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 86468 invoked by uid 500); 5 Jul 2006 18:06:07 -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 86457 invoked by uid 99); 5 Jul 2006 18:06:07 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 05 Jul 2006 11:06:07 -0700
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=HTML_MESSAGE
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; Wed, 05 Jul 2006 11:06:03 -0700
Received: from i-global254.qualcomm.com ([199.106.103.254] helo=RICK2)
	by waseda.lunarpages.com with esmtp (Exim 4.52)
	id 1FyBlb-0003s6-WC
	for user-java@ibatis.apache.org; Wed, 05 Jul 2006 11:06:31 -0700
From: "Rick" <ricks_mailinglists@arc-mind.com>
To: <user-java@ibatis.apache.org>
Subject: RE: One solution to self-join,
 new feature request.... RE: Employee self-join one to many relationship
 (iBatis)
Date: Wed, 5 Jul 2006 11:05:30 -0700
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_008A_01C6A022.F0A47600"
X-Mailer: Microsoft Office Outlook, Build 11.0.5510
In-Reply-To: <c593b8750607050954j4ef33793mc8b3745bfaef3d5e@mail.gmail.com>
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
Thread-Index: AcagU9thYH0a9AzaRk+maGikAmDFNQABH3qA
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 - [0 0] / [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: <20060705180605.BAD7A10FB000@asf.osuosl.org>
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

This is a multi-part message in MIME format.

------=_NextPart_000_008A_01C6A022.F0A47600
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

I see. Hmmm. This is makes sense. 

 

 

My query is a "connect by" that gets all employees. All employees have a
boss, but not all employees have directReports. Will this still work? I
tried it as follows:

 

 

      <resultMap id="boss" class="qcom.cas.mysourcej.poc.model.Employee"
groupBy="emplid">

            <result property="emplid" column="emplid" />

            <result property="name" column="name" />

            <result property="bossId" column="bossId"/>

            <result property="employees"
resultMap="employee.employeeShort"/>

      </resultMap>

 

      <resultMap id="employeeShort"
class="qcom.cas.mysourcej.poc.model.Employee">

            <result property="emplid" column="emplid" />

            <result property="name" column="name" />

            <result property="bossId" column="bossId"/>

      </resultMap>

 

      <select id="getMyOrg" resultMap="employeeShort">

                  <![CDATA[

                        select

                              employee.emplid as emplid,

                              employee.name as name,

                              employee.N_SUPERVISOR as bossId,

                              boss.name as bossName

                        from

                              ps_employees employee

                        join ps_employees boss

                    on employee.N_SUPERVISOR = boss.emplid

                      start with

                        employee.emplid = #supervisorId#

                      connect by

                        employee.n_supervisor = prior employee.emplid

                        order by

                              level, name;

                 !]]>

      </select>

 

The query is a rollup query that builds a tree. For some reason, I can't get
the above query to run at all. It runs inside of SQL Navigator as follows:

 

 

                        select

                              employee.emplid as emplid,

                              employee.name as name,

                              employee.N_SUPERVISOR as bossId,

                              boss.name as bossName

                        from

                              ps_employees employee

                        join ps_employees boss

                    on employee.N_SUPERVISOR = boss.emplid

                      start with

                        employee.emplid = '12345'

                      connect by

                        employee.n_supervisor = prior employee.emplid

                        order by

                              level, name

 

 

Which results in:

 

12345               Tom Bridizzle                                        001
George Bush

30                     Brad Bojangles
12345               Tom Bridizzle

1                      David Efurdstein
12345               Tom Bridizzle

2                      Rick Hightower                                      1
David Efurdstein

3                      Scott Fauerbach                                   1
David Efurdstein

 

 

When I run it inside of iBatis I get:

 

(I tried with and without the ;)

org.springframework.jdbc.BadSqlGrammarException: SqlMapClient operation; bad
SQL grammar []; nested exception is
com.ibatis.common.jdbc.exception.NestedSQLException:   

--- The error occurred in qcom/cas/mysourcej/poc/dao/Employee.xml.  

--- The error occurred while applying a parameter map.  

--- Check the getMyOrg-InlineParameterMap.  

--- Check the statement (query failed).  

--- Cause: java.sql.SQLException: ORA-00911: invalid character

 

Caused by: java.sql.SQLException: ORA-00911: invalid character

 

Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:   

--- The error occurred in qcom/cas/mysourcej/poc/dao/Employee.xml.  

--- The error occurred while applying a parameter map.  

--- Check the getMyOrg-InlineParameterMap.  

--- Check the statement (query failed).  

--- Cause: java.sql.SQLException: ORA-00911: invalid character

 

Caused by: java.sql.SQLException: ORA-00911: invalid character

 

            at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWith
Callback(GeneralStatement.java:185)

            at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForL
ist(GeneralStatement.java:123)

            at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExec
utorDelegate.java:610)

            at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExec
utorDelegate.java:584)

            at
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionIm
pl.java:101)

            at
org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMa
pClientTemplate.java:228)

            at
org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemp
late.java:165)

            at
org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResult(Sq
lMapClientTemplate.java:187)

            at
org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClien
tTemplate.java:226)

            at
qcom.cas.commons.dao.dataproducer.IBatisQueryDataProducer.executeNameParamsQ
uery(IBatisQueryDataProducer.java:75)

            at
qcom.cas.commons.dao.dataproducer.IBatisQueryDataProducer.list(IBatisQueryDa
taProducer.java:66)

            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

            at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)

            at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)

            at java.lang.reflect.Method.invoke(Method.java:324)

            at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopU
tils.java:266)

            at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint
(ReflectiveMethodInvocation.java:181)

            at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Reflect
iveMethodInvocation.java:148)

            at
org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(
DelegatingIntroductionInterceptor.java:124)

            at
org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(Del
egatingIntroductionInterceptor.java:112)

            at
qcom.cas.commons.faces.dataproducer.GetSelectItemsIntroduction.invoke(GetSel
ectItemsIntroduction.java:69)

            at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Reflect
iveMethodInvocation.java:170)

            at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopPro
xy.java:176)

            at $Proxy0.list(Unknown Source)

            at
qcom.cas.mysourcej.poc.backingbean.EmergencyContactBackingBean.myOrgClicked(
EmergencyContactBackingBean.java:93)

            at
qcom.cas.mysourcej.poc.backingbean.EmergencyContactBackingBeanTest.testShowM
yOrgTree(EmergencyContactBackingBeanTest.java:142)

            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

            at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)

            at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)

            at java.lang.reflect.Method.invoke(Method.java:324)

            at junit.framework.TestCase.runTest(TestCase.java:154)

            at junit.framework.TestCase.runBare(TestCase.java:127)

            at junit.framework.TestResult$1.protect(TestResult.java:106)

            at junit.framework.TestResult.runProtected(TestResult.java:124)

            at junit.framework.TestResult.run(TestResult.java:109)

            at junit.framework.TestCase.run(TestCase.java:118)

            at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRu
nner.java:478)

            at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.
java:344)

            at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner
.java:196)

Caused by: java.sql.SQLException: ORA-00911: invalid character

 

            at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)

            at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)

            at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287)

            at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:742)

            at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:21
2)

            at
oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatem
ent.java:795)

            at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java
:1030)

            at
oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStat
ement.java:835)

            at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
:1123)

            at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedSta
tement.java:3284)

            at
oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.j
ava:3389)

            at
org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPrepar
edStatement.java:168)

            at
com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java
:180)

            at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(
GeneralStatement.java:205)

            at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWith
Callback(GeneralStatement.java:173)

            ... 38 more

 

Caused by: 

java.sql.SQLException: ORA-00911: invalid character

 

            at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)

            at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)

            at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287)

            at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:742)

            at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:21
2)

            at
oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatem
ent.java:795)

            at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java
:1030)

            at
oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStat
ement.java:835)

            at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
:1123)

            at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedSta
tement.java:3284)

            at
oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.j
ava:3389)

            at
org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPrepar
edStatement.java:168)

            at
com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java
:180)

            at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(
GeneralStatement.java:205)

            at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWith
Callback(GeneralStatement.java:173)

            at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForL
ist(GeneralStatement.java:123)

            at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExec
utorDelegate.java:610)

            at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExec
utorDelegate.java:584)

            at
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionIm
pl.java:101)

            at
org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMa
pClientTemplate.java:228)

            at
org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemp
late.java:165)

            at
org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResult(Sq
lMapClientTemplate.java:187)

            at
org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClien
tTemplate.java:226)

            at
qcom.cas.commons.dao.dataproducer.IBatisQueryDataProducer.executeNameParamsQ
uery(IBatisQueryDataProducer.java:75)

            at
qcom.cas.commons.dao.dataproducer.IBatisQueryDataProducer.list(IBatisQueryDa
taProducer.java:66)

            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

            at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)

            at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)

            at java.lang.reflect.Method.invoke(Method.java:324)

            at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopU
tils.java:266)

            at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint
(ReflectiveMethodInvocation.java:181)

            at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Reflect
iveMethodInvocation.java:148)

            at
org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(
DelegatingIntroductionInterceptor.java:124)

            at
org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(Del
egatingIntroductionInterceptor.java:112)

            at
qcom.cas.commons.faces.dataproducer.GetSelectItemsIntroduction.invoke(GetSel
ectItemsIntroduction.java:69)

            at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Reflect
iveMethodInvocation.java:170)

            at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopPro
xy.java:176)

            at $Proxy0.list(Unknown Source)

            at
qcom.cas.mysourcej.poc.backingbean.EmergencyContactBackingBean.myOrgClicked(
EmergencyContactBackingBean.java:93)

            at
qcom.cas.mysourcej.poc.backingbean.EmergencyContactBackingBeanTest.testShowM
yOrgTree(EmergencyContactBackingBeanTest.java:142)

            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

            at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39
)

            at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)

            at java.lang.reflect.Method.invoke(Method.java:324)

            at junit.framework.TestCase.runTest(TestCase.java:154)

            at junit.framework.TestCase.runBare(TestCase.java:127)

            at junit.framework.TestResult$1.protect(TestResult.java:106)

            at junit.framework.TestResult.runProtected(TestResult.java:124)

            at junit.framework.TestResult.run(TestResult.java:109)

            at junit.framework.TestCase.run(TestCase.java:118)

            at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRu
nner.java:478)

            at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.
java:344)

            at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner
.java:196)

 

 

  _____  

From: Jeff Butler [mailto:jeffgbutler@gmail.com] 
Sent: Wednesday, July 05, 2006 9:54 AM
To: user-java@ibatis.apache.org
Subject: Re: One solution to self-join, new feature request.... RE: Employee
self-join one to many relationship (iBatis)

 

Hi Rick,

 

A self join can be accomplished through groupBy and column renaming.  Here's
a simple example I just coded up for a test:

 

Table Definition:

 

create table employees(id int not null, bossId int, name varchar(50))

 

Class Definition:

 

public class Employee {

  private Integer id;

  private String name;

  private List employees;

  // getters/setters

}

 

 

iBATIS stuff:

<resultMap id="boss" class="test.Employee" groupBy="id">
  <result property="id" column="bossId" />
  <result property="name" column="bossName" /> 
  <result property="employees" resultMap="employee"/>
</resultMap>

<resultMap id="employee" class="test.Employee">
  <result property="id" column="employeeId" />
  <result property="name" column="employeeName" /> 
</resultMap>

<select id="selectEmployees" resultMap="boss">
  select a.id as employeedId, a.name as employeeName, b.id as bossId, b.name
as bossName
  from employees a join employees b
    on a.bossId = b.id
  where a.bossId is not null
</select>

This returns all the data in one pass, so no N+1 problem.

 

Jeff Butler


 

On 7/5/06, Rick <ricks_mailinglists@arc-mind.com> wrote: 

Someone sent me a solution to the self-join that I asked about earlier as
follows:

       <resultMap id="employee" class=" sample01.Employee">
               <result property="employeeId" column="employee_id"/>
               <result property="bossId" column="boss_id" nullValue="-1" 
select="getBoss"/>
               <result property="firstName" column="first_name"/>
               <result property="lastName" column="last_name"/> 
       </resultMap>
       <statement id="getEmployees" resultMap="employee">
               select * from Employee
       </statement>
       <statement id="getBoss" resultMap="employee"> 
               select * from Employee where employee_id=#value#
       </statement>


This is very helpful in understanding how iBatis works. I think I will stick
with the other approach b/c the code above would perform 1 query for each 
boss (N+1). The approach I used (with the helper method) only hits the db
once. It gets all the data it needs in one swipe and then builds the
hierarchy.


Again, my former approach gets all of the employees in the tree (using 
connect-by) and then constructs the hierarchy.


The above way is much cleaner in that it does not require custom Java code
to build the list. Its runtime performance would be problematic especially
since I am replacing code that does not have an N+1 issue (custom VB/ASP 
app).

I'd like to have something like this (as a new feature in iBatis):

       <resultMap id="employee" class="sample01.Employee">
               <result property="employeeId" column="employee_id"/> 
               <result property="boss" fk_property="bossId"
                   adder-method="addDirectReport" self-join="true"
                   pk_property="emplId"/> 
               <result property="firstName" column="first_name"/>
               <result property="bossId" column="n_supervisor"/>
               <result property="lastName" column="last_name"/> 
       </resultMap>
       <statement id="getEmployees" resultMap="employee">
               select * from Employee e
                   start with n_supervisor = #supervisorId# 
                   connect by n_supervisor = prior emplid
      </statement>


See the:

               <result property="boss" fk_property="bossId"
                   adder-method="addDirectReport" self-join="true" 
                   pk_property="emplId"/>

Basically the data for the hierarchy is already retrieved from the db. Why
hit it a second time?

Thoughts?


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

Hmm, I generally don't build my object model that way, so my
experience with groupBy is sort of limited, sorry. ;-)

If you can't make groupBy work, I'd look at doing this with a
rowhandler. You'd get all the data in one hit to the database, and 
then step through the results building the object graph the way you
want it.

Larry


On 7/3/06, Rick <ricks_mailinglists@arc-mind.com> wrote: 
> Bingo!
>
> Yep. Employee has a directReports list which is a list of Employees.
>
>
>
> -----Original Message-----
> From: Larry Meadors [mailto: <mailto:lmeadors@apache.org>
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.
>
>
>



 


------=_NextPart_000_008A_01C6A022.F0A47600
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
 /* Font Definitions */
 @font-face
	{font-family:Tahoma;
	panose-1:2 11 6 4 3 5 4 4 2 4;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0pt;
	margin-bottom:.0001pt;
	font-size:12.0pt;
	font-family:"Times New Roman";}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{color:blue;
	text-decoration:underline;}
p
	{mso-margin-top-alt:auto;
	margin-right:0pt;
	mso-margin-bottom-alt:auto;
	margin-left:0pt;
	font-size:12.0pt;
	font-family:"Times New Roman";}
span.EmailStyle19
	{mso-style-type:personal-reply;
	font-family:Arial;
	color:navy;}
@page Section1
	{size:612.0pt 792.0pt;
	margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
	{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
 <o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
 <o:shapelayout v:ext=3D"edit">
  <o:idmap v:ext=3D"edit" data=3D"1" />
 </o:shapelayout></xml><![endif]-->
</head>

<body lang=3DEN-US link=3Dblue vlink=3Dblue>

<div class=3DSection1>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>I see. Hmmm&#8230; This is makes =
sense. <o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>My query is a &#8220;connect =
by&#8221;
that gets all employees. All employees have a boss, but not all =
employees have
directReports. Will this still work? I tried it as =
follows:<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black;background:white'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
</span></font><font
size=3D2 color=3Dteal face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:teal;background:white'>&lt;</span></font><font =
size=3D2
color=3D"#3f7f7f" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:#3F7F7F;background:white'>resultMap =
</span></font><font
size=3D2 color=3D"#7f007f" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;
font-family:"Courier =
New";color:#7F007F;background:white'>id</span></font><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:black;background:white'>=3D</span></font><font =
size=3D2
color=3D"#2a00ff" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:#2A00FF;background:white'>&quot;boss&quot; =
</span></font><font
size=3D2 color=3D"#7f007f" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;
font-family:"Courier =
New";color:#7F007F;background:white'>class</span></font><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:black;background:white'>=3D</span></font><font =
size=3D2
color=3D"#2a00ff" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier =
New";color:#2A00FF;background:white'>&quot;qcom.cas.mysourcej.poc.model.E=
mployee&quot;
</span></font><font size=3D2 color=3D"#7f007f" face=3D"Courier =
New"><span
style=3D'font-size:10.0pt;font-family:"Courier =
New";color:#7F007F;background:
white'>groupBy</span></font><font size=3D2 color=3Dblack face=3D"Courier =
New"><span
style=3D'font-size:10.0pt;font-family:"Courier =
New";color:black;background:white'>=3D</span></font><font
size=3D2 color=3D"#2a00ff" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;
font-family:"Courier =
New";color:#2A00FF;background:white'>&quot;emplid&quot;</span></font><fon=
t
size=3D2 color=3Dteal face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:teal;background:white'>&gt;</span></font><font =
size=3D2
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier =
New"'><o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black;background:white'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp; </span></font><font
size=3D2 color=3Dteal face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:teal;background:white'>&lt;</span></font><font =
size=3D2
color=3D"#3f7f7f" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:#3F7F7F;background:white'>result </span></font><font
size=3D2 color=3D"#7f007f" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;
font-family:"Courier =
New";color:#7F007F;background:white'>property</span></font><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:black;background:white'>=3D</span></font><font =
size=3D2
color=3D"#2a00ff" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:#2A00FF;background:white'>&quot;emplid&quot; =
</span></font><font
size=3D2 color=3D"#7f007f" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;
font-family:"Courier =
New";color:#7F007F;background:white'>column</span></font><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:black;background:white'>=3D</span></font><font =
size=3D2
color=3D"#2a00ff" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:#2A00FF;background:white'>&quot;emplid&quot; =
</span></font><font
size=3D2 color=3Dteal face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:teal;background:white'>/&gt;</span></font><font =
size=3D2
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier =
New"'><o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black;background:white'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp; </span></font><font
size=3D2 color=3Dteal face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:teal;background:white'>&lt;</span></font><font =
size=3D2
color=3D"#3f7f7f" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:#3F7F7F;background:white'>result </span></font><font
size=3D2 color=3D"#7f007f" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;
font-family:"Courier =
New";color:#7F007F;background:white'>property</span></font><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:black;background:white'>=3D</span></font><font =
size=3D2
color=3D"#2a00ff" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:#2A00FF;background:white'>&quot;name&quot; =
</span></font><font
size=3D2 color=3D"#7f007f" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;
font-family:"Courier =
New";color:#7F007F;background:white'>column</span></font><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:black;background:white'>=3D</span></font><font =
size=3D2
color=3D"#2a00ff" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:#2A00FF;background:white'>&quot;name&quot; =
</span></font><font
size=3D2 color=3Dteal face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:teal;background:white'>/&gt;</span></font><font =
size=3D2
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier =
New"'><o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black;background:white'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp; </span></font><font
size=3D2 color=3Dteal face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:teal;background:white'>&lt;</span></font><font =
size=3D2
color=3D"#3f7f7f" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:#3F7F7F;background:white'>result </span></font><font
size=3D2 color=3D"#7f007f" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;
font-family:"Courier =
New";color:#7F007F;background:white'>property</span></font><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:black;background:white'>=3D</span></font><font =
size=3D2
color=3D"#2a00ff" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:#2A00FF;background:white'>&quot;bossId&quot; =
</span></font><font
size=3D2 color=3D"#7f007f" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;
font-family:"Courier =
New";color:#7F007F;background:white'>column</span></font><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:black;background:white'>=3D</span></font><font =
size=3D2
color=3D"#2a00ff" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier =
New";color:#2A00FF;background:white'>&quot;bossId&quot;</span></font><fon=
t
size=3D2 color=3Dteal face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:teal;background:white'>/&gt;</span></font><font =
size=3D2
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier =
New"'><o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black;background:white'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp; </span></font><font
size=3D2 color=3Dteal face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:teal;background:white'>&lt;</span></font><font =
size=3D2
color=3D"#3f7f7f" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:#3F7F7F;background:white'>result </span></font><font
size=3D2 color=3D"#7f007f" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;
font-family:"Courier =
New";color:#7F007F;background:white'>property</span></font><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:black;background:white'>=3D</span></font><font =
size=3D2
color=3D"#2a00ff" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:#2A00FF;background:white'>&quot;employees&quot; =
</span></font><font
size=3D2 color=3D"#7f007f" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;
font-family:"Courier =
New";color:#7F007F;background:white'>resultMap</span></font><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:black;background:white'>=3D</span></font><font =
size=3D2
color=3D"#2a00ff" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier =
New";color:#2A00FF;background:white'>&quot;employee.employeeShort&quot;</=
span></font><font
size=3D2 color=3Dteal face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:teal;background:white'>/&gt;</span></font><font =
size=3D2
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier =
New"'><o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black;background:white'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
</span></font><font
size=3D2 color=3Dteal face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:teal;background:white'>&lt;/</span></font><font =
size=3D2
color=3D"#3f7f7f" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier =
New";color:#3F7F7F;background:white'>resultMap</span></font><font
size=3D2 color=3Dteal face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:teal;background:white'>&gt;</span></font><font =
size=3D2
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier =
New"'><o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"Courier New"><span
style=3D'font-size:10.0pt;font-family:"Courier =
New"'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black;background:white'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
</span></font><font
size=3D2 color=3Dteal face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:teal;background:white'>&lt;</span></font><font =
size=3D2
color=3D"#3f7f7f" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:#3F7F7F;background:white'>resultMap =
</span></font><font
size=3D2 color=3D"#7f007f" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;
font-family:"Courier =
New";color:#7F007F;background:white'>id</span></font><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:black;background:white'>=3D</span></font><font =
size=3D2
color=3D"#2a00ff" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:#2A00FF;background:white'>&quot;employeeShort&quot; =
</span></font><font
size=3D2 color=3D"#7f007f" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;
font-family:"Courier =
New";color:#7F007F;background:white'>class</span></font><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:black;background:white'>=3D</span></font><font =
size=3D2
color=3D"#2a00ff" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier =
New";color:#2A00FF;background:white'>&quot;qcom.cas.mysourcej.poc.model.E=
mployee&quot;</span></font><font
size=3D2 color=3Dteal face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:teal;background:white'>&gt;</span></font><font =
size=3D2
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier =
New"'><o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black;background:white'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp; </span></font><font
size=3D2 color=3Dteal face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:teal;background:white'>&lt;</span></font><font =
size=3D2
color=3D"#3f7f7f" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:#3F7F7F;background:white'>result </span></font><font
size=3D2 color=3D"#7f007f" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;
font-family:"Courier =
New";color:#7F007F;background:white'>property</span></font><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:black;background:white'>=3D</span></font><font =
size=3D2
color=3D"#2a00ff" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:#2A00FF;background:white'>&quot;emplid&quot; =
</span></font><font
size=3D2 color=3D"#7f007f" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;
font-family:"Courier =
New";color:#7F007F;background:white'>column</span></font><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:black;background:white'>=3D</span></font><font =
size=3D2
color=3D"#2a00ff" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:#2A00FF;background:white'>&quot;emplid&quot; =
</span></font><font
size=3D2 color=3Dteal face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:teal;background:white'>/&gt;</span></font><font =
size=3D2
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier =
New"'><o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black;background:white'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp; </span></font><font
size=3D2 color=3Dteal face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:teal;background:white'>&lt;</span></font><font =
size=3D2
color=3D"#3f7f7f" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:#3F7F7F;background:white'>result </span></font><font
size=3D2 color=3D"#7f007f" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;
font-family:"Courier =
New";color:#7F007F;background:white'>property</span></font><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:black;background:white'>=3D</span></font><font =
size=3D2
color=3D"#2a00ff" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:#2A00FF;background:white'>&quot;name&quot; =
</span></font><font
size=3D2 color=3D"#7f007f" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;
font-family:"Courier =
New";color:#7F007F;background:white'>column</span></font><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:black;background:white'>=3D</span></font><font =
size=3D2
color=3D"#2a00ff" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:#2A00FF;background:white'>&quot;name&quot; =
</span></font><font
size=3D2 color=3Dteal face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:teal;background:white'>/&gt;</span></font><font =
size=3D2
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier =
New"'><o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black;background:white'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp; </span></font><font
size=3D2 color=3Dteal face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:teal;background:white'>&lt;</span></font><font =
size=3D2
color=3D"#3f7f7f" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:#3F7F7F;background:white'>result </span></font><font
size=3D2 color=3D"#7f007f" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;
font-family:"Courier =
New";color:#7F007F;background:white'>property</span></font><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:black;background:white'>=3D</span></font><font =
size=3D2
color=3D"#2a00ff" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:#2A00FF;background:white'>&quot;bossId&quot; =
</span></font><font
size=3D2 color=3D"#7f007f" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;
font-family:"Courier =
New";color:#7F007F;background:white'>column</span></font><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:black;background:white'>=3D</span></font><font =
size=3D2
color=3D"#2a00ff" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier =
New";color:#2A00FF;background:white'>&quot;bossId&quot;</span></font><fon=
t
size=3D2 color=3Dteal face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:teal;background:white'>/&gt;</span></font><font =
size=3D2
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier =
New"'><o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black;background:white'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
</span></font><font
size=3D2 color=3Dteal face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:teal;background:white'>&lt;/</span></font><font =
size=3D2
color=3D"#3f7f7f" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier =
New";color:#3F7F7F;background:white'>resultMap</span></font><font
size=3D2 color=3Dteal face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:teal;background:white'>&gt;</span></font><font =
size=3D2
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier =
New"'><o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black;background:white'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
</span></font><font
size=3D2 color=3Dteal face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:teal;background:white'>&lt;</span></font><font =
size=3D2
color=3D"#3f7f7f" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:#3F7F7F;background:white'>select </span></font><font
size=3D2 color=3D"#7f007f" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;
font-family:"Courier =
New";color:#7F007F;background:white'>id</span></font><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:black;background:white'>=3D</span></font><font =
size=3D2
color=3D"#2a00ff" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:#2A00FF;background:white'>&quot;getMyOrg&quot; =
</span></font><font
size=3D2 color=3D"#7f007f" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;
font-family:"Courier =
New";color:#7F007F;background:white'>resultMap</span></font><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:black;background:white'>=3D</span></font><font =
size=3D2
color=3D"#2a00ff" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier =
New";color:#2A00FF;background:white'>&quot;employeeShort&quot;</span></fo=
nt><font
size=3D2 color=3Dteal face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:teal;background:white'>&gt;</span></font><font =
size=3D2
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier =
New"'><o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black;background:white'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
</span></font><font
size=3D2 color=3Dteal face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier =
New";color:teal;background:white'>&lt;![CDATA[</span></font><font
size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier =
New"'><o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black;background:white'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp; select</span></font><font
size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier =
New"'><o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black;background:white'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
employee.emplid
as emplid,</span></font><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt;font-family:"Courier New"'><o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black;background:white'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; employee.name
as name,</span></font><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt;font-family:"Courier New"'><o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black;background:white'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
employee.N_SUPERVISOR
as bossId,</span></font><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt;font-family:"Courier New"'><o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black;background:white'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; boss.name =
as
bossName</span></font><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt;font-family:"Courier New"'><o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black;background:white'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp; from</span></font><font
size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier =
New"'><o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black;background:white'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ps_employees
employee</span></font><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt;font-family:"Courier New"'><o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black;background:white'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp; join
ps_employees boss</span></font><font size=3D2 face=3D"Courier New"><span
style=3D'font-size:10.0pt;font-family:"Courier =
New"'><o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black;background:white'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
on employee.N_SUPERVISOR =3D boss.emplid</span></font><font size=3D2
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier =
New"'><o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black;background:white'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;
start with</span></font><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt;font-family:"Courier New"'><o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black;background:white'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;
&nbsp; employee.emplid =3D #supervisorId#</span></font><font size=3D2
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier =
New"'><o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black;background:white'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;
connect by</span></font><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt;font-family:"Courier New"'><o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black;background:white'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;
&nbsp; employee.n_supervisor =3D prior =
employee.emplid</span></font><font size=3D2
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier =
New"'><o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black;background:white'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp; order
by</span></font><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;
font-family:"Courier New"'><o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black;background:white'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; level,
name;</span></font><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;
font-family:"Courier New"'><o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black;background:white'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;
!</span></font><font size=3D2 color=3Dteal face=3D"Courier New"><span
style=3D'font-size:10.0pt;font-family:"Courier =
New";color:teal;background:white'>]]&gt;</span></font><font
size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier =
New"'><o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black;background:white'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
</span></font><font
size=3D2 color=3Dteal face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:teal;background:white'>&lt;/</span></font><font =
size=3D2
color=3D"#3f7f7f" face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:#3F7F7F;background:white'>select</span></font><font =
size=3D2
color=3Dteal face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:teal;background:white'>&gt;</span></font><font size=3D2 =
face=3D"Courier New"><span
style=3D'font-size:10.0pt;font-family:"Courier =
New"'><o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>The query is a rollup query that =
builds a
tree. For some reason, I can&#8217;t get the above query to run at all. =
It runs
inside of SQL Navigator as follows:<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"Courier New"><span
style=3D'font-size:10.0pt;font-family:"Courier =
New"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
<b><font
color=3Dblue><span =
style=3D'color:blue;font-weight:bold'>select<o:p></o:p></span></font></b>=
</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; employee</span></font><font
size=3D2 color=3Dred face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:red'>.</span></font><font size=3D2 color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black'>emplid </span></font><b><font size=3D2 color=3Dblue =
face=3D"Courier New"><span
style=3D'font-size:10.0pt;font-family:"Courier =
New";color:blue;font-weight:bold'>as
</span></font></b><font size=3D2 color=3Dblack face=3D"Courier =
New"><span
style=3D'font-size:10.0pt;font-family:"Courier =
New";color:black'>emplid</span></font><font
size=3D2 color=3Dred face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:red'>,<o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; employee</span></font><font
size=3D2 color=3Dred face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:red'>.</span></font><b><font size=3D2 color=3Dblue
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:blue;font-weight:bold'>name as name</span></font></b><font =
size=3D2
color=3Dred face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:red'>,<o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
employee</span></font><font
size=3D2 color=3Dred face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:red'>.</span></font><font size=3D2 color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black'>N_SUPERVISOR </span></font><b><font size=3D2 color=3Dblue
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:blue;font-weight:bold'>as </span></font></b><font size=3D2 =
color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black'>bossId</span></font><font size=3D2 color=3Dred =
face=3D"Courier New"><span
style=3D'font-size:10.0pt;font-family:"Courier =
New";color:red'>,<o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
boss</span></font><font
size=3D2 color=3Dred face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:red'>.</span></font><b><font size=3D2 color=3Dblue
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:blue;font-weight:bold'>name as </span></font></b><font size=3D2
color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black'>bossName<o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp; </span></font><b><font
size=3D2 color=3Dblue face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier =
New";color:blue;font-weight:bold'>from<o:p></o:p></span></font></b></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ps_employees
employee<o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp; </span></font><b><font
size=3D2 color=3Dblue face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:blue;font-weight:bold'>join </span></font></b><font =
size=3D2
color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black'>ps_employees boss<o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></font><b><font size=3D2 color=3Dblue face=3D"Courier New"><span
style=3D'font-size:10.0pt;font-family:"Courier =
New";color:blue;font-weight:bold'>on
</span></font></b><font size=3D2 color=3Dblack face=3D"Courier =
New"><span
style=3D'font-size:10.0pt;font-family:"Courier =
New";color:black'>employee</span></font><font
size=3D2 color=3Dred face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:red'>.</span></font><font size=3D2 color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black'>N_SUPERVISOR </span></font><font size=3D2 color=3Dred
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:red'>=3D </span></font><font size=3D2 color=3Dblack =
face=3D"Courier New"><span
style=3D'font-size:10.0pt;font-family:"Courier =
New";color:black'>boss</span></font><font
size=3D2 color=3Dred face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:red'>.</span></font><font size=3D2 color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black'>emplid<o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;
</span></font><b><font size=3D2 color=3Dblue face=3D"Courier New"><span
style=3D'font-size:10.0pt;font-family:"Courier =
New";color:blue;font-weight:bold'>start
with<o:p></o:p></span></font></b></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;
&nbsp; employee</span></font><font size=3D2 color=3Dred face=3D"Courier =
New"><span
style=3D'font-size:10.0pt;font-family:"Courier =
New";color:red'>.</span></font><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:black'>emplid </span></font><font size=3D2 =
color=3Dred
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:red'>=3D </span></font><font size=3D2 color=3Dteal face=3D"Courier =
New"><span
style=3D'font-size:10.0pt;font-family:"Courier =
New";color:teal'>'12345'<o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;
</span></font><b><font size=3D2 color=3Dblue face=3D"Courier New"><span
style=3D'font-size:10.0pt;font-family:"Courier =
New";color:blue;font-weight:bold'>connect
by<o:p></o:p></span></font></b></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;
&nbsp; employee</span></font><font size=3D2 color=3Dred face=3D"Courier =
New"><span
style=3D'font-size:10.0pt;font-family:"Courier =
New";color:red'>.</span></font><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:black'>n_supervisor </span></font><font size=3D2 =
color=3Dred
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:red'>=3D </span></font><b><font size=3D2 color=3Dblue =
face=3D"Courier New"><span
style=3D'font-size:10.0pt;font-family:"Courier =
New";color:blue;font-weight:bold'>prior
</span></font></b><font size=3D2 color=3Dblack face=3D"Courier =
New"><span
style=3D'font-size:10.0pt;font-family:"Courier =
New";color:black'>employee</span></font><font
size=3D2 color=3Dred face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:red'>.</span></font><font size=3D2 color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black'>emplid<o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp; </span></font><b><font
size=3D2 color=3Dblue face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:blue;font-weight:bold'>order =
by<o:p></o:p></span></font></b></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></font><b><font
size=3D2 color=3Dblue face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:blue;font-weight:bold'>level</span></font></b><font =
size=3D2
color=3Dred face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:red'>, </span></font><b><font size=3D2 color=3Dblue =
face=3D"Courier New"><span
style=3D'font-size:10.0pt;font-family:"Courier =
New";color:blue;font-weight:bold'>name<o:p></o:p></span></font></b></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><b><font size=3D2 =
color=3Dblue
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:blue;font-weight:bold'><o:p>&nbsp;</o:p></span></font></b></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Which results =
in:<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>12345&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Tom
Bridizzle&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;
&nbsp;&nbsp; 001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; George
Bush<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>30&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Brad
Bojangles&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=

 12345&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Tom
Bridizzle<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; David
Efurdstein&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 12345&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Tom
Bridizzle<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Rick
Hightower&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=

&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; David
Efurdstein<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Scott
Fauerbach&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; David
Efurdstein<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>When I run it inside of iBatis I =
get:<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>(I tried with and without the =
;)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>org.springframework.jdbc.BadSqlGramm=
arException:
SqlMapClient operation; bad SQL grammar []; nested exception is
com.ibatis.common.jdbc.exception.NestedSQLException:&nbsp;&nbsp; =
<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>--- The error occurred in
qcom/cas/mysourcej/poc/dao/Employee.xml.&nbsp; =
<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>--- The error occurred while =
applying a
parameter map.&nbsp; <o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>--- Check the
getMyOrg-InlineParameterMap.&nbsp; <o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>--- Check the statement (query
failed).&nbsp; <o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>--- Cause: java.sql.SQLException:
ORA-00911: invalid character<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Caused by: java.sql.SQLException:
ORA-00911: invalid character<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Caused by:
com.ibatis.common.jdbc.exception.NestedSQLException:&nbsp;&nbsp; =
<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>--- The error occurred in
qcom/cas/mysourcej/poc/dao/Employee.xml.&nbsp; =
<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>--- The error occurred while =
applying a
parameter map.&nbsp; <o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>--- Check the
getMyOrg-InlineParameterMap.&nbsp; <o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>--- Check the statement (query
failed).&nbsp; <o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>--- Cause: java.sql.SQLException:
ORA-00911: invalid character<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Caused by: java.sql.SQLException:
ORA-00911: invalid character<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryW=
ithCallback(GeneralStatement.java:185)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryF=
orList(GeneralStatement.java:123)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapE=
xecutorDelegate.java:610)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapE=
xecutorDelegate.java:584)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessio=
nImpl.java:101)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(Sq=
lMapClientTemplate.java:228)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientT=
emplate.java:165)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResult=
(SqlMapClientTemplate.java:187)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapCl=
ientTemplate.java:226)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
qcom.cas.commons.dao.dataproducer.IBatisQueryDataProducer.executeNamePara=
msQuery(IBatisQueryDataProducer.java:75)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
qcom.cas.commons.dao.dataproducer.IBatisQueryDataProducer.list(IBatisQuer=
yDataProducer.java:66)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native =
Method)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java=
:39)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI=
mpl.java:25)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
java.lang.reflect.Method.invoke(Method.java:324)<o:p></o:p></span></font>=
</p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(A=
opUtils.java:266)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpo=
int(ReflectiveMethodInvocation.java:181)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Refl=
ectiveMethodInvocation.java:148)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
org.springframework.aop.support.DelegatingIntroductionInterceptor.doProce=
ed(DelegatingIntroductionInterceptor.java:124)<o:p></o:p></span></font></=
p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(=
DelegatingIntroductionInterceptor.java:112)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
qcom.cas.commons.faces.dataproducer.GetSelectItemsIntroduction.invoke(Get=
SelectItemsIntroduction.java:69)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Refl=
ectiveMethodInvocation.java:170)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAop=
Proxy.java:176)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
$Proxy0.list(Unknown Source)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
qcom.cas.mysourcej.poc.backingbean.EmergencyContactBackingBean.myOrgClick=
ed(EmergencyContactBackingBean.java:93)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
qcom.cas.mysourcej.poc.backingbean.EmergencyContactBackingBeanTest.testSh=
owMyOrgTree(EmergencyContactBackingBeanTest.java:142)<o:p></o:p></span></=
font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native =
Method)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java=
:39)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI=
mpl.java:25)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
java.lang.reflect.Method.invoke(Method.java:324)<o:p></o:p></span></font>=
</p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
junit.framework.TestCase.runTest(TestCase.java:154)<o:p></o:p></span></fo=
nt></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
junit.framework.TestCase.runBare(TestCase.java:127)<o:p></o:p></span></fo=
nt></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
junit.framework.TestResult$1.protect(TestResult.java:106)<o:p></o:p></spa=
n></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
junit.framework.TestResult.runProtected(TestResult.java:124)<o:p></o:p></=
span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
junit.framework.TestResult.run(TestResult.java:109)<o:p></o:p></span></fo=
nt></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
junit.framework.TestCase.run(TestCase.java:118)<o:p></o:p></span></font><=
/p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTes=
tRunner.java:478)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunn=
er.java:344)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRun=
ner.java:196)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Caused by: java.sql.SQLException:
ORA-00911: invalid character<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111=
)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)<o:p></o:p><=
/span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287)<o:p></o:p><=
/span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:742)<o:p></o:p></span><=
/font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java=
:212)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedSta=
tement.java:795)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.j=
ava:1030)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedS=
tatement.java:835)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.j=
ava:1123)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrepared=
Statement.java:3284)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatemen=
t.java:3389)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPre=
paredStatement.java:168)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.j=
ava:180)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQue=
ry(GeneralStatement.java:205)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryW=
ithCallback(GeneralStatement.java:173)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ...
38 more<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Caused by: =
<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>java.sql.SQLException: ORA-00911: =
invalid
character<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111=
)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)<o:p></o:p><=
/span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287)<o:p></o:p><=
/span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:742)<o:p></o:p></span><=
/font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java=
:212)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedSta=
tement.java:795)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.j=
ava:1030)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedS=
tatement.java:835)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.j=
ava:1123)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrepared=
Statement.java:3284)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatemen=
t.java:3389)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPre=
paredStatement.java:168)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.j=
ava:180)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQue=
ry(GeneralStatement.java:205)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryW=
ithCallback(GeneralStatement.java:173)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryF=
orList(GeneralStatement.java:123)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapE=
xecutorDelegate.java:610)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapE=
xecutorDelegate.java:584)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessio=
nImpl.java:101)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(Sq=
lMapClientTemplate.java:228)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientT=
emplate.java:165)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResult=
(SqlMapClientTemplate.java:187)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapCl=
ientTemplate.java:226)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
qcom.cas.commons.dao.dataproducer.IBatisQueryDataProducer.executeNamePara=
msQuery(IBatisQueryDataProducer.java:75)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
qcom.cas.commons.dao.dataproducer.IBatisQueryDataProducer.list(IBatisQuer=
yDataProducer.java:66)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native =
Method)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java=
:39)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI=
mpl.java:25)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
java.lang.reflect.Method.invoke(Method.java:324)<o:p></o:p></span></font>=
</p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(A=
opUtils.java:266)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpo=
int(ReflectiveMethodInvocation.java:181)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Refl=
ectiveMethodInvocation.java:148)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
org.springframework.aop.support.DelegatingIntroductionInterceptor.doProce=
ed(DelegatingIntroductionInterceptor.java:124)<o:p></o:p></span></font></=
p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(=
DelegatingIntroductionInterceptor.java:112)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
qcom.cas.commons.faces.dataproducer.GetSelectItemsIntroduction.invoke(Get=
SelectItemsIntroduction.java:69)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Refl=
ectiveMethodInvocation.java:170)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAop=
Proxy.java:176)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
$Proxy0.list(Unknown Source)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
qcom.cas.mysourcej.poc.backingbean.EmergencyContactBackingBean.myOrgClick=
ed(EmergencyContactBackingBean.java:93)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
qcom.cas.mysourcej.poc.backingbean.EmergencyContactBackingBeanTest.testSh=
owMyOrgTree(EmergencyContactBackingBeanTest.java:142)<o:p></o:p></span></=
font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native =
Method)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java=
:39)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI=
mpl.java:25)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
java.lang.reflect.Method.invoke(Method.java:324)<o:p></o:p></span></font>=
</p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
junit.framework.TestCase.runTest(TestCase.java:154)<o:p></o:p></span></fo=
nt></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
junit.framework.TestCase.runBare(TestCase.java:127)<o:p></o:p></span></fo=
nt></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
junit.framework.TestResult$1.protect(TestResult.java:106)<o:p></o:p></spa=
n></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
junit.framework.TestResult.runProtected(TestResult.java:124)<o:p></o:p></=
span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
junit.framework.TestResult.run(TestResult.java:109)<o:p></o:p></span></fo=
nt></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
junit.framework.TestCase.run(TestCase.java:118)<o:p></o:p></span></font><=
/p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTes=
tRunner.java:478)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunn=
er.java:344)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRun=
ner.java:196)<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'><o:p>&nbsp;</o:p></span></font></p>

<div class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><font =
size=3D3
face=3D"Times New Roman"><span style=3D'font-size:12.0pt'>

<hr size=3D2 width=3D"100%" align=3Dcenter tabindex=3D-1>

</span></font></div>

<p class=3DMsoNormal><b><font size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font =
size=3D2
face=3DTahoma><span style=3D'font-size:10.0pt;font-family:Tahoma'> Jeff =
Butler
[mailto:jeffgbutler@gmail.com] <br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> Wednesday, July 05, =
2006
9:54 AM<br>
<b><span style=3D'font-weight:bold'>To:</span></b> =
user-java@ibatis.apache.org<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> Re: One solution =
to
self-join, new feature request.... RE: Employee self-join one to many
relationship (iBatis)</span></font><o:p></o:p></p>

</div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'><o:p>&nbsp;</o:p></span></font></p>

<div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>Hi Rick,<o:p></o:p></span></font></p>

</div>

<div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>&nbsp;<o:p></o:p></span></font></p>

</div>

<div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>A self join can be accomplished through groupBy and column
renaming.&nbsp; Here's a simple example I just coded up for a =
test:<o:p></o:p></span></font></p>

</div>

<div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>&nbsp;<o:p></o:p></span></font></p>

</div>

<div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>Table Definition:<o:p></o:p></span></font></p>

</div>

<div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>&nbsp;<o:p></o:p></span></font></p>

</div>

<div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>create table employees(id int not null, bossId int, name =
varchar(50))<o:p></o:p></span></font></p>

</div>

<div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>&nbsp;<o:p></o:p></span></font></p>

</div>

<div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>Class Definition:<o:p></o:p></span></font></p>

</div>

<div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>&nbsp;<o:p></o:p></span></font></p>

</div>

<div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>public class Employee {<o:p></o:p></span></font></p>

</div>

<div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>&nbsp; private Integer id;<o:p></o:p></span></font></p>

</div>

<div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>&nbsp; private String name;<o:p></o:p></span></font></p>

</div>

<div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>&nbsp; private List employees;<o:p></o:p></span></font></p>

</div>

<div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>&nbsp; // getters/setters<o:p></o:p></span></font></p>

</div>

<div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>}<o:p></o:p></span></font></p>

</div>

<div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>&nbsp;<o:p></o:p></span></font></p>

</div>

<div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>&nbsp;<o:p></o:p></span></font></p>

</div>

<div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>iBATIS stuff:<o:p></o:p></span></font></p>

</div>

<div>

<p><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt'>&lt;resultMap
id=3D&quot;boss&quot; class=3D&quot;test.Employee&quot; =
groupBy=3D&quot;id&quot;&gt;<br>
&nbsp; &lt;result property=3D&quot;id&quot; column=3D&quot;bossId&quot; =
/&gt;<br>
&nbsp; &lt;result property=3D&quot;name&quot; =
column=3D&quot;bossName&quot; /&gt; <br>
&nbsp; &lt;result property=3D&quot;employees&quot;
resultMap=3D&quot;employee&quot;/&gt;<br>
&lt;/resultMap&gt;<o:p></o:p></span></font></p>

<p><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt'>&lt;resultMap
id=3D&quot;employee&quot; class=3D&quot;test.Employee&quot;&gt;<br>
&nbsp; &lt;result property=3D&quot;id&quot; =
column=3D&quot;employeeId&quot; /&gt;<br>
&nbsp; &lt;result property=3D&quot;name&quot; =
column=3D&quot;employeeName&quot;
/&gt; <br>
&lt;/resultMap&gt;<o:p></o:p></span></font></p>

<p><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt'>&lt;select
id=3D&quot;selectEmployees&quot; resultMap=3D&quot;boss&quot;&gt;<br>
&nbsp; select <a href=3D"http://a.id">a.id</a> as employeedId, <a
href=3D"http://a.name">a.name</a> as employeeName, <a =
href=3D"http://b.id">b.id</a>
as bossId, <a href=3D"http://b.name">b.name</a> as bossName<br>
&nbsp; from employees a join employees b<br>
&nbsp;&nbsp;&nbsp; on a.bossId =3D <a href=3D"http://b.id">b.id</a><br>
&nbsp; where a.bossId is not null<br>
&lt;/select&gt;<o:p></o:p></span></font></p>

</div>

<div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>This&nbsp;returns all the data in one pass, so no N+1 =
problem.<o:p></o:p></span></font></p>

</div>

<div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>&nbsp;<o:p></o:p></span></font></p>

</div>

<div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>Jeff Butler<o:p></o:p></span></font></p>

</div>

<div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'><br>
&nbsp;<o:p></o:p></span></font></p>

</div>

<div>

<p class=3DMsoNormal><span class=3Dgmailquote><font size=3D3 =
face=3D"Times New Roman"><span
style=3D'font-size:12.0pt'>On 7/5/06, <b><span =
style=3D'font-weight:bold'>Rick</span></b>
&lt;<a =
href=3D"mailto:ricks_mailinglists@arc-mind.com">ricks_mailinglists@arc-mi=
nd.com</a>&gt;
wrote:</span></font></span> <o:p></o:p></p>

<p class=3DMsoNormal style=3D'margin-bottom:12.0pt'><font size=3D3
face=3D"Times New Roman"><span style=3D'font-size:12.0pt'>Someone sent =
me a
solution to the self-join that I asked about earlier as<br>
follows:<br>
<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;resultMap =
id=3D&quot;employee&quot;
class=3D&quot; sample01.Employee&quot;&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;
&lt;result property=3D&quot;employeeId&quot; =
column=3D&quot;employee_id&quot;/&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;
&lt;result property=3D&quot;bossId&quot; column=3D&quot;boss_id&quot;
nullValue=3D&quot;-1&quot; <br>
select=3D&quot;getBoss&quot;/&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;
&lt;result property=3D&quot;firstName&quot; =
column=3D&quot;first_name&quot;/&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;
&lt;result property=3D&quot;lastName&quot; =
column=3D&quot;last_name&quot;/&gt; <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/resultMap&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;statement =
id=3D&quot;getEmployees&quot;
resultMap=3D&quot;employee&quot;&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;
select * from Employee<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/statement&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;statement =
id=3D&quot;getBoss&quot;
resultMap=3D&quot;employee&quot;&gt; <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;
select * from Employee where employee_id=3D#value#<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/statement&gt;<br>
<br>
<br>
This is very helpful in understanding how iBatis works. I think I will =
stick<br>
with the other approach b/c the code above would perform 1 query for =
each <br>
boss (N+1). The approach I used (with the helper method) only hits the =
db<br>
once. It gets all the data it needs in one swipe and then builds the<br>
hierarchy.<br>
<br>
<br>
Again, my former approach gets all of the employees in the tree (using =
<br>
connect-by) and then constructs the hierarchy.<br>
<br>
<br>
The above way is much cleaner in that it does not require custom Java =
code<br>
to build the list. Its runtime performance would be problematic =
especially<br>
since I am replacing code that does not have an N+1 issue (custom VB/ASP =
<br>
app).<br>
<br>
I'd like to have something like this (as a new feature in iBatis):<br>
<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;resultMap =
id=3D&quot;employee&quot;
class=3D&quot;sample01.Employee&quot;&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;
&lt;result property=3D&quot;employeeId&quot; =
column=3D&quot;employee_id&quot;/&gt; <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;
&lt;result property=3D&quot;boss&quot; =
fk_property=3D&quot;bossId&quot;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
adder-method=3D&quot;addDirectReport&quot; =
self-join=3D&quot;true&quot;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
pk_property=3D&quot;emplId&quot;/&gt; <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;
&lt;result property=3D&quot;firstName&quot; =
column=3D&quot;first_name&quot;/&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;
&lt;result property=3D&quot;bossId&quot; =
column=3D&quot;n_supervisor&quot;/&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;
&lt;result property=3D&quot;lastName&quot; =
column=3D&quot;last_name&quot;/&gt; <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/resultMap&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;statement =
id=3D&quot;getEmployees&quot;
resultMap=3D&quot;employee&quot;&gt;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;
select * from Employee e<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
start with n_supervisor =3D #supervisorId# <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
connect by n_supervisor =3D prior emplid<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/statement&gt;<br>
<br>
<br>
See the:<br>
<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;
&lt;result property=3D&quot;boss&quot; =
fk_property=3D&quot;bossId&quot;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
adder-method=3D&quot;addDirectReport&quot; self-join=3D&quot;true&quot; =
<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
pk_property=3D&quot;emplId&quot;/&gt;<br>
<br>
Basically the data for the hierarchy is already retrieved from the db. =
Why<br>
hit it a second time?<br>
<br>
Thoughts?<br>
<br>
<br>
-----Original Message-----<br>
From: Larry Meadors [mailto:<a =
href=3D"mailto:lmeadors@apache.org">lmeadors@apache.org</a>]<br>
Sent: Monday, July 03, 2006 3:54 PM<br>
To: <a =
href=3D"mailto:user-java@ibatis.apache.org">user-java@ibatis.apache.org</=
a><br>
Subject: Re: Employee self-join one to many relationship (iBatis) <br>
<br>
Hmm, I generally don't build my object model that way, so my<br>
experience with groupBy is sort of limited, sorry. ;-)<br>
<br>
If you can't make groupBy work, I'd look at doing this with a<br>
rowhandler. You'd get all the data in one hit to the database, and <br>
then step through the results building the object graph the way you<br>
want it.<br>
<br>
Larry<br>
<br>
<br>
On 7/3/06, Rick &lt;<a =
href=3D"mailto:ricks_mailinglists@arc-mind.com">ricks_mailinglists@arc-mi=
nd.com</a>&gt;
wrote: <br>
&gt; Bingo!<br>
&gt;<br>
&gt; Yep. Employee has a directReports list which is a list of =
Employees.<br>
&gt;<br>
&gt;<br>
&gt;<br>
&gt; -----Original Message-----<br>
&gt; From: Larry Meadors [mailto:<a href=3D"mailto:lmeadors@apache.org">
lmeadors@apache.org</a>]<br>
&gt; Sent: Monday, July 03, 2006 3:19 PM<br>
&gt; To: <a =
href=3D"mailto:user-java@ibatis.apache.org">user-java@ibatis.apache.org</=
a><br>
&gt; Subject: Re: Employee self-join one to many relationship (iBatis) =
<br>
&gt;<br>
&gt; Hey Rick, I am not 100% sure I understand what you are trying to =
do,<br>
&gt; but let me try to restate it and see..<br>
&gt;<br>
&gt; Do you want a list of employees, each one with another list of<br>
&gt; employees (direct reports), and a list of contacts on each one - =
both <br>
&gt; the main employee list and the child employees?<br>
&gt;<br>
&gt; Larry<br>
&gt;<br>
&gt;<br>
&gt; On 7/3/06, Rick &lt;<a =
href=3D"mailto:ricks_mailinglists@arc-mind.com">ricks_mailinglists@arc-mi=
nd.com</a>&gt;
wrote:<br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt; I just want to use iBatis in the cleanest way possible. I have =
a<br>
&gt; workaround<br>
&gt; &gt; but wonder if iBatis support self-joined one to many =
relationships. <br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt; Let me explain..<br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt; I have a query that returns employees.<br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt; <br>
&gt; &gt; Employees have Boss's who are Employees.<br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt; Currently I have Employees have Contacts who have Phone =
Numbers.<br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt; (Where Employee, Contact and Phone number are objects.) <br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt; I'd like to have Employees have Employees (directReports) and
Employees<br>
&gt; have<br>
&gt; &gt; Contacts who have Phone Numbers.<br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt; <br>
&gt; &gt; Does iBatis support a self join?<br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt; Here is my current mapping and how I get around this lack of =
support
(or<br>
&gt; is<br>
&gt; &gt; this support lacking)... <br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt; , i.e.,<br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;resultMap =
id=3D&quot;employee&quot;<br>
&gt; &gt; class=3D&quot;qcom.cas.mysourcej.poc.model.Employee&quot; <br>
&gt; &gt; groupBy=3D&quot;emplid&quot;&gt;<br>
&gt; &gt;<br>
&gt;
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;
&lt;result property=3D&quot;emplid&quot; column=3D&quot;emplid&quot; =
/&gt;<br>
&gt; &gt;<br>
&gt;
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;
&lt;result property=3D&quot;name&quot; column=3D&quot;name&quot; /&gt; =
<br>
&gt; &gt;<br>
&gt;
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;
&lt;result property=3D&quot;contacts&quot; =
resultMap=3D&quot;employee.contacts&quot;/&gt;<br>
&gt; &gt;<br>
&gt;
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;
&lt;result property=3D&quot;bossId&quot; =
column=3D&quot;bossId&quot;/&gt; <br>
&gt; &gt;<br>
&gt; &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/resultMap&gt;<br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;resultMap
id=3D&quot;contacts&quot;<br>
&gt; &gt; =
class=3D&quot;qcom.cas.mysourcej.poc.model.Contact&quot;&gt;<br>
&gt; &gt;<br>
&gt;
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;
&lt;result property=3D&quot;name&quot; =
column=3D&quot;contact_name&quot;/&gt;<br>
&gt; &gt;<br>
&gt;
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;
&lt;result property=3D&quot;primaryContact&quot;
column=3D&quot;primary_contact&quot; <br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt;<br>
typeHandler=3D&quot;qcom.cas.commons.ibatis.typehandler.StringBooleanType=
Handler&quot;<br>
&gt; &gt; /&gt;<br>
&gt; &gt;<br>
&gt;
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;
&lt;result property=3D&quot;relationship&quot; =
column=3D&quot;relation&quot;/&gt; <br>
&gt; &gt;<br>
&gt;
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;
&lt;result property=3D&quot;phoneNumber1.number&quot;
column=3D&quot;phone1&quot;/&gt;<br>
&gt; &gt;<br>
&gt;
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;
&lt;result property=3D&quot;phoneNumber2.number&quot;
column=3D&quot;phone2&quot;/&gt; <br>
&gt; &gt;<br>
&gt;
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;
&lt;result property=3D&quot;phoneNumber3.number&quot;
column=3D&quot;phone3&quot;/&gt;<br>
&gt; &gt;<br>
&gt;
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;
&lt;result property=3D&quot;phoneNumber4.number&quot;
column=3D&quot;phone4&quot;/&gt; <br>
&gt; &gt;<br>
&gt;
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;
&lt;result property=3D&quot;phoneNumber1.areaCode&quot;<br>
column=3D&quot;areaCode1&quot;/&gt;<br>
&gt; &gt;<br>
&gt;
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;
&lt;result property=3D&quot;phoneNumber2.areaCode&quot; <br>
column=3D&quot;areaCode2&quot;/&gt;<br>
&gt; &gt;<br>
&gt; =
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;
&lt;result property=3D&quot;phoneNumber3.areaCode&quot;<br>
column=3D&quot;areaCode3&quot;/&gt;<br>
&gt; &gt;<br>
&gt;
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;
&lt;result property=3D&quot; phoneNumber4.areaCode&quot;<br>
column=3D&quot;areaCode4&quot;/&gt;<br>
&gt; &gt;<br>
&gt; &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/resultMap&gt;<br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;select <br>
&gt; &gt; =
id=3D&quot;getEmployeeEmergencyContactsUsingDirectSort&quot;<br>
&gt; &gt; resultMap=3D&quot;employee&quot;&gt;<br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt; If so, any pointers or references where I can learn to do =
this.. <br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt; Currently I have a method that turns the list of employees =
into a<br>
&gt; hierarchy<br>
&gt; &gt; of Employees as follows:<br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /** <br>
&gt; &gt;<br>
&gt; &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;* Turns a list =
of
employees into a hierarchy of employees.<br>
&gt; &gt;<br>
&gt; &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;* @param =
employees<br>
&gt; &gt;<br>
&gt; &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;* @param =
removeChild<br>
&gt; &gt;<br>
&gt; &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;*/ <br>
&gt; &gt;<br>
&gt; &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; private void
buildEmployeeObjectHierarchy(List<br>
&gt; &gt; employees, boolean removeChild) {<br>
&gt; &gt;<br>
&gt;
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;
Map employeeIDMap =3D new HashMap(employees.size());<br>
&gt; &gt; <br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt;
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;
for (Iterator iter =3D employees.iterator(); iter.hasNext();)<br>
{<br>
&gt; &gt;<br>
&gt;
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Employee employee =3D (Employee) iter.next();<br>
&gt; &gt;<br>
&gt;
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
employeeIDMap.put(employee.getEmplid(), employee);<br>
&gt; &gt;<br>
&gt;
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp; }<br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt;
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;
for (Iterator iter =3D employees.iterator (); iter.hasNext();)<br>
{<br>
&gt; &gt;<br>
&gt;
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Employee employee =3D (Employee) iter.next();<br>
&gt; &gt;<br>
&gt;
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Employee boss =3D (Employee)<br>
&gt; &gt; employeeIDMap.get(employee.getBossId ());<br>
&gt; &gt;<br>
&gt;
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
if (boss !=3D null) {<br>
&gt; &gt;<br>
&gt;
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;
boss.addEmployee(employee);<br>
&gt; &gt;<br>
&gt;
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;
iter.remove(); //If a boss is found, remove this <br>
&gt; &gt; employee from the list.<br>
&gt; &gt;<br>
&gt;
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
}<br>
&gt; &gt;<br>
&gt;
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp; }<br>
&gt; &gt;<br>
&gt; &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt; The above is a bit expensive and I'd like to get it out of my =
code if
<br>
&gt; &gt; possible. If not, no worries. I just want to use iBatis in the
cleanest<br>
&gt; way<br>
&gt; &gt; possible.<br>
&gt;<br>
&gt;<br>
&gt;<br>
<br>
<o:p></o:p></span></font></p>

</div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'><o:p>&nbsp;</o:p></span></font></p>

</div>

</body>

</html>

------=_NextPart_000_008A_01C6A022.F0A47600--