java - org.hibernate.hql.internal.ast.QuerySyntaxException : Path expected for join exeption

Question

我正在尝试使用 hibernate 编写 jpql 查询。我在@Repository 中有这样的查询

@Query(value = "select p from Product p inner join ProductsUser pu on p.prosuctId = pu.productId where pu.userId = :uuid")

但是我得到一个异常(exception)

Caused by: java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: Path expected for join! [select p from com.example.api.dto.ProductDto p inner join ProductsUsersDto pu on p.prosuctId = pu.productId where pu.userId = :uuid]

Answer 1

您不需要指定 JOIN ... ON 子句，因为它已在实体类中配置。所以查询有点简单，像这样:

@Query("select p from Product p join p.productsUser pu where pu.userId = :uuid")