如何在JPA中让ElementCollection引用另一ElementCollection的外键？

要实现让addressDetails引用addresses表的复合外键，你需要解决两个核心问题：为addresses集合的元素生成唯一标识符列，以及正确配置Map类型集合的键关联。以下是针对Hibernate 5.4.21版本的具体解决方案：

问题根源分析 #

你之前尝试的@CollectionTable(joinColumns = {...})只负责关联当前集合表到父实体的外键，而Map的键（Address）关联到addresses表的逻辑需要通过@MapKeyJoinColumns来配置。另外，默认情况下，@Embeddable类型的ElementCollection不会生成单独的元素ID列，addresses表的主键是父实体ID + Address的所有属性（比如street），这不符合你期望的sub1_id + address_id的复合外键结构。

解决方案步骤 #

1. 为addresses集合添加元素ID列 #

使用Hibernate专有的@CollectionId注解，为addresses表生成address_id列，这样addresses表的主键就会变成sub1_id + address_id（子类表对应的外键列），满足你期望的外键引用结构。

2. 配置addressDetails的键关联和外约束 #

通过@MapKeyJoinColumns指定addressDetails表关联addresses表的复合列，同时配置外键约束和级联删除。

修改后的完整代码 #

package demo;
import java.util.Map;
import java.util.Set;
import javax.persistence.*;
import org.hibernate.annotations.CollectionId;
import org.hibernate.annotations.GenericGenerator;
import org.hibernate.annotations.OnDelete;
import org.hibernate.annotations.OnDeleteAction;
import org.hibernate.annotations.Type;

@Embeddable
class Address {
    String street;
}

@Embeddable
class AddressDetails {
    byte[] photo;
}

@MappedSuperclass
abstract class User {
    @Id
    Long id;

    @ElementCollection(fetch = FetchType.EAGER)
    @CollectionTable(name = "{entity_name}_addresses") // Hibernate会自动替换{entity_name}为子类名（如sub1、sub2）
    @CollectionId(
        columns = @Column(name = "address_id"),
        generator = "address_seq",
        type = @Type(type = "long")
    )
    @GenericGenerator(name = "address_seq", strategy = "sequence")
    Set<Address> addresses;

    @ElementCollection
    @CollectionTable(
        name = "{entity_name}_address_details",
        foreignKey = @ForeignKey(
            name = "FK_{entity_name}_address_address_details",
            foreignKeyDefinition = "FOREIGN KEY ({entity_name}_id, address_id) REFERENCES {entity_name}_addresses ON DELETE CASCADE"
        )
    )
    @MapKeyJoinColumns({
        @MapKeyJoinColumn(name = "{entity_name}_id", referencedColumnName = "{entity_name}_id"),
        @MapKeyJoinColumn(name = "address_id", referencedColumnName = "address_id")
    })
    @OnDelete(action = OnDeleteAction.CASCADE) // 确保级联删除生效
    Map<Address, AddressDetails> addressDetails;
}

@Entity
class Sub1 extends User {}

@Entity
class Sub2 extends User {}

关键注解说明 #

• @CollectionId：Hibernate专有注解，为ElementCollection的元素生成唯一标识符列（address_id），让addresses表拥有sub1_id + address_id的复合主键。
• @MapKeyJoinColumns：指定Map的键（Address）对应的表（addresses）的关联列，这里关联了父实体ID和address_id两个列，实现复合外键引用。
• @ForeignKey：自定义外键约束的名称和定义，确保生成你期望的ON DELETE CASCADE规则。
• @OnDelete：辅助确保级联删除行为在Hibernate层面生效（配合数据库级别的外键约束双重保障）。

验证DDL生成 #

配置完成后，Hibernate会生成你期望的DDL语句：

ALTER TABLE sub1_address_details ADD CONSTRAINT FK_sub1_address_address_details FOREIGN KEY (sub1_id, address_id) REFERENCES sub1_addresses ON DELETE CASCADE;

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