Red Hat Summit 红帽全球峰会支持控制台（Console）开发人员开始试用联系人

此内容没有您所选择的语言版本。

14.3. Associations and joins

You can also assign aliases to associated entities or to elements of a collection of values using a join. For example: 
from Cat as cat
    inner join cat.mate as mate
    left outer join cat.kittens as kitten
Copy to Clipboard Toggle word wrap 
from Cat as cat left join cat.mate.kittens as kittens
Copy to Clipboard Toggle word wrap 
from Formula form full join form.parameter param
Copy to Clipboard Toggle word wrap
The supported join types are borrowed from ANSI SQL:
  • inner join
  • left outer join
  • right outer join
  • full join (not usually useful)
The inner join, left outer join and right outer join constructs may be abbreviated. 
from Cat as cat
    join cat.mate as mate
    left join cat.kittens as kitten
Copy to Clipboard Toggle word wrap
You may supply extra join conditions using the HQL with keyword. 
from Cat as cat
    left join cat.kittens as kitten
        with kitten.bodyWeight > 10.0
Copy to Clipboard Toggle word wrap
A "fetch" join allows associations or collections of values to be initialized along with their parent objects using a single select. This is particularly useful in the case of a collection. It effectively overrides the outer join and lazy declarations of the mapping file for associations and collections. See Section 19.1, “Fetching strategies” for more information. 
from Cat as cat
    inner join fetch cat.mate
    left join fetch cat.kittens
Copy to Clipboard Toggle word wrap
A fetch join does not usually need to assign an alias, because the associated objects should not be used in the where clause (or any other clause). The associated objects are also not returned directly in the query results. Instead, they may be accessed via the parent object. The only reason you might need an alias is if you are recursively join fetching a further collection: 
from Cat as cat
    inner join fetch cat.mate
    left join fetch cat.kittens child
    left join fetch child.kittens
Copy to Clipboard Toggle word wrap

Important

The fetch construct cannot be used in queries called using iterate() (though scroll() can be used). Fetch should not be used together with setMaxResults() or setFirstResult(), as these operations are based on the result rows which usually contain duplicates for eager collection fetching, hence, the number of rows is not what you would expect. Fetch should also not be used together with impromptu with condition. It is possible to create a cartesian product by join fetching more than one collection in a query, so take care in this case. Join fetching multiple collection roles can produce unexpected results for bag mappings, so user discretion is advised when formulating queries in this case. Finally, note that full join fetch and right join fetch are not meaningful.
If you are using property-level lazy fetching (with bytecode instrumentation), it is possible to force Hibernate to fetch the lazy properties in the first query immediately using fetch all properties. 
from Document fetch all properties order by name
Copy to Clipboard Toggle word wrap 
from Document doc fetch all properties where lower(doc.name) like '%cats%'
Copy to Clipboard Toggle word wrap
返回顶部
Red Hat logoGithubredditYoutubeTwitter

学习

尝试、购买和销售

社区

关于红帽文档

通过我们的产品和服务，以及可以信赖的内容，帮助红帽用户创新并实现他们的目标。 了解我们当前的更新.

让开源更具包容性

红帽致力于替换我们的代码、文档和 Web 属性中存在问题的语言。欲了解更多详情，请参阅红帽博客.

關於紅帽

我们提供强化的解决方案，使企业能够更轻松地跨平台和环境（从核心数据中心到网络边缘）工作。

Theme

© 2025 Red Hat