Sybase存储过程报transaction mode错误

最新推荐文章于 2020-05-27 16:54:55 发布

iteye_14246

最新推荐文章于 2020-05-27 16:54:55 发布

阅读量220

点赞数

文章标签： Sybase Java JDBC JBoss DAO

本文链接：https://blog.csdn.net/iteye_14246/article/details/82036031

版权

报错信息:
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' command will cause the current session to use unchained transaction mode.
at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:3281)
at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:2548)
at com.sybase.jdbc2.jdbc.ResultGetter.nextResult(Resu ltGetter.java:69)
at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybS tatement.java:220)
at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybS tatement.java:203)
at com.sybase.jdbc2.jdbc.SybStatement.executeLoop(Syb Statement.java:1785)
at com.sybase.jdbc2.jdbc.SybCallableStatement.execute (SybCallableStatement.java:156)
at org.jboss.resource.adapter.jdbc.WrappedPreparedSta tement.execute(WrappedPreparedStatement.java:276)
at com.boco.alarm.commom.service.dao.AlarmCoreDAODnms MutiFilterImpl.cancelAlarms(AlarmCoreDAODnmsMutiFil terImpl.java:262)
at com.boco.alarm.common.service.impl.CancelAlarmServ ice.process(CancelAlarmService.java:69)
at com.boco.alarm.common.service.ServiceListenerFacto ry$ServiceListenerImpl.run(Unknown Source)
at java.lang.Thread.run(Thread.java:595)
解决办法: 在数据库中执行sp_procxmodesfa_ams_handle_can, 'anymode'即可。sfa_ams_handle_can是存储过程名。