Hibernate实体映射问题：非实体类嵌套子列表的数据持久化

核心思路 #

把AnnouncementExternalIds标记为非持久化对象，让Announcement直接关联需要持久化的三个子列表对应的实体，绕过中间的AnnouncementExternalIds层级，既满足Jackson反序列化的需求，又符合Hibernate的数据库映射规则。

具体实现步骤 #

1. 标记AnnouncementExternalIds为非实体
   在AnnouncementExternalIds类上添加JPA的@Transient注解，明确告诉Hibernate这个类不需要映射到数据库：

   import javax.persistence.Transient;
   
   @Transient
   public class AnnouncementExternalIds {
       private List<AnnouncementCustomerID> announcementCustomerIDs;
       private List<AnnouncementOfficeID> announcementOfficeIDs;
       private List<AnnouncementPositionID> announcementPositionIDs;
       // 原有getter、setter方法保留
   }
   

2. 调整Announcement实体的映射关系
   在Announcement类中，移除对AnnouncementExternalIds的持久化关联，直接配置三个子列表的实体集合，并根据数据库表结构设置正确的关联规则：

   import javax.persistence.*;
   import java.util.List;
   
   @Entity
   @Table(name = "announcement")
   public class Announcement {
       @Id
       @GeneratedValue(strategy = GenerationType.IDENTITY)
       private Long id;
       // 原有其他持久化属性保留
   
       // 直接关联需要持久化的子列表，根据实际外键列名调整joinColumn
       @OneToMany(cascade = CascadeType.ALL, fetch = FetchType.LAZY)
       @JoinColumn(name = "announcement_id")
       private List<AnnouncementCustomerID> announcementCustomerIDs;
   
       @OneToMany(cascade = CascadeType.ALL, fetch = FetchType.LAZY)
       @JoinColumn(name = "announcement_id")
       private List<AnnouncementOfficeID> announcementOfficeIDs;
   
       @OneToMany(cascade = CascadeType.ALL, fetch = FetchType.LAZY)
       @JoinColumn(name = "announcement_id")
       private List<AnnouncementPositionID> announcementPositionIDs;
   
       // 保留AnnouncementExternalIds属性用于Jackson反序列化，标记为非持久化
       @Transient
       private AnnouncementExternalIds announcementExternalIDs;
   
       // 反序列化后同步数据到持久化集合
       @PostConstruct
       public void syncExternalData() {
           if (announcementExternalIDs != null) {
               this.announcementCustomerIDs = announcementExternalIDs.getAnnouncementCustomerIDs();
               this.announcementOfficeIDs = announcementExternalIDs.getAnnouncementOfficeIDs();
               this.announcementPositionIDs = announcementExternalIDs.getAnnouncementPositionIDs();
           }
       }
       // 原有getter、setter方法保留
   }
   

3. 验证子实体的映射配置
   确保AnnouncementCustomerID、AnnouncementOfficeID、AnnouncementPositionID三个类都正确添加了@Entity注解，配置了对应的数据表名称和主键字段，比如：

   @Entity
   @Table(name = "announcement_customer_id")
   public class AnnouncementCustomerID {
       @Id
       @GeneratedValue(strategy = GenerationType.IDENTITY)
       private Long id;
       // 其他属性及getter、setter
   }
   

简化方案（可选） #

如果不想保留AnnouncementExternalIds类，可以直接用Jackson的@JsonProperty注解，把JSON嵌套字段直接绑定到Announcement的持久化集合上，省去中间对象：

@OneToMany(cascade = CascadeType.ALL, fetch = FetchType.LAZY)
@JoinColumn(name = "announcement_id")
@JsonProperty("announcementExternalIDs.announcementCustomerIDs")
private List<AnnouncementCustomerID> announcementCustomerIDs;

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