The PLAN_N was included the in the select. You are right. It wouldn't have worked otherwise.
-----Original Message-----
From: Zarar Siddiqi [mailto:zarar.siddiqi@utoronto.ca]
Sent: Wednesday, July 13, 2005 2:27 PM
To: user-java@ibatis.apache.org
Subject: Re: Getting UncategorizedSQLException

I'm still curious to know how you got <result property="plan" column="PLAN_N"/>  to work without selecting PLAN_N.
----- Original Message -----
From: Rao, Satish
To: user-java@ibatis.apache.org
Sent: Wednesday, July 13, 2005 1:43 PM
Subject: RE: Getting UncategorizedSQLException

Yes, it is working now. As Niels, suggested the problem was with the SQL itself. I realized I was not passing in the correct field to the SQL.
There is no change in the <resultMap> and <select> I had posted earlier.
Thanks for the help.
 
-----Original Message-----
From: Niels Beekman [mailto:n.beekman@wis.nl]
Sent: Wednesday, July 13, 2005 1:38 PM
To: user-java@ibatis.apache.org
Subject: RE: Getting UncategorizedSQLException

True, but the UncategorizedSQLException is not thrown by iBATIS, I believe it is from Spring or something like that, so it should be related to the SQL itself. Could you please dump the complete stacktrace instead of just saying ‘some kind of exception X is thrown’?

 

Btw, it could be the comma after your last columnselect, just before the FROM-clause…

 


From: Zarar Siddiqi [mailto:zarar.siddiqi@utoronto.ca]
Sent: woensdag 13 juli 2005 18:31
To: user-java@ibatis.apache.org
Subject: Re: Getting UncategorizedSQLException

 

You're using this:

 

<result property="plan" column="PLAN_N"/>

 

but not retrieving PLAN_N in your SELECT clause.  I don't know if this is the reason for the UncategorizedSQLException but it's a problem otherwise also.

----- Original Message -----

From: Rao, Satish

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.