That didn't work either.
-----Original Message-----
From: Zarar Siddiqi [mailto:zarar.siddiqi@utoronto.ca]
Sent: Wednesday, July 13, 2005 12:14 PM
To: user-java@ibatis.apache.org
Subject: Re: Getting UncategorizedSQLException

Try changing 
SELECT R.ORD_ID
to
SELECT R.ORD_ID as ORD_ID and see if it works.
 
----- Original Message -----
From: Rao, Satish
To: user-java@ibatis.apache.org
Sent: Wednesday, July 13, 2005 11:49 AM
Subject: Getting UncategorizedSQLException


I get an UncategorizedSQLException when I execute the 'listRunDetails' select statement shown below. The query is a join between two tables. Am I doing something wrong here?

        <resultMap id="list-rundetail-result" class="com.xxx.xxx.Order">
                <result property="orderId" column="R.ORD_ID"/>
                <result property="participantId" column="PART_ID"/>
                <result property="clientId" column="CLNT_ID_N"/>
                <result property="plan" column="PLAN_N"/>
                <result property="channel.channelType" column="CHAN_TYPE_C"/>
                <result property="channel.email" column="EMAIL_ADDR_X"/>
                <result property="channel.line1Address" column="LINE_1_AD_X"/>
        </resultMap>

        <select id="listRunDetails"  resultMap="list-rundetail-result" cacheModel="rundetail-cache">
                SELECT
                        R.ORD_ID,
                        PART_ID,
                        CLNT_ID_N,
                        CHAN_TYPE_C,
                        EMAIL_ADDR_X,
                        LINE_1_AD_X,
                FROM
                        TABLE1 R, TABLE2 O
                WHERE
                        R.ORD_ID = O.ORD_ID
                AND
                        R.RUN_ID LIKE #runId#
                <isNotNull prepend="AND" property="participantId">
                        R.PART_ID LIKE #participantId#
                </isNotNull>
                <isGreaterThan prepend="AND" property="client" compareValue="0">
                        R.CLNT_ID_N = #client#
                </isGreaterThan>
        </select>


com.xxx.xxx.Order contains Channel object.