Search code examples
resthttporientdb

SQL commands not available in Orientdb REST api

I am trying to POST commands to an Orientdb using the REST api. When I POST the following json:

{
"command" : "select * from system"
}

I get this response:

    {
      "errors": [
        {
          "reason": 500,
          "content": "com.orientechnologies.orient.core.command.OCommandExecutorNotFoundException: Cannot find a command executor for the command request: sql.{\n\"command\" : \"select from system\"\n}",
          "code": 500
        }
      ]

}

However, the command works on the url 

http://localhost:2480/command/demo1/sql/select * from system

but not in json.

Solution

  • It is possible from version 2.2 of OrientDb. Look the documentation http://orientdb.com/docs/2.1/OrientDB-REST.html#command