Java - Failed to execute AQL query

Question

How to fix AQL syntax error? I'm trying to create an edge using a query, but the following error appears:

Failed to execute query. Response: 400, Error: 1501 - AQL: syntax error, unexpected end of query string near '@edges' at position 1:57 (while parsing)

The code used to execute the query:

try {

 String query = "INSERT { _from:TurmaA._teste2, _to:TurmaA._testepedro } IN @edges";
 Map<String, Object> bindVars = new MapBuilder().put("edges", nome2).get();
 ArangoCursor<BaseDocument> cursor = arangoDB.db(dbName).query(query, bindVars, 
null, BaseDocument.class);

cursor.forEachRemaining(aDocument -> {
  System.out.println("Key: " + aDocument.getKey());
 });
} catch (ArangoDBException e) {
 System.err.println("Failed to execute query. " + e.getMessage());
}

dothebart · Accepted Answer · 2019-02-26 13:46:06Z

1

Please note that collection bind variables have to be prefixed by two @@.

So your code example can probably be easily fixed like this:


try {

 String query = "INSERT { _from:TurmaA._teste2, _to:TurmaA._testepedro } IN @@edges";
 Map<String, Object> bindVars = new MapBuilder().put("@edges", nome2).get();
 ArangoCursor<BaseDocument> cursor = arangoDB.db(dbName).query(query, bindVars, 
null, BaseDocument.class);

cursor.forEachRemaining(aDocument -> {
  System.out.println("Key: " + aDocument.getKey());
 });
} catch (ArangoDBException e) {
 System.err.println("Failed to execute query. " + e.getMessage());
}

answered Feb 26, 2019 at 13:46

dothebart

6,07718 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Pedro Over a year ago

thanks! that did work, but now i have another problem... it says collection or view not found: testepedro but i checked and it is in the right collection

dothebart Over a year ago

Please try it out on the webinterface, It offers more easy means of debugging. Please note that its case sensitive.

kiran kumar Over a year ago

very helpfull I was trying to find this

Collectives™ on Stack Overflow

Java - Failed to execute AQL query

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related