/** * update icc order update report interface statuses * * @ejb.interface-method * @ejb.transaction type="Supports" */ public void updateIccOrderStates(OrderStatesValue object) throws LocalException { String sql = "update Order_States_For_Reports set ICC_OR_UP_ISENABLED=? where ORDER_STATES=?"; Connection con = null; PreparedStatement ps = null; ResultSet result = null; int i; try { con = getConnection(); ps = con.prepareStatement(sql); ps.setBoolean(1, object.isIcc_or_up_iseditable()); ps.setString(2, object.getOrder_states()); i = ps.executeUpdate(); } catch (Exception e) { // getLog().warn("####EX:" + e.getMessage()); throw new LocalException(e); } finally { closeQuietly(result, ps, con); } }