Stored procedure 'zhanghouying' may be run only in unchained transaction mode. The 'SET CHAINED OFF'...

于 2007-05-19 11:25:00 发布 · 319 阅读

文章标签：

本文解决了在执行数据库存储过程时遇到的自动提交问题。通过设置连接的自动提交属性为true，成功避免了因未在非连锁事务模式下运行而导致的错误。

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

E com.yc.ycportal.blockimp.sqlmapdao.BaseDao
--- The error occurred in com/yc/ycportal/blockimp/sqlmapdao/sqlmap/commonmap.xml.
--- The error occurred while applying a parameter map.
--- Check the zhanghouyingpro-InlineParameterMap.
--- Check the statement (update procedure failed).
--- Cause: com.sybase.jdbc2.jdbc.SybSQLException: Stored procedure 'zhanghouying' may be run only in unchained transaction mode. The 'SET CHAINED OFF' command will cause the current session to use unchained transaction mode.

[07-5-19 10:31:26:384 CST] 7d323600 SystemOut O ========执行存储过程失败=======Error executing update. Cause: com.ibatis.common.jdbc.exception.NestedSQLException:

问题得解决：产生得原因是数据库使用得语句需要自动提交所以执行con.setAutoCommit(true);就可以了