ContractAddressParamValue addressValue = new ContractAddressParamValue();
addressValue.setHouseId(161);
addressValue.setFlat("5");
addressValue.setFloor(1);
addressValue.setComment("Коммент");
addressValue.setPod(1);
addressValue.setRoom("12");
cpm.updateAddressParam(bgContract.getId(), PARAM_ADDRESS, addressValue, USER_ID);

addressValue.setAddress("Тут сформированная строка адреса");

    private void updateAddress(Setup setup1, Connection connection, ContractParameterManager cpm, Contract bgContract, AtirraContract atirraContract) throws Exception {
        String streetShort = atirraContract.getStreetShort();
        String streetName = atirraContract.getStreetName();
        String houseStr = atirraContract.getHouseNo();
        Integer qFlat = atirraContract.getqFlat();

        Integer houseNo = 0;
        String houseFrac = "";
        if (houseStr.matches("^[0-9]+$")){
            houseNo = Integer.parseInt(houseStr);
        } else {
            houseFrac = houseStr.replaceAll("^[0-9]+", "");
            try{
                houseNo = Integer.parseInt(houseStr.replaceAll(houseFrac + "$", ""));
            } catch (Exception e){
                // действий не требуется
            }
        }

        Street bgStreet = getStreet(streetShort, streetName);
        String postIndex = getStreetIndex(connection, bgStreet.getId());
        House bgHouse = getHouse(bgStreet.getId(), houseNo, houseFrac, qFlat, postIndex);

        AddressStruct addressStruct = new AddressStruct();
        addressStruct.setCity(bgHouse.getCityTitle());
        addressStruct.setStreet(bgStreet.getTitle());
        addressStruct.setHouseId(bgHouse.getId());
        addressStruct.setHouse(bgHouse.getHouseFrac());
        addressStruct.setIndex(bgHouse.getPostIndex());
        addressStruct.setFlat(atirraContract.getFlatNo());
        addressStruct.setFloor(atirraContract.getFloor());
        addressStruct.setPod(atirraContract.getPorch());
        addressStruct.setRoom("");

        ContractAddressParamValue addressValue = new ContractAddressParamValue();
        addressValue.setHouseId(bgHouse.getId());
        addressValue.setFlat(atirraContract.getFlatNo());
        addressValue.setFloor(Integer.parseInt(atirraContract.getFloor()));
        addressValue.setPod(Integer.parseInt(atirraContract.getPorch()));
        addressValue.setRoom("");
        addressValue.setAddress(AddressUtils.getAddress(setup1.getBundlePreferences(), addressStruct, null));
        cpm.updateAddressParam(bgContract.getId(), PARAM_ADDRESS, addressValue, USER_ID);
    }

    private Street getStreet(String atirraStreetShort, String atirraStreetName) throws Exception {
        if (atirraStreetShort.equals("мкр-н")) atirraStreetShort = "мкр.";

        String streetName = atirraStreetShort + " " + atirraStreetName;
        ServerContext context = ServerContext.get();
        AddressService addressService = context.getService(AddressService.class, 0);
        List<Street> streets = addressService.streetList(CITY_ID, streetName);
        if (streets.size() == 1){
            return streets.get(0);
        } else {
            throw new Exception(streetName + " не существует.");
        }
    }

    private String getStreetIndex(Connection connection, Integer streetId) throws SQLException {
        String index = "";
        String query = "SELECT p_index FROM address_street WHERE id=?";
        PreparedStatement ps = connection.prepareStatement(query);
        ps.setInt(1, streetId);
        ResultSet rs = ps.executeQuery();
        rs.next();
        if (rs.getRow() == 1){
            index = rs.getString("p_index");
        }
        rs.close();
        ps.close();

        return index;
    }

    private House getHouse(Integer streetId, Integer houseNo, String houseFrac, Integer qFlat, String postIndex) throws BGException {
        ServerContext context = ServerContext.get();
        AddressService addressService = context.getService(AddressService.class, 0);
        List<House> houses = addressService.houseList(CITY_ID, 0, streetId, 0, houseNo, houseFrac, null);
        if (houses.size() == 1){
            return houses.get(0);
        } else {
            House house = new House();
            house.setHouse(houseNo);
            house.setFrac(houseFrac);
            house.setStreetId(streetId);
            house.setAmount(qFlat);
            house.setPostIndex(postIndex);
            addressService.houseUpdate(house);
            return house;
        }
    }

public class TestAddress
        extends GlobalScriptBase {
    final Integer CITY_ID = 2;

    @Override
    public void execute(Setup setup, ConnectionSet connectionSet)
            throws Exception {
        Connection connection = connectionSet.getConnection();
        AddressManager addressManager = new AddressManager(connection, setup);
        AddressHouse addressHouse = new AddressHouse();
        addressHouse.setStreetId(137);
        addressHouse.setAmount(10);
        addressHouse.setHouse(25);
        addressHouse.setFrac("A");
        addressHouse.setDate(new Date());
        addressManager.addHouse(addressHouse);
    }
}

java.sql.SQLException: No value specified for parameter 10

public void addHouse(AddressHouse house) {
        try {
            String e = "INSERT INTO address_house ( areaid, quarterid, streetid, house, frac, box_index, amount, comment, dt) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
            PreparedStatement ps = this.con.prepareStatement(e);
            byte idx = 1;
            int var7 = idx + 1;
            ps.setInt(idx, house.getAreaId());
            ps.setInt(var7++, house.getQuarterId());
            ps.setInt(var7++, house.getStreetId());
            ps.setInt(var7++, house.getHouse());
            ps.setString(var7++, house.getFrac());
            ps.setString(var7++, house.getBoxIndex());
            ps.setInt(var7++, house.getAmount());
            ps.setString(var7++, house.getComment());
            ps.setDate(var7, TimeUtils.convertDateToSqlDate(house.getDate()));
            ps.executeUpdate();
            int houseId = ServerUtils.lastInsertId(this.con);
            house.setId(houseId);
            ps.close();
        } catch (Exception var6) {
            var6.printStackTrace();
        }

    }