具有order by的jpql复杂查询

Question

我有2个实体（这只是一个简化的例子，不是真正的实体）：

@Entity
@Table(name = "entityA")
public class EntityA {
    @ManyToOne(cascade = CascadeType.ALL)
    EntityB start;
    @ManyToOne(cascade = CascadeType.ALL)
    EntityB stop;
    ...
}


@Entity
@Table(name = "entityB")
public class EntityB {
    public String name; 
    ...
}

当我尝试使用order By编写查询时，Hibernate崩溃：

select t.start from EntityA t
where 
...
order by t.start.name

SELECT DISTINCT entityB1_.uuid AS uuid2021_, ..
  entityB1_.name               AS name2021_,
...
FROM entityA entityA0_
INNER JOIN entityB entityB1_
ON entityA0_.stop_uuid=entityB1_.uuid,
  entityB entityB2_,
  entityB entityB3_
WHERE entityA0_.start_uuid    =entityB2_.uuid
AND entityA0_.start_uuid=entityB3_.uuid
AND entityA0_.qn        =?
AND entityB2_.lifeCycle            ='READY'
AND entityB3_.lifeCycle            ='READY'
ORDER BY entityB2_.name

原因：java.sql.SqlSyntaxerRoreXception：ORA-01791:不是选定的表达式

    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)

Answer 1

试试这样的方法，看看这是否停止了Hibernate不必要地添加连接

SELECT s FROM EntityA t JOIN t.start s ORDER BY s.name