ibatis 2.0 1:1 sql 問題

Question

<sqlMap>
    <typeAlias alias="emp" type="com.resunly.ibatis.Emp"/>

     <resultMap id="empMAPResult" class="emp">
        <result property="id" column="id" />
        <result property="empName" column="empname"/>
        <result property="empAddr" column="empaddr"/>
        <result property="empSex" column="empsex"/>
        <result property="departName" column="depart.depname"/>
        <result property="des" column="depart.des"/>
    </resultMap>
    <select id="getEmp" parameterClass="java.lang.String"   resultMap="empMAPResult" >
      <![CDATA[
          select a.empName as empName,
               a.empAddr as empAddr,
               a.empSex as empSex,
               b.depName as departName,
               b.des as des
          from emp a, depart as b where a.departNo=b.depNo
        ]]>
    </select>

</sqlMap>

 老被提示ORA-00933: SQL command not properly ended

 

不真的是哪裡的錯誤，幫忙看下

Answer 1

[quote]resultMap 里是6个字段， select 里是 5个字段[/quote]
我自己模拟试了下，不会报错啊