How to connect to a locally installed neo4j server using Java

Question

I'm new to Neo4J and couldn't find the answer to my question despite my hours of googling.

So far, I have been following the tutorials and now I have a basic understanding of how/when to use Neo4j. Now, I am about to start modifying my hello-world code and connect to a Neo4J server locally installed on my machine, accessible via http://127.0.0.1:7474.

Original connection (using an embedded database):

GraphDatabaseService gdb = new EmbeddedGraphDatabase("c:\\helloworld\\data\\graph.db");

The question is is there anyway to modify this line to connect to my "server" database in c:\neo4j\data\graph.db instead? The server is running currently as a windows service and I can view its database using the web admin tool. At this time, I am not interested in using the REST API since the server and the client app are running on the same machine.

I feel like I'm missing something obvious here...

score 5 · Answer 1 · answered Jan 31 '13 at 23:46

I couldn't find any example code on the wrapper so here is what I ended up doing.

EmbeddedGraphDatabase graphDb = new EmbeddedGraphDatabase("C:\\neo4j\\data\\graph.db");
WrappingNeoServerBootstrapper srv = new WrappingNeoServerBootstrapper(graphDb);
srv.start();
try {
    while (System.in.read() != 46) {
    // wait until we send a period (.) to kill the server
    }
} catch (IOException e) {}
srv.stop();

This will allow you to visit localhost:7474 and see the webadmin tool just like running the server but also continue with your usual Java code (write your own simple API using the input stream to read commands).

DNA · Accepted Answer · 2014-12-23T15:56:34.337

The windows service exposes the REST interface.

The embedded interface is entirely different - you point it at the database file structure and then access it via Java method calls.

If you have both running at the same time, pointing at the same data, then bad things might happen (actually, I think it detects this and prevents it). So you probably need to stop the service and/or backup the data from this instance to another directory. Then edit your EmbeddedGraphDatabase constructor to point to this directory.

The manual describes the embedded Java interface, as you've probably seen. See also this section which briefly mentions the rather nice web-based management interface.

Thanks, your suggestion of stopping the service and pointing my EmbeddedGrapDatabase contructor to the "server" db directory did the trick. — PFrank, Feb 21 '12 at 22:57

score 1 · Answer 3 · answered Jun 09 '14 at 08:24

1

I know its an old post, but still adding my answer. You can use Neo4jConnection. Sample Code

Neo4jConnection connect=null;
connect = new Driver(). connect(DB_URL, new Properties());
ResultSet resultSet=connect.createStatement().executeQuery("YOUR QUERY")

answered Jun 09 '14 at 08:24

praDeepu

21
3

Where did you find this Neo4jConnection class? – mattdeboard Jun 21 '14 at 05:05
have a look [here](http://docs.neo4j.org/chunked/milestone/tutorials-java-embedded-setup.html) – user299791 Jun 27 '14 at 11:17
Do you mean I need to add whole server libraries ? Can I use Node and Relationship in this configuration ? – Pavel Niedoba Jan 19 '15 at 22:52

score 1 · Answer 4 · edited May 23 '17 at 12:13

Ended using Jersey Client's HttpBasicAuthFilter

Your parameters should be something like:

            public static final String DATABASE_ENDPOINT = "http://localhost:7474/db/data";

            public static final String DATABASE_USERNAME = "neo4j";

            public static final String DATABASE_PASSWORD = "3c0a0a6ea1sdsdsdsdsdsdsdsdf2a94d";

        private String callRest(String query) {
                final String cypherUrl = ENDPOINT + "/cypher";
                Client c = Client.create();
                c.addFilter(new HTTPBasicAuthFilter(USERNAME, PASSWORD));
                WebResource resource = c.resource(cypherUrl);
                String request = "{\"query\":\"" + query + "\"}";
                ClientResponse response = resource.accept(MediaType.APPLICATION_JSON)
                        .type(MediaType.APPLICATION_JSON).entity(request)
                        .post(ClientResponse.class);
                String object = response.getEntity(String.class);
                response.close();
                return object;
        }

Latest Jersey client can be found by adding this to your mvn pom if its not already in your dependency tree.

            <dependency>
                <groupId>com.sun.jersey</groupId>
                <artifactId>jersey-client</artifactId>
                <version>1.18.3</version>
            </dependency>

See: https://stackoverflow.com/posts/28303766

How to connect to a locally installed neo4j server using Java

4 Answers4

Linked