Global transaction is in progress
金蝶云社区-ouyang0517
ouyang0517
0人赞赏了该文章 764次浏览 未经作者许可,禁止转载编辑于2014年06月18日 16:13:40

public class ProductInBarcodeControllerBean extends
AbstractProductInBarcodeControllerBean {
protected void _getInsertEntryData(Context ctx, String saleOrderID, String ID)
throws BOSException {
String sqlDetail = "delete from t_bar_productInBarcodeEntry where fparentid = '"+ID+"'";
String sqlInsert = " /*dialect*/ insert into t_bar_productInBarcodeEntry(FID,FParentID,FSeq,CFMatID,CFUnitID,CFQty,CFStockID,CFSPID,CFSourceBillID, "
+ "CFSourceBillNumber,CFSourceBillEntryID,CFSourceBillTypeID,CFSourceBillEntrySeq) "
+ "select(to_char(systimestamp,'yyyy-mm-dd hh24:mi:ss.ff')||rownum),'"
+ ID
+ "',rownum, u1.fmaterialid,u1.funitid,u1.fqty,NULL,NULL,v1.fid, "
+ "v1.fnumber,u1.fid,v1.fbilltypeid,u1.fseq "
+ "from T_SD_SaleOrder v1 inner join T_SD_SaleOrderEntry u1 on v1.fid = u1.fparentid "
+ "where v1.fid in (" + saleOrderID + ")";
java.sql.Connection conn = this.getConnection(ctx);;
java.sql.PreparedStatement ps = null;
try{
conn.setAutoCommit(false);
ps = conn.prepareStatement(sqlDetail);
ps.execute();
ps = conn.prepareStatement(sqlInsert);
ps.execute();
conn.commit();
}catch(java.sql.SQLException e){
e.printStackTrace();
}
finally{
DBUtils.cleanup(null, ps, conn);
}
super._getInsertEntryData(ctx, saleOrderID, ID);
}
}

在运行到conn.setAutoCommit(false);这行代码时报以下错误!希望高手能帮助解决一下!
2014-06-18 15:39:27 错误 [con.err] java.sql.SQLException: Global transaction is in progress2014-06-18 15:39:27 错误 [con.err] at com.apusic.jdbc.adapter.ConnectionHandle.rollback(Unknown Source)