Manttomany-无法添加或更新子行：外键约束失败

Question

我正在尝试创建许多与许多关系，并将一些数据保存到数据库中。 我有实体：

@Data
@AllArgsConstructor
@NoArgsConstructor
@Entity
public class UnifiedOfferEntity {
    @Id
    @GeneratedValue(generator = "uuid")
    @GenericGenerator(name = "uuid", strategy = "uuid2")
    private String idOffer;
    private String companyName;
    private String city;
    private String street;
    private String title;
    private LocalDateTime posted;
    private String url;
    private boolean remote;
    private boolean remoteRecruitment;
    @ManyToMany
    @JoinTable(
        name = "terms_of_contract",
        joinColumns = @JoinColumn(name = "offer_id"),
        inverseJoinColumns = @JoinColumn(name = "contract_id"))
    private Set<ContractDetailsEntity> contractDetails = new HashSet<>();
}

@Entity
@Data
@Table(name = "ContractDetails")
@AllArgsConstructor
@NoArgsConstructor
public class ContractDetailsEntity {
    @Id
    @Column(name = "id", nullable = false)
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private String id;
    @Enumerated(EnumType.STRING)
    private TypeOfContract typeOfContract;
    private double salaryFrom;
    private double salaryTo;
    @ManyToMany(mappedBy = "contractDetails")
    private Set<UnifiedOfferEntity> unifiedOffers = new HashSet<>();

}

，当我想保存一些东西时，我会得到执行，我不知道怎么了：

java.sql.SQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`jobfinder`.`terms_of_contract`, CONSTRAINT `FKfyi46wtjxm9cmb5fh28lf47qt` FOREIGN KEY (`contract_id`) REFERENCES `contract_details` (`id`))

Answer 1

尝试以这种方式映射您的实体

  @ManyToMany(cascade = {
        CascadeType.PERSIST,
        CascadeType.MERGE
    })
    @JoinTable(
        name = "terms_of_contract",
        joinColumns = @JoinColumn(name = "offer_id"),
        inverseJoinColumns = @JoinColumn(name = "contract_id"))
    private Set<ContractDetailsEntity> contractDetails = new HashSet<>();