pstmt = conn.prepareStatement(
"insert into TMP01_BILL_OF_MATERIALS(REPORT_ID,PROGRESSIVE,COMPANY_CODE,PAD,ITEM_CODE,DESCRIPTION,LEV,QTY,UM,PRICE,TOTAL_PRICE,COST,TOTAL_COST,CREATE_USER,CREATE_DATE) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"
);
expandNode(0,"",0,null,format,qtyFormat,reportId,pstmt,root,username);
return new VOResponse(reportId);
} catch (Exception ex1) {
Logger.error(username,this.getClass().getName(),"executeCommand","Error while fetching bill of materials and fill in TMP01 table",ex1);
try {
if (this.conn==null && conn!=null)
// rollback only local connection