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 18:29:38 GMT
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 <mailto:satish.rao@fmr.com>  
		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
<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