如何避免Hibernate查询单个Block时关联其他子表？

从图中可见，Apple Block、Banana Block、Cat Block和Dog Block这些独立区块均外键关联至Block Reference Table，该表又关联Effective Date Table，最终指向Block Definition Table。

以下是我的代码：

@Getter
@Setter
@Entity
@NoArgsConstructor
@AllArgsConstructor
@Table(name = "Block_Reference_Table", schema = "mySchema", catalog = "myCatelog")
public class BlockReference extends AuditableEntity<Long> implements java.io.Serializable {
  @GeneratedValue(strategy = GenerationType.IDENTITY)
  @Id
  @Column(name = "block_ref_table_id", nullable = false)
  private Long blockReferenceTableId;

  @OneToOne(cascade = CascadeType.ALL)
  @JoinColumn(name = "ref_to_effective_date_table")
  private EffectiveDateTable effectiveDate;

  @OneToOne(mappedBy = "BlockReference", cascade = CascadeType.ALL, fetch = FetchType.LAZY)
  private AppleBlock appleBlock;

  @OneToOne(mappedBy = "BlockReference", cascade = CascadeType.ALL, fetch = FetchType.LAZY)
  private BananaBlock bananaBlock;

  @OneToOne(mappedBy = "BlockReference", cascade = CascadeType.ALL, fetch = FetchType.LAZY)
  private CatBlock catBlock; 

  @OneToOne(mappedBy = "BlockReference", cascade = CascadeType.ALL, fetch = FetchType.LAZY)
  private DogBlock dogBlock;
}

我希望根据生效日期（Effective Date）查询单个Block，但目前遇到的问题是Hibernate会查询所有其他子表。请问该如何避免这种情况？

我的需求是：当查询Apple Block时，不触发Banana Block、Cat Block和Dog Block的查询；当查询Banana Block时，不触发Apple Block、Cat Block和Dog Block的查询，以此类推。

1. 修复@OneToOne懒加载配置 #

Hibernate对@OneToOne懒加载有特殊限制：默认optional=false会被判定为非空关联，强制立即加载；子实体主键依赖父实体时也会触发全加载。你需要：

• 给每个@OneToOne关联添加optional = true，明确告知Hibernate该关联可能为空：

@OneToOne(mappedBy = "blockReference", cascade = CascadeType.ALL, fetch = FetchType.LAZY, optional = true)
private AppleBlock appleBlock;

• 修正关联字段名：将mappedBy = "BlockReference"改为小写blockReference（对应子实体中的字段名，符合Java命名规范）

2. 用动态查询精准获取目标数据 #

查询时直接指定需要加载的Block和生效日期，避免拉取无关关联。例如查询AppleBlock：

// JPQL示例
String jpql = "SELECT br.appleBlock, br.effectiveDate FROM BlockReference br " +
              "WHERE br.effectiveDate.startDate <= CURRENT_DATE " +
              "AND br.effectiveDate.endDate >= CURRENT_DATE";
List<Object[]> results = entityManager.createQuery(jpql).getResultList();

for (Object[] result : results) {
    AppleBlock targetBlock = (AppleBlock) result[0];
    EffectiveDateTable date = (EffectiveDateTable) result[1];
    // 业务处理逻辑
}

这种方式只会查询指定的字段和关联，完全不会触发其他子表的查询。

3. 用实体图控制加载范围 #

定义针对不同Block的实体图，查询时指定使用该图，仅加载需要的关联：
首先在BlockReference实体上定义实体图：

@NamedEntityGraph(
    name = "BlockReference.withAppleBlock",
    attributeNodes = {
        @NamedAttributeNode("effectiveDate"),
        @NamedAttributeNode("appleBlock")
    }
)
@NamedEntityGraph(
    name = "BlockReference.withBananaBlock",
    attributeNodes = {
        @NamedAttributeNode("effectiveDate"),
        @NamedAttributeNode("bananaBlock")
    }
)
// 其余实体注解...
public class BlockReference extends AuditableEntity<Long> implements java.io.Serializable {
    // 字段定义...
}

查询时指定实体图：

// 查询AppleBlock场景
EntityGraph<?> graph = entityManager.getEntityGraph("BlockReference.withAppleBlock");
List<BlockReference> references = entityManager.createQuery(
    "SELECT br FROM BlockReference br WHERE br.effectiveDate.startDate <= CURRENT_DATE AND br.effectiveDate.endDate >= CURRENT_DATE",
    BlockReference.class
)
.setHint("javax.persistence.loadgraph", graph)
.getResultList();

此时Hibernate只会加载实体图中指定的effectiveDate和appleBlock，其他子Block不会被查询。

4. 可选：调整关联类型为@ManyToOne #

如果业务上允许每个子Block仅关联一个BlockReference，可将子实体中的关联改为@ManyToOne(fetch = FetchType.LAZY)，这种关联的懒加载行为更稳定：
在AppleBlock中：

@ManyToOne(fetch = FetchType.LAZY)
@JoinColumn(name = "block_ref_table_id")
private BlockReference blockReference;

然后BlockReference中的关联保持@OneToOne(mappedBy = "blockReference", ...)即可，Hibernate不会强制加载其他无关关联。

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