Spring事务问题 - 大数据clob插入需要事务

qingchun1987_303

于 2011-12-07 10:50:30 发布

阅读量3.3k

点赞数

CC 4.0 BY-SA版权

分类专栏： spring 文章标签： spring workflow ibatis exception nested sql

本文链接：https://blog.csdn.net/qingchun1987_303/article/details/7048900

在使用Spring、iBATIS进行大数据CLOB类型字段插入时遇到异常：'IllegalStateException: Spring transaction synchronization needs to be active...'。解决办法是在操作中加入Spring事务管理，确保事务的活性。

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

org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0];
--- The error occurred in sqlmap_mysql/bpm/bpmlob.xml.
--- The error occurred while applying a parameter map.
--- Check the BPM_WORKFLOW_BPMLOB.INSERT_BPMLOB-InlineParameterMap.
--- Check the parameter mapping for the 'procdefXml' property.
--- Cause: java.lang.IllegalStateException: Spring transaction synchronization needs to be active for setting values in iBATIS TypeHandlers that delegate to a Spring LobHandler; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in sqlmap_mysql/bpm/bpmlob.xml.
--- The error occurred while applying a parameter map.
--- Check the BPM_WORKFLOW_BPMLOB.INSERT_BPMLOB-InlineParameterMap.
--- Check the parameter mapping for the 'procdefXml' property.

--- Cause: java.lang.IllegalStateException: Spring transaction synchronization needs to be active for setting values in iBATIS TypeHandlers that delegate to a Spring LobHandler

解决：加入事务