HQL ERROR: Path expected for join

by 
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.

More Related Contents:

  1. What causes “java.lang.IllegalStateException: Neither BindingResult nor plain target object for bean name ‘command’ available as request attribute”?
  2. @RequestParam vs @PathVariable
  3. Spring Security : Multiple HTTP Config not working
  4. Redirect to an external URL from controller action in Spring MVC
  5. Difference between @Valid and @Validated in Spring
  6. Spring Boot Multiple Datasource
  7. Spring Boot configure and use two data sources
  8. Increase HTTP Post maxPostSize in Spring Boot
  9. java.lang.NoSuchMethodError: javax.servlet.ServletContext.getContextPath()Ljava/lang/String;
  10. Spring MVC type conversion : PropertyEditor or Converter?
  11. More than one fragment with the name [spring_web] was found. This is not legal with relative ordering
  12. What to return if Spring MVC controller method doesn’t return value?
  13. Spring Boot JSP 404
  14. Spring Boot with redirecting with single page angular2
  15. Jackson 2.0 with Spring 3.1
  16. Redirect in Spring MVC
  17. Annotation Configuration Replacement for mvc:resources – Spring
  18. UTF-8 encoding problem in Spring MVC
  19. Spring MVC – AngularJS – File Upload – org.apache.commons.fileupload.FileUploadException
  20. How to add bean instance at runtime in spring WebApplicationContext?
  21. Configure ViewResolver with Spring Boot and annotations gives No mapping found for HTTP request with URI error
  22. Refreshing static content with Spring MVC and Boot
  23. Is it possible to have empty RequestParam values use the defaultValue?
  24. how to send an array in url request
  25. Spring 3.0 making JSON response using jackson message converter
  26. Spring MVC 4: “application/json” Content Type is not being set correctly
  27. Unable to get a generic ResponseEntity where T is a generic class “SomeClass”
  28. Trigger 404 in Spring-MVC controller?
  29. Spring MVC PATCH method: partial updates
  30. Logging response body (HTML) from HttpServletResponse using Spring MVC HandlerInterceptorAdapter

Leave a Comment