CODEWITHSUNDEEP
neo4jneo4j-shell
peleitor
peleitor

Reputation: 469

neo4j-shell example of running a Cypher script

I need to run a Cypher query against a Neo4J database, from a command line (for batch scheduling purposes).

When I run this:

./neo4j-shell -file /usr/share/neo4j/scripts/query.cypher -path /usr/share/neo4j/neo4j-community-3.1.1/data/databases/graph.db

I get this error:

ERROR (-v for expanded information):
        Error starting org.neo4j.kernel.impl.factory.GraphDatabaseFacadeFactory, /usr/share/neo4j/neo4j-community-3.1.1/data/databases/graph.db

There is a running Neo4J instance on that database (localhost:7474). I need the script to perform queries against it.

NOTE: this is a split of the original question, for the sake of tidiness.

Upvotes: 2

Views: 6314

Answers (2)

spanishgum
spanishgum

Reputation: 1052

Okay I just spun up a fresh instance of Neo4j-community-3.1.1 today and ran into the exact same problem. Note that I had already created a database using the bulk import tool, so one might need to make a directory for a database (mkdir data/databases/graph.db) before using a shell.

I believe your problem might be that you have an instance of Neo4j process running against the database you are trying to access.

For me, shutting down Neo4j, and then starting the shell with an explicit path worked:

cd /path/to/neo4j-community-3.1.1/
bin/neo4j stop ## assuming it is already running (may need a port specifier)
bin/neo4j-shell -path data/databases/graph.db

For some reason I thought you could have both the shell and the server running, but apparently that is not the case. Hopefully someone will correct me if I am wrong.

Upvotes: 3

cybersam
cybersam

Reputation: 66999

To execute (one or more) Cypher statements from a file while the neo4j server is running, you can use the APOC procedure apoc.cypher.runFile(file or url).

Since you mention "batch scheduling", the Job management and periodic execution APOC procedures may be helpful. Those procedures could, in turn, execute calls to apoc.cypher.runFile.

Upvotes: 3

Related Questions