ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Niels Beekman" <n.beek...@wis.nl>
Subject RE: Getting UncategorizedSQLException
Date Wed, 13 Jul 2005 17:38:20 GMT
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 <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