Neo4j - unable to craete a relationship using cypher in java

Question

I am failing to execute the cipher query through java while creating a relationship. It is not throwing any error, but no relationships are created. Tried with other cipher query to return a node, which is returning perfectly. But unable to figure-out the reason for relationships not being created.

Here goes my code:

public static void addrelation(String node1, String node2, int cocr) {
        try (Transaction tx = graphdb.beginTx();
                Result result = graphdb.execute("MATCH(a{word:\"" + node1
                        + "\"}),(b{word:\"" + node2 + "\"})"
                        + "CREATE a-[r:coocr{val:" + cocr + "}]->(b)"
                        + "CREATE a<-[s:coocr{val:" + cocr + "}]-(b)"
                        + "RETURN r,s")) {
                }
            }

As an aside you should use parameters for performance, security, and to avoid string concatenation headaches: http://neo4j.com/docs/stable/cypher-parameters.html — Brian Underwood, Oct 19 '15 at 12:41

score 1 · Answer 1 · answered Oct 19 '15 at 14:10

Adding tx.success() line made changes into the database.

    public static void addrelation(String node1, String node2, int cocr) {
            try (Transaction tx = graphdb.beginTx();
                    Result result = graphdb.execute("MATCH(a{word:\"" + node1
                            + "\"}),(b{word:\"" + node2 + "\"})"
                            + "CREATE a-[r:coocr{val:" + cocr + "}]->(b)"
                            + "CREATE a<-[s:coocr{val:" + cocr + "}]-(b)"
                            + "RETURN r,s")) {

   //Adding this line resolved the issue.                 
                           tx.success();

                    }
                }

score 0 · Answer 2 · answered Oct 19 '15 at 12:42

0

Is your MATCH matching anything? If not it won't created the relationships and will return successfully. Maybe remove the two CREATE lines and RETURN a, b to see.

answered Oct 19 '15 at 12:42

Brian Underwood

10,746
1
22
34

Yes, Match is matching with those two words. The same query is running fine without java. – Jack Daniel Oct 19 '15 at 13:34
Match returning two nodes when I return a,b instead of relation's like this {b=Node[183], a=Node[221]} @Brain Underwood – Jack Daniel Oct 19 '15 at 13:44
1

Maybe you need to commit your transaction. Java's not my strong suit, sorry ;) – Brian Underwood Oct 19 '15 at 13:51
Yes, commited my transaction and the changes affected. Thanks @Brain Underwood – Jack Daniel Oct 19 '15 at 14:08

Neo4j - unable to craete a relationship using cypher in java

2 Answers2