SDN Repository Pagination not ready for Neo4J 4.0

p.suettner · March 4, 2020, 9:16am

Hi,

we are using spring-boot-starter-data-neo4j-2.2.4.RELEASE (spring-data-neo4j-5.2.4.RELEASE) and Neo4J 4.0 database server.

Using custom queries (@Query annotation) with pagination in repositories is currently causing an error, because SDN generates a query using the old parameter syntax for binding the SKIP and LIMIT parameters.

See:

github.com

spring-projects/spring-data-neo4j/blob/5.2.x/spring-data-neo4j/src/main/java/org/springframework/data/neo4j/repository/query/Query.java#L42


      
          * sort to the string based queries as OGM does not support pagination and sort on those.
          *
          * @author Nicolas Mervaillie
          * @author Michael J. Simons
          * @author Ihor Dziuba
          */
          public class Query {
          
          
	private static final String SKIP_PARAM = "sdnSkip";
          	private static final String LIMIT_PARAM = "sdnLimit";
          	private static final String SKIP_LIMIT = " SKIP $" + SKIP_PARAM + " LIMIT $" + LIMIT_PARAM;
          	private static final String LIMIT = "LIMIT $" + LIMIT_PARAM;
          	private static final String ORDER_BY_CLAUSE = " ORDER BY %s";
          
          
	private Filters filters;
          	private String cypherQuery;
          	private Map<String, Object> parameters;
          	private @Nullable String countQuery;
          	private @Nullable Integer optionalLimit;
          	private @Nullable Sort optionalSort;

Is this a known issue and are there any plans to fix this in upcoming releases?

Greetings,

Peter

gerrit.meier · March 4, 2020, 12:29pm

Thanks for reporting this. It came up a few days ago on StackOverflow.

We will fix in every supported Spring Data version (5.1, 5.2 and the upcoming 5.3).
There is a Jira ticket or this pull request that you can track.

Topic		Replies	Views
Pagination and Sorting with Custom Queries Spring Data Neo4j & Neo4j-OGM	3	3782	September 26, 2018
Is there any document/code sample talking about pagination of query relationship in SDN 6? Spring Data Neo4j & Neo4j-OGM	1	222	April 22, 2022
From the SDN team: Usage survey Spring Data Neo4j & Neo4j-OGM	0	826	September 6, 2018
SDN findAll performance and populating entities at depth > 1 Spring Data Neo4j & Neo4j-OGM sdn	12	2171	May 16, 2022
Spring Data Neo4j - Page returning all the contents instead of size Spring Data Neo4j & Neo4j-OGM	6	2276	February 2, 2020

SDN Repository Pagination not ready for Neo4J 4.0

Related topics