无法使用JOIN查询实体 [英] Cannot query entities using JOIN

问题描述

我正在努力弄清 HQL 并在IntelliJ IDEA的持久性"窗口中运行它.

I am trying to get my head around HQL and run it inside the Persistence window of IntelliJ IDEA.

这就是问题:我可以运行像这样的简单查询:

Here's the thing: I can run simple queries like these:

hql> SELECT offer FROM OfferEntit offer;
hql> SELECT offer FROM OfferEntit offer WHERE offer.id = 1L; 

但是如果我添加类似JOIN的内容:

but if I add something like a JOIN:

hql> SELECT offer FROM OfferEntit offer 
     JOIN offer.owner AS owner WHERE owner.id = 1L;

我得到一个空结果.总是.不管我做什么.我不知道为什么.

I get an empty result. Always. No matter what I do. I have no idea why..

也

• 我检查了这些记录是否存在-是的
• 我没有收到任何错误日志

推荐答案

您可以尝试使用左联接还是联接提取

Can you try with left join or join fetch

SELECT offer FROM OfferEntit offer 
 LEFT JOIN offer.owner AS owner WHERE owner.id = 1L

---

SELECT offer FROM OfferEntit offer 
 JOIN FETCH offer.owner AS owner WHERE owner.id = 1L

这篇关于无法使用JOIN查询实体的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！