I am attempting to use Neo4j's JDBC Driver with an Embedded Neo4j. I've copied the jars, configured the build path, wrote the code to create the GraphDatabaseService as the limited instructions dictate. I am lost, however, on how to get the JDBC to point to the embedded (and running, hopefully) server.
The URL I specify for the JDBC is "jdbc:neo4j:simulationDb?debug=true". How and where do I set this for the embedded server?
If you're connecting to the embedded database, then your JDBC url needs to look like:
jdbc:neo4j:file:/home/user/neo/graph.db where /home/user/neo/graph.db is the path to your Neo4j database.
Then get a java.sql.Connection to it using
Connection con = DriverManager.getConnection("jdbc:neo4j:file:/home/user/neo/graph.db");
There isn't any such thing as the Embedded Server- it's either embedded in your application(as per the link you supplied), or server mode where Neo4j runs as a standalone server.
If you're running in server mode, your JDBC URL looks like jdbc:neo4j://localhost:7474/ (if your Neo4j server runs on localhost:7474) and you obtain a Connection the same way.
There's some sample code using the JDBC driver here https://github.com/luanne/flavorwocky-jdbc-migrate/blob/master/src/com/flavorwocky/migrate/MigrateDb.java
Actually...I just figured it out. For posterity's sake, I'll post the code snippet here.
simulationDb = new GraphDatabaseFactory()
.newEmbeddedDatabaseBuilder(DB_PATH)
.loadPropertiesFromFile(CONFIG_PATH)
.newGraphDatabase();
registerShutdownHook(simulationDb);
Class.forName(JDBC_DRIVER);
Properties props = new Properties();
props.put("simulationDb", simulationDb);
db = DriverManager.getConnection(URL, props);