Hibernate JPA @ManyToMany映射报错：外键约束失败无法更新子行

尝试在User与Group实体间建立@ManyToMany关联，期望保存Group时，用户与组的关联信息自动存入user_group中间表。但仅传递groupName请求保存Group时，出现外键约束失败错误：

2022-11-07 14:45:47.565 ERROR 29066 --- [nio-8080-exec-4] o.h.engine.jdbc.spi.SqlExceptionHelper : Cannot add or update a child row: a foreign key constraint fails (testdb.user_group, CONSTRAINT FK7k9ade3lqbo483u9vuryxmm34 FOREIGN KEY (user_id) REFERENCES users (id))

相关代码 #

User.java #

@Entity
@Table(name = "users", 
    uniqueConstraints = { 
      @UniqueConstraint(columnNames = "username"),
      @UniqueConstraint(columnNames = "email") 
    })
public class User {
  @Id
  @GeneratedValue(strategy = GenerationType.IDENTITY)
  private Long id;
  

  @ManyToMany(fetch = FetchType.LAZY)
  @JoinTable(  name = "user_roles", 
        joinColumns = @JoinColumn(name = "user_id"), 
        inverseJoinColumns = @JoinColumn(name = "role_id"))
  private Set<Role> roles = new HashSet<>();


  @ManyToMany(fetch = FetchType.LAZY,
          cascade = {
                  CascadeType.PERSIST,
                  CascadeType.MERGE
          },
          mappedBy = "users")
  @JsonIgnore
  private Set<Group> groups = new HashSet<>();

  public Set<Group> getGroups() {
    return groups;
  }
}

Group.java #

@Entity
@Table(name = "grp")
public class Group {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    @Column
    private String groupName;

    @Column
    private String createdBy;

    public Group(String groupName, String createdBy ) {
        this.groupName = groupName;
        this.createdBy = createdBy;
    }


    public Group() {

    }
}

GroupController.java #

@RestController
@RequestMapping("/api")
public class GroupController  {


    @Autowired
    GroupRepository groupRepository;

    @Autowired
    UserRepository userRepository;

    @PostMapping("/group")
    public ResponseEntity<Group> createTutorial(@RequestBody Group group, Principal principal) {
        try {
            Set<User> userSet = new HashSet<>();
            Optional<User> user = userRepository.findByUsername(principal.getName());
            userSet.add(user.get());
            Group group2 = new Group(group.getGroupName(), principal.getName());
            group2.setUsers(userSet);
            Group group1 = groupRepository.save(group2);
            return new ResponseEntity<>(group1, HttpStatus.CREATED);
        } catch (Exception e) {
            return new ResponseEntity<>(null, HttpStatus.INTERNAL_SERVER_ERROR);
        }
    }
}

核心问题分析 #

1. Group实体缺失与User的双向关联配置：User类中mappedBy="users"指定了Group是关联的维护端，但原Group类未定义对应的users关联字段及@ManyToMany配置，导致JPA无法正确处理中间表的插入逻辑。
2. 未确保关联的User处于持久化状态：虽然代码中查询了User，但需确认查询结果非空且为数据库中已存在的记录。

具体修改步骤 #

1. 完善Group实体的关联配置 #

在Group.java中添加与User的@ManyToMany关联字段及配置：

@Entity
@Table(name = "grp")
public class Group {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    @Column
    private String groupName;

    @Column
    private String createdBy;

    // 添加与User的ManyToMany关联，维护端配置
    @ManyToMany(fetch = FetchType.LAZY,
            cascade = {CascadeType.PERSIST, CascadeType.MERGE})
    @JoinTable(name = "user_group",
            joinColumns = @JoinColumn(name = "group_id"), // 当前实体（Group）在中间表的外键
            inverseJoinColumns = @JoinColumn(name = "user_id")) // 关联实体（User）在中间表的外键
    private Set<User> users = new HashSet<>();

    public Group(String groupName, String createdBy ) {
        this.groupName = groupName;
        this.createdBy = createdBy;
    }

    public Group() {
    }

    // Getter和Setter方法
    public Set<User> getUsers() {
        return users;
    }

    public void setUsers(Set<User> users) {
        this.users = users;
    }
}

2. 优化Controller逻辑，确保关联有效性 #

修改GroupController.java中的创建方法，增加User存在性校验，同时可选维护双向关联的内存对象一致性：

@PostMapping("/group")
public ResponseEntity<Group> createTutorial(@RequestBody Group group, Principal principal) {
    try {
        Optional<User> userOpt = userRepository.findByUsername(principal.getName());
        // 校验User是否存在
        if (userOpt.isEmpty()) {
            return new ResponseEntity<>(null, HttpStatus.NOT_FOUND);
        }
        User user = userOpt.get();
        
        Group newGroup = new Group(group.getGroupName(), principal.getName());
        Set<User> userSet = new HashSet<>();
        userSet.add(user);
        newGroup.setUsers(userSet);
        
        // 可选：维护双向关联，避免内存中对象状态不一致
        user.getGroups().add(newGroup);
        
        Group savedGroup = groupRepository.save(newGroup);
        return new ResponseEntity<>(savedGroup, HttpStatus.CREATED);
    } catch (Exception e) {
        e.printStackTrace();
        return new ResponseEntity<>(null, HttpStatus.INTERNAL_SERVER_ERROR);
    }
}

说明 #

• 维护端（Group）的@JoinTable配置明确了中间表名称及外键字段，JPA会在保存Group时自动将关联的User ID插入user_group表。
• 双向关联中，仅维护端的操作会同步到数据库，但同时更新关联双方的集合可以保证内存中对象的状态一致性。

内容的提问来源于stack exchange，提问作者Saurabh Kumar Singh