用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>
相关推荐
ibatis-common包ibatis-common包ibatis-common包ibatis-common包ibatis-common包ibatis-common包ibatis-common包ibatis-common包ibatis-common包ibatis-common包ibatis-common包
ibatis-2.3.4.726.jar,ibatis-2.3.0.677.jar,ibatis-2.3.3.720.jar下载,都已放入一个压缩包下。
ibatis-sqlmap ibatis-sqlmap-2 ibatis-sqlmap-2.jar.zip
apache开源项目源码ibatis-3-core-src-3.0.0.227 ibatis框架java源程序 spring,struts,hibernate,ibatis,框架源码 各种ibatis框架应用源码,你会从中得到意想不到的效果! apache开源组织开发的开源项目源码,其...
ibatis-3-core-3.0.0.242.jar.zipibatis-3-core-3.0.0.242.jar.zipibatis-3-core-3.0.0.242.jar.zipibatis-3-core-3.0.0.242.jar.zipibatis-3-core-3.0.0.242.jar.zip
iBATIS-DAO-2.pdf
iBATIS-SqlMaps-2-Tutorial_cniBATIS-SqlMaps-2-Tutorial_cn.pdf.pdfiBATIS-SqlMaps-2-Tutorial_cn.pdfiBATIS-SqlMaps-2-Tutorial_cn.pdf
ibatis-3-core-3.0.0.200
ibatis-3-core-3.0.0.242.zip ibatis-3-core-3.0.0.242.zip ibatis-3-core-3.0.0.242.zip ibatis-3-core-3.0.0.242.zip
ibatis 缓存 - 24小时学习网ibatis 缓存 - 24小时学习网ibatis 缓存 - 24小时学习网ibatis 缓存 - 24小时学习网ibatis 缓存 - 24小时学习网
ibatis-sqlmap-2.jar 对数据库进行操作的jar包 很方便使用
ibatis2-dao-2.1.6.589.jar文件,ibatis实现控制层
步骤1: 创建Qt项目首先,我们需要创建一个新的Q项自。打开Qt Creatr,并选择“新建项目”,然后选择“Qt Widgets应用程序”。为项目命名并选择保存路径。点击“下一步”并按照向导的指示完成项目创建过程。 步骤2: ...
ibatis-common-2.jar...........
ibatis-dao-2.jar gggggggggggg
包括ibatis-common-1.3.1.jar ibatis-common-2.jar
ibatis-core-3.0.jar 找了半天,终于找到了,很好的解决了我的问题,给所需要之人!~
ibatis-3-core-3.0.0.204 最新官方下载版
ibatis-2.3.3.720.jar
iBATIS视频呢 iBATIS iBATIS视频呢 iBATISiBATIS视频呢 iBATISiBATIS视频呢 iBATISiBATIS视频呢 iBATIS