Cannot use native queries with dynamic sorting and/or pagination in method public abstract org

最新推荐文章于 2021-03-27 14:57:05 发布

Lazyafei

最新推荐文章于 2021-03-27 14:57:05 发布

阅读量1.2k

点赞数

分类专栏： # JPA

本文链接：https://blog.csdn.net/tfstone/article/details/114689511

版权

JPA 专栏收录该内容

8 篇文章 1 订阅

订阅专栏

参考：https://stackoverflow.com/questions/38349930/spring-data-and-native-query-with-pagination

在sql后添加 \n-- #pageable\n 即可。

    @Query(nativeQuery = true, value = "select a.* from organization a where a.tenant_id=:tenantId and a.is_delete='0' " +
            "and a.company_id=:companyId and a.parent_id=:parentId and name!=:name " +
            "and (type is null or (type!=:type1 and type!=:type2)) \n-- #pageable\n"
    )
    Page<Organization> findAllByTenantIdAndCompanyIdAndParentIdAndNameNotAndTypeNotAndTypeNot(@Param("tenantId")Integer tenantId, @Param("companyId")Integer companyId, @Param("parentId")Integer parentId, @Param("name")String name, @Param("type1")String type1,@Param("type2")String type2, @Param("pageable")Pageable pageable);