Error updating database. Cause: java.sql.SQLException: ORA-01722: 无效数字
原因:
<update id="deleteByIds" parameterType="string">
update Menu
set IsActive='0'
where MenuID in
<foreach collection="array" item="MenuID" open="(" close=")" separator=",">
#{MenuID,jdbcType=VARCHAR}
</foreach>
</update>
---------------------
parameterType="string"> 定义传入的类型是String[],实际上我传入的类型Integer[]