spring boot JPA IN子句不工作

Question

我在CrudRepository中有下面的API

public static final String getVendorOrder ="select new com.meha.ps.order.dto.VendorOrder(orderItem.vendorItemId"
        + ",order.orderId"
        + ",order.createTime"
        + ",order.modTime "
        + ",org.orgId"
        + ",org.orgType"
        + ") from Order order inner join order.OrderItem orderItem on order.orderId=orderItem.orderId"
        + " inner join Org org on org.orgId=orderItem.vendorId"
        + " where orderItem.vendorItemId in :vendorItemIds";

@Query(getVendorOrder)
List<VendorOrder> findVendorOrder(@Param("vendorItemIds") List<Integer> vendorItemIds);

启动时低于错误：

Caused by: java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: order near line 1, column 193 [select new com.meha.ps.order.dto.VendorOrder(orderItem.vendorItemId,order.orderId,order.createTime,order.modTime ,org.orgId,org.orgType) from com.meha.ps.order.entities.Order order inner join order.OrderItem orderItem on order.orderId=orderItem.orderId inner join Org org on org.orgId=orderItem.vendorId where orderItem.vendorItemId in :vendorItemIds]
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1679) ~[hibernate-entitymanager-5.0.11.Final.jar:5.0.11.Final]
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1602) ~[hibernate-entitymanager-5.0.11.Final.jar:5.0.11.Final]
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1608) ~[hibernate-entitymanager-5.0.11.Final.jar:5.0.11.Final]
at org.hibernate.jpa.spi.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:294) ~[hibernate-entitymanager-5.0.11.Final.jar:5.0.11.Final]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_65]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_65]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_65]
at java.lang.reflect.Method.invoke(Method.java:497) ~[na:1.8.0_65]
at org.springframework.orm.jpa.ExtendedEntityManagerCreator$ExtendedEntityManagerInvocationHandler.invoke(ExtendedEntityManagerCreator.java:347) ~[spring-orm-4.3.5.RELEASE.jar:4.3.5.RELEASE]
at com.sun.proxy.$Proxy114.createQuery(Unknown Source) ~[na:na]
at org.springframework.data.jpa.repository.query.SimpleJpaQuery.validateQuery(SimpleJpaQuery.java:86) ~[spring-data-jpa-1.10.6.RELEASE.jar:na]
... 95 common frames omitted

由以下原因引起：ounter.java:91QuerySyntaException：意外令牌：第1行193列附近的订单[选择新的inal.jarVdororder（orderIorg.hibernate.hql.internal.ast.ItemId，mpl.parseId，mpl.java:288Time，inal.jarTime，org.hibernate.hql.internal.ast.Id，mpl.doType）从com.meha.ps.order.entities.订单内连接订单。order.order上的OrderItem orderItem Id=orderItem.orderId内连接org.orgId=orderItem.vendorId上的OrderItem.vendorItemId in： vdorItemIds]在org.hibernate.hql.internal.ast.QuerySyntaException.convert（QuerySyntaException.java:74）~[hibernate-core-5.0.11。Final.jar： 5.0.11。最终]在org.hibernate.hql.internal.ast.ErrorCounter.throwQueryException（ErrorCorg.hibernate.hql.internal.ast.）~[hibernate-core-5.0.11。Fcom.meha.ps.order.dto.： 5.0.11。最终]在tem.vendorQueryTranslatorIorder.order（QueryTranslatorIorder.create）~[hibernate-core-5.0.11。Forder.mod： 5.0.11。最终]在org.orgQueryTranslatorIorg.org编译（QueryTransHQLQueryPlan. java： 115）~[hibernate-core-5.0.11。Final. jar：5.0.11。最终]在org. hibernate. Engine. query. spi。HQLQueryPlan。（HQLQueryPlan. java： 76）~[hibernate-core-5.0.11。最终. jar：5.0.11。最终]在org. hibernate. Engine. query. spi。QueryPlanCache. getHQLQueryPlan（QueryPlanCache. java： 150）~[hibernate-core-5.0.11。最终. jar：5.0.11。最终]在org. hibernate. interal。AbstractSessionInp. getHQLQueryPlan（AbstractSessionInp. java： 302）~[hibernate-core-5.0.11。最终. jar：5.0.11。最终]在org. hibernate. interal。Abstract

Answer 1

如果某些实体之间没有直接映射，那么我建议一直使用旧式连接（查询的其余部分似乎没有问题）：

select new com.meha.ps.order.dto.VendorOrder(orderItem.vendorItemId"
        + ",order.orderId"
        + ",order.createTime"
        + ",order.modTime "
        + ",org.orgId"
        + ",org.orgType"
        + ") from Order order, OrderItem orderItem, Org org       
           where order.orderId=orderItem.orderId"
        + " and org.orgId=orderItem.vendorId"
        + " and orderItem.vendorItemId in :vendorItemIds";