无法通过 Spring Data rest json post 将数据保存到复合表 [英] Unable to save data to composite Table Via Spring Data rest json post

问题描述

我在数据库中有 3 个表
培训
- training_id (pk)

user_profile
- profile_id (pk)

-training_profile(复合表)
- training_id
- profile_id

我已经在 user_profile 表中记录了 profile_id=44 并想为训练表创建新记录，并将此新训练与 ID 为 44 的现有 user_profile 记录相关联，但在将发布数据保存到训练表后但它没有插入到查找表 user_training 中.
我的项目等级是- 培训班

@Entity@Table(name = "training", schema = "public")公共类培训实现 java.io.Serializable {@Id @GeneratedValue@Column(name = "training_id", unique = true, nullable = false)私人长期培训ID；@ManyToMany(fetch = FetchType.LAZY，mappedBy = "trainings")私有集userProfiles = new HashSet(0);@Column(name = "training_subject", 长度 = 200)私人字符串培训主题；公共培训(){}公共长 getTrainingId() {返回 this.trainingId;}public void setTrainingId(Long trainingId) {this.trainingId = trainingId;}公共字符串 getTrainingSubject() {返回 this.trainingSubject;}public void setTrainingSubject(String trainingSubject) {this.trainingSubject = trainingSubject;}公共集获取用户配置文件(){返回 this.userProfiles;}public void setUserProfiles(Set userProfiles) {this.userProfiles = userProfiles;}}

• 用户资料
  

  @Entity@Table(name = "user_profile", schema = "public")
  公共类 UserProfile 实现 java.io.Serializable {

  @Id @GeneratedValue@Column(name = "profile_id", unique = true, nullable = false)私人长档案ID；@Column(name = "profile_description")私人字符串配置文件描述；@ManyToMany(fetch = FetchType.EAGER, 级联 = { CascadeType.ALL })@JoinTable(name = "user_training", schema = "public", joinColumns = {@JoinColumn(name = "profile_id", nullable = false, updatable = false) }, inverseJoinColumns = {@JoinColumn(name = "training_id", nullable = false, updatable = false) })私人设置<培训>训练 = 新 HashSet<训练>(0);公共用户配置文件(){}公共字符串 getProfileDescription() {返回 this.profileDescription;}public void setProfileDescription(String profileDescription) {this.profileDescription = profileDescription;}公共集<训练>获取培训(){返回 this.trainings;}public void setTrainings(Set trainings) {this.trainings = 培训；}

  }

我通过邮递员的 json 帖子

我得到的回应

响应显示新的训练记录插入表中，training_id 为 67未找到此新保存的培训的关联

它再次为训练创建了新记录并且不与现有用户配置文件关联，我发布 curl -i -X POST -H "Content-Type:application/json" -d "{ \"trainingSubject\" : \"Oracle\", \"userProfiles\":[\"/userProfiles/44\"] }"

解决方案

您可以使用相对 url 分配:

<代码>{"trainingSubject": "oracle","userProfiles":["/userProfiles/44"]}

也许也可以尝试使用完整网址:http://localhost:8080/api/userProfiles/44

已编辑

如果您将 ManyToMany 关系的拥有站点移动到 Training，它将使用上述 JSON.因此，目前允许所有者设置房地产.如果你这样做:

@ManyToMany@JoinTable(name = "user_training", joinColumns = {@JoinColumn(name = "profile_id") }, inverseJoinColumns = {@JoinColumn(name = "training_id") })私人列表<UserProfile>userProfiles = new ArrayList<>();

加上

@ManyToMany(mappedBy = "userProfiles")私人名单<培训>培训 = 新的 ArrayList();

Training 拥有 userProfiles 内的关系.

我认为就您而言，这是目前最好的选择.另一种选择是，当在 transactions 上将所有者站点保持在 UserProfile 时，更新那里的关系，如:

PATCH http://localhost:8080/api/userProfiles/44{培训":[培训/66"，培训/67"]}

但是有了这个，您将需要多次休息调用(1. 发布新训练并获取新 Id 2. 获取当前训练列表 3. 带有新添加训练的 PATCH 训练列表)

最后一个选项是自己添加 REST 控制器.

第一种方法的完整文件:

@Entity@表公共类培训实现可序列化{@Id@GeneratedValue私人长期培训ID；@ManyToMany@JoinTable(name = "user_training", joinColumns = {@JoinColumn(name = "profile_id") }, inverseJoinColumns = {@JoinColumn(name = "training_id") })私人列表<UserProfile>userProfiles = new ArrayList<>();@Column(name = "training_subject", 长度 = 200)私人字符串培训主题；@实体@表公共类 UserProfile 实现了 Serializable {@Id@GeneratedValue私人长档案ID；@Column(name = "profile_description")私人字符串配置文件描述；@ManyToMany(mappedBy = "userProfiles")私人名单<培训>培训 = 新的 ArrayList();公共接口 TrainingRepository 扩展 JpaRepository{}公共接口 UserProfileRepository 扩展 JpaRepository{}

使用上层 JSON 这将起作用，我对其进行了测试.您不会在 curl-POST 的响应中直接看到正确的结果.要查看添加的关系，您必须遵循 userProfiles 链接，如 GET http://localhost:8080/transactions/<newId>/userProfiles

I have 3 Tables in db
training
- training_id (pk)

user_profile
- profile_id (pk)

-training_profile (composite table)
- training_id
- profile_id

I have already record in user_profile table having profile_id=44 and want to create new record for training table ,and also to associate this new training with already existing user_profile record which has id 44,but after post data is saved to training table but it is not inserted into lookup table user_training.
My Object Classes Are - Training Class

@Entity
@Table(name = "training", schema = "public")
public class Training implements java.io.Serializable {

    @Id @GeneratedValue
    @Column(name = "training_id", unique = true, nullable = false)
    private Long trainingId;


    @ManyToMany(fetch = FetchType.LAZY, mappedBy = "trainings")
    private Set<UserProfile> userProfiles = new HashSet<UserProfile>(0);

    @Column(name = "training_subject", length = 200)
    private String trainingSubject;

    public Training() {
    }

    public Long getTrainingId() {
        return this.trainingId;
    }

    public void setTrainingId(Long trainingId) {
        this.trainingId = trainingId;
    }


    public String getTrainingSubject() {
        return this.trainingSubject;
    }

    public void setTrainingSubject(String trainingSubject) {
        this.trainingSubject = trainingSubject;
    }


    public Set<UserProfile> getUserProfiles() {
        return this.userProfiles;
    }

    public void setUserProfiles(Set<UserProfile> userProfiles) {
        this.userProfiles = userProfiles;
    }
}

• UserProfile
  

  @Entity @Table(name = "user_profile", schema = "public")
  public class UserProfile implements java.io.Serializable {

  @Id @GeneratedValue
  @Column(name = "profile_id", unique = true, nullable = false)
  private Long profileId;
  
  @Column(name = "profile_description")
  private String profileDescription;
  
  @ManyToMany(fetch = FetchType.EAGER, cascade = { CascadeType.ALL })
  @JoinTable(name = "user_training", schema = "public", joinColumns = {
          @JoinColumn(name = "profile_id", nullable = false, updatable = false) }, inverseJoinColumns = {
                  @JoinColumn(name = "training_id", nullable = false, updatable = false) })
  private Set<Training> trainings = new HashSet<Training>(0);
  
  public UserProfile() {
  }
  
  
  public String getProfileDescription() {
      return this.profileDescription;
  }
  
  public void setProfileDescription(String profileDescription) {
      this.profileDescription = profileDescription;
  }
  
  
  public Set<Training> getTrainings() {
      return this.trainings;
  }
  
  public void setTrainings(Set<Training> trainings) {
      this.trainings = trainings;
  }
  

  }

My json post via postman

And Response I get

Response show that new training record inserted in table having training_id as 67 No association found for this new saved training

again it created new record for training and does not associate with existing user profile , I post curl -i -X POST -H "Content-Type:application/json" -d "{ \"trainingSubject\" : \"Oracle\", \"userProfiles\":[\"/userProfiles/44\"] }" http://localhost:8080/api/trainings

解决方案

You could use the relative url assignment:

{
    "trainingSubject": "oracle",
    "userProfiles":["/userProfiles/44"]
}

Maybe also try with the full url: http://localhost:8080/api/userProfiles/44

EDITED

If you move the owning site of the ManyToMany relation to Training it will work with the above JSON. So currently the owner is allowed to set the realtions. If you do it like that:

@ManyToMany
@JoinTable(name = "user_training"
, joinColumns = {@JoinColumn(name = "profile_id") }
, inverseJoinColumns = {@JoinColumn(name = "training_id") })
private List<UserProfile> userProfiles = new ArrayList<>();

plus

@ManyToMany(mappedBy = "userProfiles")
private List<Training> trainings = new ArrayList<>();

Training owns the relation within userProfiles.

I think in your case it's the best option for now. Another option would be, when keeping the owner site at UserProfile on transactions, to update the relation there like:

PATCH http://localhost:8080/api/userProfiles/44
{
    "trainings": ["trainings/66", "trainings/67"]
}

But with this you would need multible rest calls (1. POST new training and get the new Id 2. GET current training list 3. PATCH trainings list with newly added training)

Last option would be to add the REST-controller on your own.

Complete files for the first approach:

@Entity
@Table
public class Training implements Serializable {

    @Id
    @GeneratedValue
    private Long trainingId;

    @ManyToMany
    @JoinTable(name = "user_training"
    , joinColumns = {@JoinColumn(name = "profile_id") }
    , inverseJoinColumns = {@JoinColumn(name = "training_id") })
    private List<UserProfile> userProfiles = new ArrayList<>();

    @Column(name = "training_subject", length = 200)
    private String trainingSubject;


@Entity
@Table
public class UserProfile implements Serializable {

    @Id
    @GeneratedValue
    private Long profileId;

    @Column(name = "profile_description")
    private String profileDescription;

    @ManyToMany(mappedBy = "userProfiles")
    private List<Training> trainings = new ArrayList<>();


public interface TrainingRepository extends JpaRepository<Training, Long> {
}

public interface UserProfileRepository extends JpaRepository<UserProfile, Long> {
}

With the upper JSON this will work, I tested it. You will not see the correct result directly in the response of curl-POST. To see the added relation you must follow the userProfiles-link like GET http://localhost:8080/transactions/<newId>/userProfiles

这篇关于无法通过 Spring Data rest json post 将数据保存到复合表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！