Spring data neo4j SDN 6

Question

In SDN 6, @Deapth annotation is removed, and also in the latest 6.0.3, support for bi-directional relationship is added. Earlier it was giving StackOverflow while persisting a 2-way relation between the same node entities. For eg A-follows->B and B-follows->A. Now, this type of relationship is possible but when you load the Node with find* methods, it gets overly slow because of the nested relation, and also Depth is removed so it loads the entire relationship. Do we have any workaround on this?

question from:https://stackoverflow.com/questions/65941539/spring-data-neo4j-sdn-6

Answer 1

I'm facing the exact same issue. Apparently, there is no workaround that I've found so far. The query keeps running and eventually fails with Outofmemory error.

The issue happens because of the self reference. This appears to be a defect since the self-reference nodes appear to be the ideal use case for graphs whereas they break while trying to find the nodes. Here is my query that is generated by SDN:

MATCH (n:Part) WHERE n.sku = "SKU000009"  WITH n, id(n) AS __internalNeo4jId__ RETURN n{.allowCustomerReviews, __nodeLabels__: labels(n), __internalNeo4jId__: id(n), __paths__: [p = (n)-[:SOLD_BY|GROUPED_WITH|PART_OF|FITS_INTO]->()-[:SOLD_BY|GROUPED_WITH|PART_OF|FITS_INTO|MANUFACTURED_BY*0..]-()-[:MANUFACTURED_BY*0..1]->()-[*0..]-() | p]}