ibatis批量更新数据,使用xml拼接报错,望路过大佬指点一下
小韩博客 2019-07-11 02:39:55 抛出 ORA-01747: user.table.column, table.column 或列说明无效
xml为:
<update id="updateFromReport" parameterClass="list">
begin
<iterate conjunction="">
update TEMP_PD_SUM_CONFIG set
<isNotEmpty prepend="," property="[].configType" >
<![CDATA[CONFIG_TYPE = #[].configType#]]>
</isNotEmpty>
<isNotEmpty prepend="," property="[].projectId" >
<![CDATA[PROJECT_ID = #[].projectId#]]>
</isNotEmpty>
<isNotEmpty prepend="," property="[].projectName" >
<![CDATA[PROJECT_NAME = #[].projectName#]]>
</isNotEmpty>
<isNotEmpty prepend="," property="[].isparent" >
<![CDATA[ISPARENT = #[].isparent#]]>
</isNotEmpty>
<isNotEmpty prepend="" property="[].createUser" >
<![CDATA[CREATE_USER = #[].createUser#]]>
</isNotEmpty>
<isNotEmpty prepend="" property="[].createDate" >
<![CDATA[CREATE_DATE = #[].createDate#]]>
</isNotEmpty>
where PROD_SUM_C_ID=#[].identifier#;
</iterate>
end ;
</update>
请问是否可以这样写?