ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rao, Satish" <satish....@fmr.com>
Subject RE: Getting UncategorizedSQLException
Date Wed, 13 Jul 2005 16:20:26 GMT
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 <mailto:satish.rao@fmr.com>  
		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. 


Mime
View raw message