ibatis 不解析备忘

最新推荐文章于 2024-11-03 00:09:08 发布

xiaowusheng

最新推荐文章于 2024-11-03 00:09:08 发布

阅读量681

点赞数

CC 4.0 BY-SA版权

文章标签： ibatis exception nested sql command query

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

本文介绍了一个关于Spring框架中出现的BadSqlGrammarException异常的具体案例，该异常源于SQL语句拼接错误导致。通过分析错误原因及提供的SQL代码片段，文章详细解释了如何正确地使用动态SQL来避免此类错误，并给出了具体的解决方案。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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[

]]>