Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

HQL ERROR: Path expected for join

I keep trying variations of this query and can't seem to make this happen. I've also referenced this post: Path Expected for Join! Nhibernate Error and can't seem to apply the same logic to my query. My User object has a UserGroup collection.

I understand that the query needs to reference entities within the object, but from what I'm seeing I am...

@NamedQuery(   name = "User.findByGroupId",   query =     "SELECT u FROM UserGroup ug " +     "INNER JOIN User u WHERE ug.group_id = :groupId ORDER BY u.lastname" ) 
like image 482
Webnet Avatar asked May 04 '12 12:05

Webnet


2 Answers

select u from UserGroup ug inner join ug.user u  where ug.group_id = :groupId  order by u.lastname 

As a named query:

@NamedQuery(   name = "User.findByGroupId",   query =     "SELECT u FROM UserGroup ug " +     "INNER JOIN ug.user u WHERE ug.group_id = :groupId ORDER BY u.lastname" ) 

Use paths in the HQL statement, from one entity to the other. See the Hibernate documentation on HQL and joins for details.

like image 77
JB Nizet Avatar answered Nov 13 '22 12:11

JB Nizet


You need to name the entity that holds the association to User. For example,

... INNER JOIN ug.user u ... 

That's the "path" the error message is complaining about -- path from UserGroup to User entity.

Hibernate relies on declarative JOINs, for which the join condition is declared in the mapping metadata. This is why it is impossible to construct the native SQL query without having the path.

like image 33
Marko Topolnik Avatar answered Nov 13 '22 10:11

Marko Topolnik