Spring Boot Hibernate主键兼复合外键映射失败问题排查

问题根源分析 #

报错的核心原因有两个：

• 嵌入主键类TicketTypeCompositeKey中包含了@ManyToOne实体关联，违反JPA规范（复合主键只能由基本类型、可嵌入类型或主键类组成，不能包含实体引用）。
• AttendeeEvent中@JoinColumn的referencedColumnName使用了错误的路径格式（id.ticketTypeId），JPA无法识别这种嵌套属性路径，需要直接指向目标表的数据库列名。

修复步骤 #

1. 修正TicketTypeCompositeKey嵌入主键类 #

将实体关联替换为基本类型，确保复合主键仅包含可持久化的基本值：

@Embeddable
@EqualsAndHashCode
public class TicketTypeCompositeKey implements Serializable {
    // JPA要求必须提供无参构造函数
    public TicketTypeCompositeKey() {}

    public TicketTypeCompositeKey(int eventId, short ticketTypeId) {
        this.eventId = eventId;
        this.ticketTypeId = ticketTypeId;
    }

    @Column(name = "event_id")
    private int eventId;

    @Column(name = "ticket_type_id")
    private short ticketTypeId;

    // 生成getter和setter方法
    public int getEventId() { return eventId; }
    public void setEventId(int eventId) { this.eventId = eventId; }
    public short getTicketTypeId() { return ticketTypeId; }
    public void setTicketTypeId(short ticketTypeId) { this.ticketTypeId = ticketTypeId; }
}

2. 调整TicketType实体类 #

单独添加Event关联字段，与主键中的eventId映射到同一数据库列，并设置insertable=false和updatable=false避免字段更新冲突：

@Entity
@Table(name = "Ticket_Type")
public class TicketType {
    @Id
    private TicketTypeCompositeKey id;

    @ManyToOne(fetch = FetchType.LAZY)
    @JoinColumn(name = "event_id", insertable = false, updatable = false)
    private Event event;

    @Column(name = "name")
    @Size(min = 1, max = 15)
    private String name;

    @Column(name = "price")
    private int price;

    @Column(name = "total_ticket_quantity")
    private int totalTicketQuantity;

    @Column(name = "number_remaining")
    private int numberRemaining;

    @OneToMany(mappedBy = "ticketType", fetch = FetchType.LAZY)
    private List<AttendeeEvent> ticketBuyers;

    // 生成getter、setter和无参构造函数
}

3. 修正AttendeeEvent中的TicketType关联 #

调整@JoinColumns的referencedColumnName直接指向Ticket_Type表的数据库列名，并对event_id列设置insertable=false和updatable=false（因为它是当前实体主键的一部分）：

@Entity
@Table(name = "Attendee_Event")
@Data
public class AttendeeEvent {
    @Id
    private AttendeeEventCompositeKey id;

    @Column(name = "ticket_number")
    private int ticketNumber;

    @ManyToOne(fetch = FetchType.EAGER)
    @JoinColumns({
            @JoinColumn(name = "ticket_type", referencedColumnName = "ticket_type_id"),
            @JoinColumn(name = "event_id", referencedColumnName = "event_id", insertable = false, updatable = false)
    })
    private TicketType ticketType;
}

4. 确保AttendeeEventCompositeKey正确定义 #

主键类需包含person_id和event_id两个基本类型字段：

@Embeddable
@EqualsAndHashCode
public class AttendeeEventCompositeKey implements Serializable {
    public AttendeeEventCompositeKey() {}

    public AttendeeEventCompositeKey(String personId, int eventId) {
        this.personId = personId;
        this.eventId = eventId;
    }

    @Column(name = "person_id")
    private String personId;

    @Column(name = "event_id")
    private int eventId;

    // 生成getter和setter方法
}

验证 #

修改完成后，重启应用，spring.jpa.hibernate.ddl-auto=validate将通过数据库结构校验，复合外键关联即可正常工作。

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