OneToOne实体映射删除操作不起作用

Question

我有一个组成员表，该表与一对一关系中的用户表相关，当我尝试从组成员表中删除记录时，什么也不会发生。p>我的Groups表

public class Groups implements Serializable {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;
    @NotBlank
    @Column(unique = true)
    private String groupName;
    @OneToMany(fetch = FetchType.LAZY, orphanRemoval = false, mappedBy = "group")
    private List<GroupMembers> members;
}

Group Members表

public class GroupMembers implements Serializable {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;
    @ManyToOne(fetch = FetchType.LAZY)
    @JoinColumn(name = "group_id", nullable = false)
    private Groups group;
    @OneToOne
    @JoinColumn(name = "user_id", nullable = false)
    private User user;
}

Users表

public class User implements Serializable {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;
    private String firstName;
    @OneToOne(fetch = FetchType.LAZY, mappedBy = "commutersInfo", cascade = CascadeType.ALL, orphanRemoval = true)
    private GroupMembers groupMembers;
}

当我尝试以下内容删除记录时，什么都没有发生

groupsMembersRepository.delete(groupsMembersRepository.findByUserEmail(email));

没有错误，控制台中没有调试信息，它不会从数据库中删除记录

Answer 1

出于某种原因，JPA无法运行我的删除命令，当我执行此 spring.jpa.show-sql=true时，我看到所有选择的查询，JPA不运行我的删除查询，我不知道为什么，但是我会像一些解释。

最终我不得不使用此

@Modifying
    @Query(value = "DELETE FROM `group_members` WHERE `commuters_info_id` = ?1", nativeQuery = true)
    public void deleteByCommutersInfoEmail(long id);