ON子句与Hibernate Query接口 [英] ON clause with Hibernate Query interface

问题描述

任何人都可以告诉我是什么原因。

Regards，

Raj

解决方案

HQL不支持 ... JOIN ... ON ... 语法，只能在 JOIN 上定义（ FROM Foo foo JOIN foo.bars bar ）。

如果您需要 JOIN 在任意条件下，你可以使用老式的形式 FROM A a，B b WHERE ax = by （尽管你不能外连接这种方式）。否则必须使用原生SQL查询。

另请参阅： $ b< li>第16章HQL：Hibernate查询语言

第18章Native SQL

I am getting HibernateQueryException,when i use On clause with Left Outer join.

Can anyone suggest me what is the cause.

Regards,

Raj

解决方案

HQL doesn't support ... JOIN ... ON ... syntax, you can JOIN only on defined relationships between entities (FROM Foo foo JOIN foo.bars bar).

If you need JOIN on arbitrary condition, you can use old-fashioned form FROM A a, B b WHERE a.x = b.y (though you can't make outer join this way). Otherwise have to use native SQL query.

See also:

• Chapter 16. HQL: The Hibernate Query Language
• Chapter 18. Native SQL

这篇关于ON子句与Hibernate Query接口的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！