解决Caused by: java.sql.SQLException: ORA-00933: SQL command not properly ended
时间:2022-03-14 02:33
是iBATIS.xml这句话出错了 <isNotEmpty prepend="AND" property="beginDt" >a.updatedate >= #beginDt# </isNotEmpty> <isNotEmpty prepend="AND" property="endDt" >a.updatedate >= #endDt# </isNotEmpty>
改成 <isNotEmpty property="beginDt">and a.updateDate>=#beginDt#</isNotEmpty><!-- 起初日期 --> <isNotEmpty property="endDt">and a.updateDate<=#endDt#</isNotEmpty><!-- 结束日期 --> 就好