dijkstra function of orientdb is not working with tinkerpop API

Question

The below code is not giving the correct result, am I doing something wrong..?

OrientGraph graph = factory.getTx();

for (OrientVertex v : (Iterable<OrientVertex>) graph.command(
                new OCommandSQL("SELECT dijkstra(#97:1334, #97:1335, 'calculated_length') FROM STRUCTURE")).execute()) {
                      System.out.println("Path " + (ORID)v.getId());
                    }

When I execute the query directly, I am getting correct result. Thanks.

What version of orientDb are you using ? – Alessandro Rota Sep 01 '16 at 09:40 — Alessandro Rota, Sep 01 '16 at 09:40
orientdb-community-2.2.7 – Chinnadurai_V Sep 01 '16 at 09:42 — Chinnadurai_V, Sep 01 '16 at 09:42

score 3 · Accepted Answer · answered Sep 01 '16 at 10:06

I used this code and it worked

String query = "select expand(dijkstra) from (SELECT dijkstra(#21:0, #24:0, 'calculated_length') FROM STRUCTURE limit 1)";
Iterable<OrientVertex> it = g.command( new OCommandSQL(query)).execute();
for (OrientVertex v : it) { 
    System.out.println("Path " + (ORID)v.getId());     
}

Hope it helps

dijkstra function of orientdb is not working with tinkerpop API

1 Answers1