ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Zarar Siddiqi" <zarar.sidd...@utoronto.ca>
Subject Re: Getting UncategorizedSQLException
Date Wed, 13 Jul 2005 18:27:12 GMT
MessageI'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 

      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