Pageable support for Neo4j version 4.0

user_2433323 0
Viewed 335

With the new 4.0 release of Neo4J a number of deprecated features have been removed, most notably the old {parameter} reference. If you have a Neo4jRepository with a Pageable query and upgrade your Neo4j to version 4.0+ you will get the following exception:

The old parameter syntax `{param}` is no longer supported. Please use `$param` instead (line 3, column 15 (offset: 168))
"return o SKIP {sdnSkip} LIMIT {sdnLimit}"

I'm interested to know if the Spring Data Neo4J team is aware of this and working to fix the issue. And also if they plan to support both styles of parameter referencing, or only $param going forward.

The only possible workaround today is to avoid Pageableand specify SKIP and LIMIT explicitly in queries.

/Klaus

spring-data-neo4j
2 Answers

Thanks to you mentioning this, we created https://jira.spring.io/browse/DATAGRAPH-1300 and this will get fixed with the next (service) releases.

Most of the heavy lifting gets done by Neo4j Object Graph Mapper. This includes creating queries. There are some places in Spring Data Neo4j we have not yet updated that create queries by themself and pass those on to the OGM.

user_26504360

It will be part of next week‘s Spring Data Moore SR 6. Since the Spring Boot starter is part of the Spring Boot releases, you need to manually upgrade Spring Data until there is an updated starter.

user_26504360
Related