Spring Boot Rest API empty Post Attribute

Question

Im new to spring boot and I want to code my first Rest API.

First of all my Models:

package entity;

import base.BaseEntityAudit;
import lombok.Data;

import javax.persistence.*;
import java.util.List;

@Data
@Entity
public class Country extends BaseEntityAudit {

    @Column(nullable = false)
    private String countryName;

    @Column(nullable = false)
    private String alpha2Code;
@OneToMany(mappedBy = "country", cascade = CascadeType.ALL, fetch = FetchType.EAGER)
private List<League> leagues;

public Country(String countryName, String alpha2Code) {
    this.countryName = countryName;
    this.alpha2Code = alpha2Code;
}

public Country() {
}


}

This Model should have a OneToMany relation to the following:

    package entity;

import base.BaseEntityAudit;
import lombok.Data;

import javax.persistence.*;

@Data
@Entity
public class League extends BaseEntityAudit {

    private Long id;

    @Column(nullable = false)
    private String leagueName;

    @Column(nullable = false)
    private String leagueName_clean;

    @ManyToOne(fetch = FetchType.EAGER)
    @JoinColumn(name = "country_id", referencedColumnName = "id")
    private Country country;

/*    @ManyToMany
    @Column(nullable = false)
    private Season season;*/
}

This one has a OneToMany Association. So each League has a country

The important thing is the controller for league Entity I would think. There is a Post Endpoint. If I create a new League, I want to send a country Id with it to associate the League with a country, but my Problem is, that the "country" attribute is always null allthough I send it in my post request.

    import org.springframework.web.bind.annotation.*;
import repository.CountryRepository;
import repository.LeagueRepository;
import response.StandardResponse;

import java.util.List;

@RestController
@RequestMapping(path = "/api/v1")
public class LeagueController {
    Logger logger = LoggerFactory.getLogger(LeagueController.class);

    private final LeagueRepository dataRepo;
    private final CountryRepository countryRepository;

    public LeagueController(@Autowired LeagueRepository datarepo, CountryRepository countryRepository) {
        this.dataRepo = datarepo;
        this.countryRepository = countryRepository;
    }

    @GetMapping(path = "/league", produces = MediaType.APPLICATION_JSON_VALUE)
    public StandardResponse getAllLeagues() {
        List<League> leagues = this.dataRepo.findAll();

        return new StandardResponse(HttpStatus.OK, leagues);
    }

    @PostMapping(path = "/league/add", consumes = MediaType.APPLICATION_FORM_URLENCODED_VALUE, produces = MediaType.APPLICATION_JSON_VALUE)
    public StandardResponse createLeague(League l) {
        System.out.println(l);
        League league = this.dataRepo.save(l);

        return new StandardResponse(HttpStatus.OK, league);
    }
}

You can see the parameter of the Post Method is from type League. I don't want to change the parameter. What Im missing? Can anyone Help?

This is what Im Posting:

[{"key":"leagueName","value":"testLeague","description":"","type":"text","enabled":true},{"key":"country","value":"1","description":"","type":"text","enabled":true},{"key":"leagueName_clean","value":"testleague","description":"","type":"text","enabled":true}]

This is my BaseEntityAudit. Im using it to have updatedAt and createdAt fields automaticcly for each entity:

    package base;

import org.springframework.data.jpa.domain.support.AuditingEntityListener;

import javax.persistence.*;
import java.util.Date;

@EntityListeners(AuditingEntityListener.class)
@MappedSuperclass
public abstract class BaseEntityAudit extends BaseEntity {
    @Column(name = "createdAt")
    @Temporal(TemporalType.TIMESTAMP)
private Date createdAt = new Date();

@Column(name = "updatedAt")
@Temporal(TemporalType.TIMESTAMP)
private Date updatedAt = new Date();

public Date getCreatedAt() {
    return createdAt;
}

public void setCreatedAt(Date createdAt) {
    this.createdAt = createdAt;
}

public Date getUpdatedAt() {
    return updatedAt;
}

public void setUpdatedAt(Date updatedAt) {
    this.updatedAt = updatedAt;
}

@PrePersist
public void setCreationDate() {
    this.createdAt = new Date();
}

/**
 * Sets updatedAt before update
 */
@PreUpdate
public void setChangeDate() {
    this.updatedAt = new Date();
}
}

Is it country that is null, or is whole League (l) object null? — TomekK, Aug 23 '19 at 14:20
"message": "JSON parse error: Cannot construct instance of `entity.Country` (although at least one Creator exists): no int/Int-argument constructor/factory method to deserialize from Number value (1); nested exception is com.fasterxml.jackson.databind.exc.MismatchedInputException: Cannot construct instance of `entity.Country` (although at least one Creator exists): no int/Int-argument constructor/factory method to deserialize from Number value (1)\n at [Source: (PushbackInputStream); line: 4, column: 13] (through reference chain: entity.League[\"country\"])", — b0ss, Aug 30 '19 at 13:33

Avijit Barua · Answer 1 · 2019-08-23T15:19:24.917

0

In rest API if you want to post object you need to use @RequestBody annotation. So modify your controller

 @PostMapping(path = "/league/add" , consumes = MediaType.APPLICATION_FORM_URLENCODED_VALUE, produces = MediaType.APPLICATION_JSON_VALUE)
    public StandardResponse createLeague(League l) {
        System.out.println(l);
        League league = this.dataRepo.save(l);

        return new StandardResponse(HttpStatus.OK, league);
    }

to

 @PostMapping(path = "/league/add")
    public StandardResponse createLeague(@RequestBody League l) {
        System.out.println(l);
        League league = this.dataRepo.save(l);

        return new StandardResponse(HttpStatus.OK, league);
    }

Now comment this section at league class.

  @ManyToOne(fetch = FetchType.EAGER)
    @JoinColumn(name = "country_id", referencedColumnName = "id")
    private Country country;

Now in postman post data like this image

edited Aug 23 '19 at 15:19

answered Aug 23 '19 at 14:22

Avijit Barua

2,950
5
14
35

This gives me: "Content type 'application/x-www-form-urlencoded;charset=UTF-8' not supported" – b0ss Aug 23 '19 at 14:48
@b0ss Can you check database whether data saved or not ? – Avijit Barua Aug 23 '19 at 14:53
@b0ss Can you try removing all parameters from `@PostMapping(path = "/league/add")` . Please try writing controller as I wrote. – Avijit Barua Aug 23 '19 at 14:56
It is not saving and if I remove the parameters Im getting: "could not execute statement; SQL [n/a]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement" – b0ss Aug 23 '19 at 14:58
@b0ss You are getting error because some of your entity value may be may be null during posting. So please try removing ` @Column(nullable = false)` this type validation. Or make sure that all entity value with validation is not null. – Avijit Barua Aug 23 '19 at 15:01
The PRoblem is, the not nullable values really should not be null. So each League MUST have a country – b0ss Aug 23 '19 at 15:02
@b0ss Solved your problem ? – Avijit Barua Aug 23 '19 at 15:03
No its not solved. I added my post parameters mybe this helps? – b0ss Aug 23 '19 at 15:05
@b0ss Please post your `BaseEntityAudit` and give a screenshot of postman with body value – Avijit Barua Aug 23 '19 at 15:09
@b0ss I have edited my answer. You are posting data in wrong way. Perhaps that's why getting error – Avijit Barua Aug 23 '19 at 15:20
@b0ss You didn't give any feedback – Avijit Barua Aug 24 '19 at 15:19

Shavk with a Hoon · Answer 2 · 2019-08-23T14:50:36.020

0

I think your decorator tags are incorrect. My RESTful API requests look like this :

@RequestMapping(value = "/something", method = RequestMethod.POST)
    private @ResponseBody Antenna someMethod(@RequestBody Object o) {
        o.doSomthing();
    return o;
    }

Look at Content type 'application/x-www-form-urlencoded;charset=UTF-8' not supported for @RequestBody MultiValueMap

edited Aug 23 '19 at 14:50

answered Aug 23 '19 at 14:23

Shavk with a Hoon

568
4
21

Error: "Content type 'application/x-www-form-urlencoded;charset=UTF-8' not supported" – b0ss Aug 23 '19 at 14:55

Spring Boot Rest API empty Post Attribute

2 Answers2