背景
- 问题描述
使用Jpa hsql直接进行分页查询,查询失败
- 报错error
Caused by: java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: order near line 1, column 14 [select count(order) from xxx.xxx.DataFlow]
- 问题位置
@Query(value = "from DataFlow order by timestamp")
Page<DataFlow> listByPage(Pageable pageable);
- 解决方法
给表加别名
@Query(value = "from DataFlow t order by t.timestamp")
Page<DataFlow> listByPage(Pageable pageable);
- 原因
暂时还没有细看,简单记录,后续再补充