springboot整合neo4j分页查询报错MappingException: Expected paging query method to have a count query!

最新推荐文章于 2024-09-14 09:14:48 发布

emo哥老白

最新推荐文章于 2024-09-14 09:14:48 发布

阅读量342

点赞数 5

本文链接：https://blog.csdn.net/m0_54479027/article/details/141123702

版权

springboot 同时被 2 个专栏收录

2 篇文章 0 订阅

订阅专栏

neo4j

2 篇文章 0 订阅

订阅专栏

1.先看一下报错信息
在这里插入图片描述
2.我的dao层的代码是这么写的

@Repository
public interface DatasRepository extends Neo4jRepository<Datas, Long> {

    @Query(value = "MATCH (e:Datas) WHERE e.dbName = $dbName RETURN e ORDER BY e.dbName, e.name SKIP $skip LIMIT $limit")
    Page<Datas> findByDbName(@Param("dbName") String dbName, Pageable pageable);

}

3.一直提示我说需要一个count query，查了好多资料最后发现正确的写法是这样的：

@Repository
public interface DatasRepository extends Neo4jRepository<Datas, Long> {

    @Query(value = "MATCH (e:Datas) WHERE e.dbName = $dbName RETURN e ORDER BY e.dbName, e.name SKIP $skip LIMIT $limit",
            countQuery = "MATCH (e:Datas) WHERE e.dbName = $dbName RETURN count(e)")
    Page<Datas> findByDbName(@Param("dbName") String dbName, Pageable pageable);

}