I'm not sure if this is a Neo4j question or a Spring Data question. I'm fairly new to Neo4j, so I just want to make sure I'm doing things right. I'm using spring-data-neo4j:4.0.0.RELEASE with a neo4j-community-2.3.1 DB instance.
The situation is that I am getting more nodes that I'm expecting back from DB queries. If I create a graph consisting of 3 different types of nodes:
(NodeA)-[:NodeAIncludesNodeB]->(NodeB)-[:NodeBIncludesNodeC]->(NodeC)
and then I run a query to get a single NodeA node I receive the entire graph from NodeA to NodeC in the query results.
It seems as though I'm getting cached results instead of live results from the DB. The reason I say this is because if I call session.context.clear() after the creation of the graph, the query no longer returns the entire graph including the NodeC's, but it does still return the single NodeA along with all of its NodeB's.
I found this quote in the Spring Data Neo4J documentation (http://docs.spring.io/spring-data/neo4j/docs/current/reference/html/):
Note, however, that the Session does not ever return cached objects so there’s no risk of getting stale data on load; it always hits the database.
I created a small example application to illustrate:
Entity classes:
@NodeEntity
public class NodeA extends BaseNode {
private String name;
@Relationship(type = "NodeAIncludesNodeB", direction = "OUTGOING")
private Set<NodeB> bNodes;
public NodeA() {}
public NodeA(String name) {
this.name = name;
}
//getters, setter, equals and hashcode omitted for brevity
}
@NodeEntity
public class NodeB extends BaseNode {
private String name;
@Relationship(type = "NodeBIncludesNodeC", direction = "OUTGOING")
private Set<NodeC> cNodes;
public NodeB() {}
public NodeB(String name) {
this.name = name;
}
}
@NodeEntity
public class NodeC extends BaseNode {
private String name;
public NodeC() {}
public NodeC(String name) {
this.name = name;
}
}
Repository:
public interface NodeARepository extends GraphRepository<NodeA> {
public NodeA findByName(String name);
@Query("MATCH (n:NodeA) WHERE n.name = {nodeName} RETURN n")
public NodeA findByNameQuery(@Param("nodeName") String name);
@Query("MATCH (n:NodeA)-[r:NodeAIncludesNodeB]->() WHERE n.name = {nodeName} RETURN r")
public NodeA findByNameWithBNodes(@Param("nodeName") String name);
@Query("MATCH (n:NodeA)-[r1:NodeAIncludesNodeB]->()-[r2:NodeBIncludesNodeC]->() WHERE n.name = {nodeName} RETURN r1,r2")
public NodeA findByNameWithBAndCNodes(@Param("nodeName") String name);
}
Test Application:
@SpringBootApplication
public class ScratchApp implements CommandLineRunner {
@Autowired
NodeARepository nodeARep;
@Autowired
Session session;
@SuppressWarnings("unused")
public static void main(String[] args) {
ApplicationContext ctx = SpringApplication.run(ScratchApp.class, args);
}
@Override
public void run(String...strings) {
ObjectMapper mapper = new ObjectMapper();
NodeA nodeA = new NodeA("NodeA 1");
NodeB nodeB1 = new NodeB("NodeB 1");
NodeC nodeC1 = new NodeC("NodeC 1");
NodeC nodeC2 = new NodeC("NodeC 2");
Set<NodeC> b1CNodes = new HashSet<NodeC>();
b1CNodes.add(nodeC1);
b1CNodes.add(nodeC2);
nodeB1.setcNodes(b1CNodes);
NodeB nodeB2 = new NodeB("NodeB 2");
NodeC nodeC3 = new NodeC("NodeC 3");
NodeC nodeC4 = new NodeC("NodeC 4");
Set<NodeC> b2CNodes = new HashSet<NodeC>();
b2CNodes.add(nodeC3);
b2CNodes.add(nodeC4);
nodeB2.setcNodes(b2CNodes);
Set<NodeB> aBNodes = new HashSet<NodeB>();
aBNodes.add(nodeB1);
aBNodes.add(nodeB2);
nodeA.setbNodes(aBNodes);
nodeARep.save(nodeA);
// ((Neo4jSession)session).context().clear();
try {
Iterable<NodeA> allNodeAs = nodeARep.findAll();
System.out.println(mapper.writeValueAsString(allNodeAs));
// ((Neo4jSession)session).context().clear();
Iterable<NodeA> allNodeAs2 = nodeARep.findAll();
System.out.println(mapper.writeValueAsString(allNodeAs2));
NodeA oneNodeA = nodeARep.findByName("NodeA 1");
System.out.println(mapper.writeValueAsString(oneNodeA));
NodeA oneNodeA2 = nodeARep.findByNameQuery("NodeA 1");
System.out.println(mapper.writeValueAsString(oneNodeA2));
NodeA oneNodeA3 = session.load(NodeA.class, oneNodeA.getId());
System.out.println(mapper.writeValueAsString(oneNodeA3));
// ((Neo4jSession)session).context().clear();
NodeA oneNodeA4 = nodeARep.findByNameWithBNodes("NodeA 1");
System.out.println(mapper.writeValueAsString(oneNodeA4));
NodeA oneNodeA5 = nodeARep.findByNameWithBAndCNodes("NodeA 1");
System.out.println(mapper.writeValueAsString(oneNodeA5));
} catch (JsonProcessingException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
Here are the results from the test program:
[{"id":20154,"name":"NodeA 1","bNodes":[{"id":20160,"name":"NodeB 1","cNodes":[{"id":20155,"name":"NodeC 1"},{"id":20156,"name":"NodeC 2"}]},{"id":20157,"name":"NodeB 2","cNodes":[{"id":20158,"name":"NodeC 3"},{"id":20159,"name":"NodeC 4"}]}]}]
[{"id":20154,"name":"NodeA 1","bNodes":[{"id":20160,"name":"NodeB 1","cNodes":[{"id":20155,"name":"NodeC 1"},{"id":20156,"name":"NodeC 2"}]},{"id":20157,"name":"NodeB 2","cNodes":[{"id":20158,"name":"NodeC 3"},{"id":20159,"name":"NodeC 4"}]}]}]
{"id":20154,"name":"NodeA 1","bNodes":[{"id":20160,"name":"NodeB 1","cNodes":[{"id":20155,"name":"NodeC 1"},{"id":20156,"name":"NodeC 2"}]},{"id":20157,"name":"NodeB 2","cNodes":[{"id":20158,"name":"NodeC 3"},{"id":20159,"name":"NodeC 4"}]}]}
{"id":20154,"name":"NodeA 1","bNodes":[{"id":20160,"name":"NodeB 1","cNodes":[{"id":20155,"name":"NodeC 1"},{"id":20156,"name":"NodeC 2"}]},{"id":20157,"name":"NodeB 2","cNodes":[{"id":20158,"name":"NodeC 3"},{"id":20159,"name":"NodeC 4"}]}]}
{"id":20154,"name":"NodeA 1","bNodes":[{"id":20160,"name":"NodeB 1","cNodes":[{"id":20155,"name":"NodeC 1"},{"id":20156,"name":"NodeC 2"}]},{"id":20157,"name":"NodeB 2","cNodes":[{"id":20158,"name":"NodeC 3"},{"id":20159,"name":"NodeC 4"}]}]}
{"id":20154,"name":"NodeA 1","bNodes":[{"id":20157,"name":"NodeB 2","cNodes":[{"id":20158,"name":"NodeC 3"},{"id":20159,"name":"NodeC 4"}]},{"id":20160,"name":"NodeB 1","cNodes":[{"id":20155,"name":"NodeC 1"},{"id":20156,"name":"NodeC 2"}]}]}
{"id":20154,"name":"NodeA 1","bNodes":[{"id":20157,"name":"NodeB 2","cNodes":[{"id":20159,"name":"NodeC 4"},{"id":20158,"name":"NodeC 3"}]},{"id":20160,"name":"NodeB 1","cNodes":[{"id":20156,"name":"NodeC 2"},{"id":20155,"name":"NodeC 1"}]}]}
Note that every query returns the same result, even though I'm only requesting a single node in all but the last two queries.
If I uncomment the session.context().clear() calls here are the results:
[{"id":20161,"name":"NodeA 1","bNodes":[{"id":20164,"name":"NodeB 2","cNodes":null},{"id":20167,"name":"NodeB 1","cNodes":null}]}]
[{"id":20161,"name":"NodeA 1","bNodes":[{"id":20164,"name":"NodeB 2","cNodes":null},{"id":20167,"name":"NodeB 1","cNodes":null}]}]
{"id":20161,"name":"NodeA 1","bNodes":[{"id":20164,"name":"NodeB 2","cNodes":null},{"id":20167,"name":"NodeB 1","cNodes":null}]}
{"id":20161,"name":"NodeA 1","bNodes":[{"id":20164,"name":"NodeB 2","cNodes":null},{"id":20167,"name":"NodeB 1","cNodes":null}]}
{"id":20161,"name":"NodeA 1","bNodes":[{"id":20164,"name":"NodeB 2","cNodes":null},{"id":20167,"name":"NodeB 1","cNodes":null}]}
{"id":20161,"name":"NodeA 1","bNodes":[{"id":20164,"name":"NodeB 2","cNodes":null},{"id":20167,"name":"NodeB 1","cNodes":null}]}
{"id":20161,"name":"NodeA 1","bNodes":[{"id":20164,"name":"NodeB 2","cNodes":[{"id":20165,"name":"NodeC 3"},{"id":20166,"name":"NodeC 4"}]},{"id":20167,"name":"NodeB 1","cNodes":[{"id":20163,"name":"NodeC 2"},{"id":20162,"name":"NodeC 1"}]}]}
Note that the entire graph is only returned when I request it explicitly, however I am still receiving the NodeB's with the NodeA.
I need to populate a response to a REST call and I'd rather not have to strip extraneous objects so they don't appear in the REST response. Will I have to make the call to session.context().clear() after every DB access so that I don't receive "cached" nodes? Is there a better way to make the call to receive a more fine-grained result? Can I turn off the "caching" altogether?
