public void updateState(JdbcTemplate jdbcTemplate) {
        SoldCarServiceDTO soldCarServiceDTO = null;
        String query = "UPDATE sold_car_service SET service_state = ? WHERE  purchase_datetime >= ? AND purchase_datetime < ?";
        try {
            soldCarServiceDTO = jdbcTemplate.queryForObject(query, new BeanPropertyRowMapper<>(SoldCarServiceDTO.class), getState().toString(), getFrom(), getTo());
        } catch (Exception e) {
            jdbcTemplate.update("INSERT INTO error_log VALUES(?, ?)", soldCarServiceDTO.getPurchase_datetime(), e.getMessage());
        }
    }

new BeanPropertyRowMapper<>(SoldCarServiceDTO.class)

jdbcTemplate.queryForObject

jdbcTemplate.update(query, getState().toString(), getFrom(), getTo());

            String updateQuery="UPDATE sold_car_service SET service_state = '" + getState().toString() + "' WHERE id = ? ";

            List<SoldCarServiceDTO> purchases = jdbcTemplate.query("SELECT id " +
                            " FROM sold_car_service WHERE service_state != ? " +
                            " AND service_state != 'CLOSED' " +
                            "AND purchase_datetime >= ? " +
                            "AND purchase_datetime < ? ",
                    new Object[] {getState().toString(), getFrom(), getTo()},
                    new int[] { Types.VARCHAR, Types.DATE, Types.DATE },
                    new BeanPropertyRowMapper<>(SoldCarServiceDTO.class));

            List<Object[]> updateParams = new ArrayList<>();
            purchases.forEach(dto -> updateParams.add(new Object[]{dto.getId()}));

int[] result = jdbcTemplate.batchUpdate(updateQuery, updateParams, new int[] { Types.INTEGER });

   SoldCarServiceDTO notUpdatedDTO = null;
            for (int i = 0; i < result.length; i++) {
                if (result[i] == 0) {
                    notUpdatedDTO = purchases.get(i);
                    errorParams.add(new Object[] {now, "Not updated, id = " + notUpdatedDTO.getId()});
                }
            }