ibatis 不解析备忘

最新推荐文章于 2023-07-01 21:06:14 发布

xiaowusheng

最新推荐文章于 2023-07-01 21:06:14 发布

阅读量655

点赞数

文章标签： ibatis exception nested sql command query

本文链接：https://blog.csdn.net/xiaowusheng/article/details/4748453

版权

SELECT * FROM T_SCRIPT_CONFIG <dynamic prepend="WHERE"> <isNotEmpty prepend="AND" property="id"> ID = ? </isNotEmpty> <isNotEmpty prepend="AND" property="name"> NAME like '%C%' </isNotEmpty> <isNotEmpty prepend="AND" property="code"> CODE = ? </isNotEmpty> <isNotEmpty prepend="AND" property="scriptType"> SCRIPT_TYPE = ? </isNotEmpty> </dynamic> order by ID

org.springframework.jdbc.BadSqlGrammarException: SqlMapClient operation; bad SQL grammar []; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in script_config.xml.
--- The error occurred while applying a parameter map.
--- Check the product.script.searchByKeyWord-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: java.sql.SQLException: ORA-00933: SQL command not properly ended

解决方案：去掉sql首尾的

<![CDATA[

]]>