Cannot access nodes created using java in neo4j database, neo4j-server.properties issues

Question

I am able to create nodes and relationships through Java on a Neo4j database. When I try to access the created nodes in the next run I get this error:

Exception in thread "main" org.neo4j.graphdb.NotFoundException: Node 27 not found

In webadmin interface the dashboard shows the number of nodes/relationships created through Java, but when I issue this query: START n=node(*) RETURN n; I get only 1 node in the ouput.

(FYI I have installed Ne04j in my windows machine(local) and using embedded database java code to create nodes.) Java code I used to connect to db:

final String dbpath = "C:\\neo4j-community-1.9.4\\data\\graph.db";      
GraphDatabaseService graphdb =  new GraphDatabaseFactory().newEmbeddedDatabase(dbpath);

The settings I have used in ne04j-server.properties are:

org.neo4j.server.database.location=/C:/neo4j-community-1.9.4/data/graph.db/
org.neo4j.server.webserver.https.keystore.location=data/keystore
org.neo4j.server.webadmin.rrdb.location=data/rrd
org.neo4j.server.webadmin.data.uri=/C:/neo4j-community-1.9.4/data/graph.db/
org.neo4j.server.webadmin.management.uri=/db/manage/

When I create node through Java the data/keystore file does not get populated, and only gets populated when creating a node through webadmin interface. Changing the path of keystore file to absolute path also did not work.

Can anybody point the mistake in this scenario, Thanks .

You seem to interact with the database both as embedded instance and as server. (Are you aware of the differences?) Forgetting about the server and its webadmin and configuration files for the moment, are you able to persist your data to an embedded instance and read it back? — jjaderberg
– jjaderberg, Commented Oct 7, 2013 at 10:51

Ranjith · Accepted Answer · 2013-10-08 06:59:32Z

2

The problem was the nodes created were not comitted. To commit the nodes we got to give finish() :

try{
Transaction tx = graphdb.beginTx();
final String dbpath = "/C:/neo4j-community-1.9.4/data/graph.db/";
GraphDatabaseService graphdb =  new GraphDatabaseFactory().newEmbeddedDatabase(dbpath);
Node n1 = graphdb.createNode();
n1.setProperty("type", "company");
n1.setProperty("location", "india");
....
...
}} catch(Exception e){
   tx.failure();
} finally {
   tx.success();
  **tx.finish();**
}

answered Oct 8, 2013 at 6:59

Ranjith

4756 silver badges17 bronze badges

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

1 Comment

Michael Hunger Over a year ago

You should probably move tx.success() before your catch, you don't want to call success in the exceptional case.

Dick Chesterwood · Accepted Answer · 2015-06-24 14:51:38Z

1

Ranjith's answer was correct until recently, but tx.finish() has now been deprecated.

tx.close(); is now the correct way to commit or rollback the transaction - it will do one or the other depending on whether you've previously called tx.success().

They changed this so the transaction is autocloseable in a try with resources block.

answered Jun 24, 2015 at 14:51

Dick Chesterwood

2,6692 gold badges25 silver badges33 bronze badges

Comments

Max De Marzi · Accepted Answer · 2013-10-06 06:42:29Z

0

Have you tried:

String dbpath = "C:/neo4j-community-1.9.4/data/graph.db";

answered Oct 6, 2013 at 6:42

Max De Marzi

1,1196 silver badges11 bronze badges

3 Comments

Ranjith Over a year ago

Thanks for your reply Max. Yes I tried it now and no luck, I guess the problem might be with these two properties: org.neo4j.server.webserver.https.keystore.location=data/keystore org.neo4j.server.webadmin.rrdb.location=data/rrd ..

Michael Hunger Over a year ago

Yes only set the org.neo4j.server.database.location property

Ranjith Over a year ago

By setting the org.neo4j.server.webadmin.data.uri property I do not see the nodes in webadmin, once I comment that and set only the org.neo4j.server.database.location the webadmin interface works neat. Thanks for your reply Micheal...

Collectives™ on Stack Overflow

Cannot access nodes created using java in neo4j database, neo4j-server.properties issues

3 Answers 3

1 Comment

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related