Stored procedure 'zhanghouying' may be run only in unchained transaction mode. The 'SET CHAINED OFF' command will cause the curr 2007-05-19 11:25:00

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);就可以了

E com.yc.ycportal.blockimp.sqlmapdao.BaseDao --- The error oc curr ed in com/yc/ycportal/blockimp/sqlmapdao/sqlmap/commonmap.xml. --- The error oc curr ed while applying a parameter map. --- Check the zh... 报错信息: 11:17:53,375 ERROR [AlarmCoreDAO] 告警取消错误： com.sybase.jdbc2.jdbc.SybSQLException: Stored procedure 'sfa_ams_handle_can' may be run only in unchained transaction mode . The 'SET CHAINED OFF' c... 在Webshere下连接Sybase DB,调用SP,报错如下:com.sybase.jdbc4.jdbc.SybSQLException: Stored procedure 'db_xxx..po_get_xxx' may be run only in unchained transaction mode . The 'SET CHAINED OFF' command will cause the ... Cause d by: com.sybase.jdbc3.jdbc.SybSQLException: Stored procedure 'proc_acctquery' may be unchained transaction mode 程序调用过程报以下错误：<code>com.sino.base.exception.DataHandleException: Stored procedure 'dbo.CTZC_TRANS_DATA2EFA' may be run only in unchained transaction mode 解决办法：执行以下命令 spring 事务配置 http://www.cnblogs.com/younggun/archive/2013/07/16/3193800.html spring 自我调用失效解决方案 http://blog.csdn.net/wxwzy738/article/details/27566645 sybase存储过程在事务内执行报 com.sybase.jdbc2.jdbc.SybSQLExcept