JPA准则API-LEFT OUTER JOIN未填充@OneToMany列表

Question

这是我的实体：

public class Patrimony {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Long id;
@OneToMany(mappedBy = "patrimony")
@JsonManagedReference 
private
List<Patrpos> positions;
}

我的代码是：

CriteriaBuilder cb = manager.getCriteriaBuilder();
CriteriaQuery<Patrimony> cq = cb.createQuery(Patrimony.class);
Root<Patrimony> root = cq.from(Patrimony.class);
Join<Patrimony, UserProfile> userprofile = root.join(Patrimony_.userprofile);
Join<Patrimony, Patrpos> joinPatrpos = root.join(Patrimony_.positions, JoinType.LEFT);
root.fetch(Patrimony_.positions);
joinPatrpos.on(cb.equal(joinPatrpos.get(Patrpos_.dtPatrpos), dateproc.minusDays(1)));
cq.select(root);
TypedQuery<Patrimony> query = manager.createQuery(cq);
List<Patrimony> list = query.getResultList();

正在生成的查询看起来不错，它类似于：

select
patrimony0_.id as id1_10_0_,
positions3_.id as id1_11_1_,
patrimony0_.category_id as categor15_10_0_,
patrimony0_.description as descript2_10_0_,
patrimony0_.vl_valuation_start as vl_valu14_10_0_,
positions3_.dt_patrpos as dt_patrp2_11_1_,
positions3_.vl_patrpos as vl_patrp6_11_1_,
from
patrimony patrimony0_ 
inner join
userprofile userprofil1_ 
on patrimony0_.userprofile_id=userprofil1_.id 
left outer join
patrpos positions2_ 
on patrimony0_.id=positions2_.patrimony_id 
and (
positions2_.dt_patrpos=?
) 
inner join
patrpos positions3_ 
on patrimony0_.id=positions3_.patrimony_id 
where userprofil1_.id=161

查询似乎返回了我需要的所有数据，实体Patrimony返回时所有数据都正常，除了"List positions"属性，该属性始终为null。

谢谢。

Answer 1

回顾单元测试，我注意到在插入测试数据后没有调用flush((和clear((。在调用查询之前，我添加了flush和clear，所有实体都被正确填充。

谢谢大家的评论。