ORA-01747: user.table.column, table.column 或列说明无效

ORA-01747: user.table.column, table.column 或列说明无效
   原因之一是sql语句拼接错误，多了逗点；二是使用到了oracle的关键字所致

下面是我在写程序时遇到的异常，是因为sql拼接错误。
控制台异常：



dangerousChemicalsUnit.xml

<update id="updateDangerousChemicalsUnit" parameterClass="dangerousChemicalsUnit">
update dangerousChemicalsUnit set
<dynamic>
<isPropertyAvailable prepend="," property="id">
         
            </isPropertyAvailable>

           <isPropertyAvailable prepend="," property="organization">
            orgId=#organization.id#
            </isPropertyAvailable>
        <isPropertyAvailable prepend="," property="orgInternalCode">
            orgInternalCode=#orgInternalCode#
            </isPropertyAvailable>
           <isPropertyAvailable prepend="," property="unitAddress">
            unitAddress=#unitAddress#
            </isPropertyAvailable>
               ……
       where  id = #id#
         </dynamic>
</update>


将控制台打印的sql语句在plsql中执行发现：sql语句在xml中拼接错误


改正：dangerousChemicalsUnit.xml

<update id="updateDangerousChemicalsUnit" parameterClass="dangerousChemicalsUnit">
update dangerousChemicalsUnit set
<dynamic>      
unitName=#unitName#
<isPropertyAvailable prepend="," property="organization">
            orgId=#organization.id#
            </isPropertyAvailable>
        <isPropertyAvailable prepend="," property="orgInternalCode">
            orgInternalCode=#orgInternalCode#
            </isPropertyAvailable>
           <isPropertyAvailable prepend="," property="unitAddress">
            unitAddress=#unitAddress#
            </isPropertyAvailable>
               ……
       where  id =#id# 
         </dynamic>
</update>

// 此处只要确保拼接的sql语句正确即可。避免update  dangerousChemicalsUnit set ，orgId=#organization.id#.....