java事务调用存储过程
我现在有好多个的存储过程要一次执行,发生异常就得回滚。如何加上事务处理?
public void insertMSCServerOFCMSCIDProcedure(Connection con, String param) {
try {
con.setAutoCommit(false);
CallableStatement cstmt = con.prepareCall("{call " + param + "}");
cstmt.setInt(1, 11);
cstmt.setInt(2, 11);
cstmt.setInt(3, 11);
cstmt.setString(4, "aaaaaaa");
cstmt.execute();
CallableStatement cstmts = con.prepareCall("{call " + param + "}");
cstmt.setInt(1, 12);
cstmt.setInt(2, 12);
cstmt.setInt(3, 12);
cstmt.setString(4, "bbbbbbb");
cstmts.execute();
con.commit();
} catch (Exception e) {
con.rollback();
e.printStackTrace();
}
}
Stored procedure 'wo_insert_MSCServerOFCMSCID' may be run only in unchained transaction mode. The 'SET CHAINED OFF' command will cause the current session to use unchained transaction mode
直接报错了。