Spring Boot应用中实体关联表时的映射循环及一对一关联配置错误排查

咱们一步步拆解你遇到的两个问题：

一、@ManyToMany导致的StackOverflowError #

问题根源 #

你的实体是双向@ManyToMany关联，MapStruct自动生成的映射代码会陷入无限循环：

• 转换AdvisorEntity到AdvisorDTO时，会遍历关联的ContractEntity并转成ContractDTO
• 每个ContractDTO又会反过来遍历关联的AdvisorEntity转成AdvisorDTO
• 这个过程不断重复，最终耗尽栈内存抛出StackOverflowError

解决方案 #

有两种常用的修复方式：

1. 在Mapper中忽略反向关联字段

直接告诉MapStruct不要映射双向关联的反向部分，避免循环：

@Mapper
public interface AdvisorMapper {
    // 忽略ContractDTO中的advisors字段，打断循环
    @Mapping(target = "contracts.advisors", ignore = true)
    AdvisorDTO advisorEntityToAdvisorDTO(AdvisorEntity advisorEntity);
    
    AdvisorEntity advisorDTOToAdvisorEntity(AdvisorDTO advisorDto);
}

@Mapper
public interface ContractMapper {
    // 同理，忽略AdvisorDTO中的contracts字段
    @Mapping(target = "advisors.contracts", ignore = true)
    ContractDTO contractEntityToContractDTO(ContractEntity contractEntity);
    
    ContractEntity contractDTOToContractEntity(ContractDTO contractDto);
}

2. 调整DTO结构（更推荐）

让DTO只保留业务需要的单向关联，比如AdvisorDTO里用List<ContractSimpleDTO>，ContractSimpleDTO中不包含advisors字段，从根源上避免循环：

// 简化的ContractDTO，只保留必要字段
public class ContractSimpleDTO {
    private Long contractId;
    private String details;
    // 去掉advisors字段
    // getters and setters
}

@Mapper
public interface AdvisorMapper {
    AdvisorDTO advisorEntityToAdvisorDTO(AdvisorEntity advisorEntity);
    // 自动映射到简化的ContractSimpleDTO
    List<ContractSimpleDTO> contractEntityListToContractSimpleDTOList(List<ContractEntity> contracts);
}

二、@OneToOne关联的MappingException #

问题根源 #

错误提示Repeated column in mapping for entity: ContractEntity column: advisor_id，有两个核心问题：

1. 字段类型错误：ContractEntity中的advisor字段被定义为ContractEntity类型，应该是AdvisorEntity
2. 重复列映射：你同时用@Column(name = "ADVISOR_ID")和@JoinColumn(name = "ADVISOR_ID")映射同一个数据库列，Hibernate无法处理这种冲突

解决方案 #

根据你的业务场景（一个Advisor对应一个Contract），修正后的实体配置如下：

AdvisorEntity（双向关联）

@Entity
@Table(name = "M_Advisor")
public class AdvisorEntity {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "ADVISOR_ID")
    private Long advisorId;
    
    @Column(name = "FIRST_NAME")
    private String firstName;
    
    // mappedBy指向ContractEntity中的advisor字段，表示由对方维护关联关系
    @OneToOne(mappedBy = "advisor", cascade = CascadeType.ALL)
    private ContractEntity contract;
    
    // getters and setters
}

ContractEntity（修正后）

@Entity
@Table(name = "M_Contract")
public class ContractEntity {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "CONTRACT_ID")
    private Long contractId;
    
    // 去掉冗余的@Column(name = "ADVISOR_ID")，由@JoinColumn管理该列
    @Column(name = "DETAILS")
    private String details;
    
    // 关联AdvisorEntity，指定外键列ADVISOR_ID
    @OneToOne
    @JoinColumn(name = "ADVISOR_ID", referencedColumnName = "ADVISOR_ID")
    private AdvisorEntity advisor;
    
    // getters and setters
}

如果你的业务是共享主键（即Contract的ID和Advisor的ID完全一致），则需要调整为：

@Entity
@Table(name = "M_Contract")
public class ContractEntity {
    @Id
    @Column(name = "CONTRACT_ID")
    private Long contractId; // 主键与Advisor的ADVISOR_ID一致
    
    @Column(name = "DETAILS")
    private String details;
    
    // @MapsId表示当前实体的主键来自关联实体的主键
    @OneToOne
    @MapsId
    @JoinColumn(name = "CONTRACT_ID", referencedColumnName = "ADVISOR_ID")
    private AdvisorEntity advisor;
    
    // getters and setters
}

内容的提问来源于stack exchange，提问作者Billy Bolton