Ibatis ORA-00936: 缺失表达式异常原因之一

最新推荐文章于 2024-03-13 15:09:37 发布

原创最新推荐文章于 2024-03-13 15:09:37 发布 · 4.7k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#java #数据库

用ibatis2.0做持久层开发，出现以下异常：

com.ibatis.common.jdbc.exception.NestedSQLException:   
--- The error occurred while applying a parameter map.  
--- Check the FINGERDB_MANAGERINFO.countByParams-InlineParameterMap.  
--- Check the statement (query failed).  
--- Cause: java.sql.SQLException: ORA-00936: 缺失表达式

Caused by: java.sql.SQLException: ORA-00936: 缺失表达式

	at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:185)
	at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForObject(GeneralStatement.java:104)
	at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:565)
	at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:540)
	at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:106)
	at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClientImpl.java:84)
	at data.ManagerInfoDao.countByParams(ManagerInfoDao.java:33)

经排查，错误在此处：

<isNotEmpty prepend="AND" property="deptnos">
  	 			<iterate prepend="AND" property="deptnos" open="(" close=")" conjunction="or">
  	 				DEPTNO = #deptnos[]#
  	 			</iterate>
  	 		</isNotEmpty>

去掉

prepend="AND"

改成以下即可。

<isNotEmpty prepend="AND" property="deptnos">
  	 			<iterate property="deptnos" open="(" close=")" conjunction="or">
  	 				DEPTNO = #deptnos[]#
  	 			</iterate>
  	 		</isNotEmpty>