Hibernate忽略左连接结果，重复查询关联实体问题解决

我有一个简单的Field实体，需要通过关联查询加载子Selector实体，代码实现如下：

@Entity
public class Field implements Serializable {
    @Id
    private Long id;

    @NotNull
    private Long userId;

    private String selectorId;

    // ......

    @JoinColumns({
            @JoinColumn(name = "userId", referencedColumnName = "userId", insertable = false, updatable = false),
            @JoinColumn(name = "selectorId", referencedColumnName = "selectorId", insertable = false, updatable = false)
    })
    @ManyToOne
    @Fetch(FetchMode.JOIN)
    private Selector selector;
}

Hibernate生成了包含左外连接的SQL语句，看起来正常：

SELECT field0_.id AS id1_25_0_,
       -- ... 省略冗余字段 ...
       selector1_.id AS id1_54_1_,
       selector1_.selector_id AS selector4_54_1_,
       selector1_.user_id AS user_i5_54_1_,
       selector1_.url AS url6_54_1_
FROM field field0_
         LEFT OUTER JOIN selector selector1_
                         ON field0_.user_id = selector1_.user_id AND field0_.selector_id = selector1_.selector_id
WHERE field0_.id=?;

但执行该查询后，Hibernate会立即为每个Field再次执行查询Selector实体的SQL：

SELECT selector0_.id AS id1_54_0_,
       selector0_.selector_id AS selector4_54_0_,
       selector0_.user_id AS user_i5_54_0_,
       selector0_.url AS url6_54_0_
FROM selector selector0_
WHERE selector0_.user_id=?
  AND selector0_.selector_id=?;

Selector应该已在首次查询中通过连接加载完成，请问如何阻止第二次SQL执行？

出现这种N+1查询问题，通常是Hibernate无法正确识别已加载的关联实体或映射配置存在疏漏，可通过以下方式解决：

1. 确保Selector实体主键映射正确 #

如果Selector使用userId+selectorId作为复合主键，必须正确配置复合主键类，让Hibernate能通过主键识别已加载的实体：

@Entity
public class Selector implements Serializable {
    @EmbeddedId
    private SelectorId id;

    private String url;

    // 复合主键类
    @Embeddable
    public static class SelectorId implements Serializable {
        private Long userId;
        private String selectorId;

        // 必须实现equals和hashCode方法
        @Override
        public boolean equals(Object o) {
            if (this == o) return true;
            if (o == null || getClass() != o.getClass()) return false;
            SelectorId that = (SelectorId) o;
            return Objects.equals(userId, that.userId) && Objects.equals(selectorId, that.selectorId);
        }

        @Override
        public int hashCode() {
            return Objects.hash(userId, selectorId);
        }
    }
}

同时调整Field中的关联映射，与复合主键对应：

@ManyToOne(fetch = FetchType.JOIN)
@JoinColumns({
        @JoinColumn(name = "userId", referencedColumnName = "userId", insertable = false, updatable = false),
        @JoinColumn(name = "selectorId", referencedColumnName = "selectorId", insertable = false, updatable = false)
})
private Selector selector;

2. 显式指定fetch = FetchType.JOIN #

在@ManyToOne注解上补充JPA标准的fetch = FetchType.JOIN配置，配合Hibernate的@Fetch(FetchMode.JOIN)，确保强制执行连接加载：

@ManyToOne(fetch = FetchType.JOIN)
@Fetch(FetchMode.JOIN)
@JoinColumns({
        @JoinColumn(name = "userId", referencedColumnName = "userId", insertable = false, updatable = false),
        @JoinColumn(name = "selectorId", referencedColumnName = "selectorId", insertable = false, updatable = false)
})
private Selector selector;

3. 自定义查询时添加JOIN FETCH #

如果使用自定义JPQL查询Field，必须显式添加JOIN FETCH来关联Selector，否则即使实体配置了连接加载，仍可能触发延迟加载：

SELECT f FROM Field f JOIN FETCH f.selector WHERE f.id = ?1

4. 排查二级缓存干扰 #

如果项目启用了Hibernate二级缓存，可临时禁用缓存测试，或检查Selector实体的缓存配置是否正确，避免因缓存未命中导致重复查询。

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