neo4j - CypherQuery returns empty result in JavaEmbedded, but correct result in Neoclipse -
i have strange problem cypher query. query works fine in neoclipse , returns correct result. in java embedded mode result empty. can't figure out problem. there query character limit in java embedded or similar?
here cypher query:
start typenode6=node(6) , containernode=node(9) , typenode35=node(35) , typenode15=node(15) , typenode18=node(18) , typenode33=node(33) match (node6)-[:type]->(typenode6) , (containernode)-[:contains*]->(node6) , (node35)-[:type]->(typenode35) , (node6)-[:`http://www.test.test/types/s3/media#actors`]->(node35) , (node15)-[:type]->(typenode15) , (node35)-[:`http://www.test.test/types/s3/media#impersonatedby`]->(node15) , (node18)-[:type]->(typenode18) , (node15)-[:`http://www.test.test/types/common#namedby`]->(node18) , (node33)-[:type]->(typenode33) , (node6)-[:`http://www.test.test/types/s3/media#runtime`]->(node33) node6.`http://www.test.test/types/s3/media#releaseyear`! = 1988 , node18.`http://www.test.test/types/common#firstname`! = 'robert' , node18.`http://www.test.test/types/common#lastname`! = 'davi' , node33.`http://www.test.test/types/common#intvalue`! = 131 return node6";
here java test-class:
@test public void queryexecute() { executionresult result, result2; executionengine engine; string query = "start typenode6=node(6) ,containernode=node(9) ,typenode35=node(35) ,typenode15=node(15) ,typenode18=node(18) match (node6)-[:type]->(typenode6) ,(containernode)-[:contains*]->(node6) ,(node35)-[:type]->(typenode35) , (node6)-[:`http://www.test.test/types/s3/media#actors`]->(node35) ,(node15)-[:type]->(typenode15) , (node35)-[:`http://www.test.test/types/s3/media#impersonatedby`]->(node15) ,(node18)-[:type]->(typenode18) , (node15)-[:`http://www.test.test/types/common#namedby`]->(node18) node18.`http://www.test.test/types/common#firstname`! = 'robert' , node18.`http://www.test.test/types/common#lastname`! = 'davi' return node6"; string query2 = "start typenode6=node(6) ,containernode=node(9) ,typenode35=node(35) ,typenode15=node(15) ,typenode18=node(18) ,typenode33=node(33) match (node6)-[:type]->(typenode6) ,(containernode)-[:contains*]->(node6) ,(node35)-[:type]->(typenode35) , (node6)-[:`http://www.test.test/types/s3/media#actors`]->(node35) ,(node15)-[:type]->(typenode15) , (node35)-[:`http://www.test.test/types/s3/media#impersonatedby`]->(node15) ,(node18)-[:type]->(typenode18) , (node15)-[:`http://www.test.test/types/common#namedby`]->(node18) ,(node33)-[:type]->(typenode33) , (node6)-[:`http://www.test.test/types/s3/media#runtime`]->(node33) node6.`http://www.test.test/types/s3/media#releaseyear`! = 1988 , node18.`http://www.test.test/types/common#firstname`! = 'robert' , node18.`http://www.test.test/types/common#lastname`! = 'davi' , node33.`http://www.test.test/types/common#intvalue`! = 131 return node6"; engine = new executionengine(svrinstance.getneographdb()); result = engine.execute(query); result2 = engine.execute(query2); assert.assertnotnull(result); system.out.println("============== cypher query test =============="); system.out.println("uncomplicated: "); system.out.println(result.tostring()); system.out.println("complicated: "); system.out.println(result2.tostring()); system.out.println("============== cypher query test =============="); }
and output java console:
============== cypher query test ============== uncomplicated: +---------------------------------------------------------------------------------------------------------------------------------------------------+ | node6 | +---------------------------------------------------------------------------------------------------------------------------------------------------+ | node[7]{http://www.test.test/types/common#id:"movie_1",http://www.test.test/types/s3/media#releaseyear:1988,type:"instance",instanceid:"movie_1"} | +---------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row 138 ms complicated: +-------+ | node6 | +-------+ +-------+ 0 row 4 ms ============== cypher query test ==============
both queries (in java) should return same result (at least in neoclipse). difference "complicated query" got more "where" conditions.
by way queries generated dynamically java, shouldn't problem, because work in neoclipse. (and used same database location.)
thank helping! greetings max
so, figure out, both queries work fine neo4jserver version 1.7.2. must wrong version 1.8.2!!