The neo4j-jdbc's intro from swamyb4

Overview: Neo4j JDBC Driver

This is the official JDBC driver for Neo4j.

This driver was mainly developed by Larus BA, Italy, a certified consulting and integration solutions partner for Neo4j. Thank you so much for all your work.

Note	The previous JDBC driver for Neo4j 2.x was moved to the https://github.com/neo4j-contrib/neo4j-jdbc-2x repository.

Being a graph database, Neo4j is not serving data in a relational way and the exact purpose of this project is to allow projects that are using the classic JDBC connector in the relational paradigm to interact with Neo4j.

This driver supports various types of database transports:

through the Bolt protocol (3.0.X) using jdbc:neo4j:bolt://<host>:<port>/
through the HTTP protocol (2.X+) using jdbc:neo4j:http://<host>:<port>/

Going forward there will also be support for:

direct file connection
embedded connection

Maven dependency

For the all-in-one module supporting both Bolt and HTTP, you can simply use:

<dependency>
    <groupId>org.neo4j</groupId>
    <artifactId>neo4j-jdbc-driver</artifactId>
    <version>{neo4j-jdbc-version}</version>
</dependency>

If you only want one of the protocols, you can depend on its module:

<dependency>
    <groupId>org.neo4j</groupId>
    <artifactId>neo4j-jdbc-bolt</artifactId>
    <version>{neo4j-jdbc-version}</version>
</dependency>

<dependency>
    <groupId>org.neo4j</groupId>
    <artifactId>neo4j-jdbc-http</artifactId>
    <version>{neo4j-jdbc-version}</version>
</dependency>

Minimum viable snippet

Dependency declaration

org.neo4j:neo4j-jdbc-driver:3.0

Run Query

// Connecting
try (Connection con = DriverManager.getConnection("jdbc:neo4j:bolt://localhost", 'neo4j', password)) {

    // Querying
    String query = "MATCH (u:User)-[:FRIEND]-(f:User) WHERE u.name = {1} RETURN f.name, f.age";
    try (PreparedStatement stmt = con.prepareStatement(query)) {
        stmt.setString(1,"John");

        try (ResultSet rs = stmt.execute()) {
            while (rs.next()) {
                System.out.println("Friend: "+rs.getString("f.name")+" is "+rs.getInt("f.age"));
            }
        }
    }
}

Please note that the example above uses the try-with-resource blocks that automatically closes resources when the try block is exited.

Usage with Neo4j Server

Install a Neo4j 3.0.X server and start it with the Bolt protocol enabled
Connect with URLs in the form jdbc:neo4j:bolt://<host>:<port>/ (e.g. jdbc:neo4j:bolt://localhost/)
You can also use additional comma separated parameters in the URL for authentication, debug mode, SSL encryption and flattening e.g. jdbc:neo4j:bolt://localhost/?user=neo4j,password=xxxx,debug=true,noSsl,flatten=[-1,100,1000]
Add the JDBC driver dependency or jar file to your project
Get a connection from DriverManager
Execute queries and transactions using the Cypher graph query language

Flattening

As most JDBC clients and tools don’t support complex objects, the driver can flatten returned nodes and relationships by providing all their properties as individual columns with names like u.name,r.since if you just return a node u or relationship r.

This is enabled with the JDBC-URL parameter flatten=<rows>, where <rows> indicates how many rows are sampled to determine those columns. With -1 all rows are sampled and with any other value you determine the number of rows being looked at.

Building the driver yourself

First clone the repository.

This project is composed by the following modules:

Neo4j JDBC - the core module
Neo4j JDBC - Bolt - module supporting the Bolt protocol
Neo4j JDBC - HTTP - module supporting the HTTP protocol
Neo4j JDBC - Driver packaging - module to package all above modules

Run all unit tests & integration tests

mvn clean test

Run only integration tests

mvn clean test -Pintegration-test

Run performance tests

mvn clean test -Pperformance-test

Note	To run the performance test, you must have a Neo4j Server (3.0.X) running with the Bolt protocol enabled on port 7687 (default)

Release 3.0 Schedule

General Availability [RELEASED]

Extensive Tests with a variety of tools
Bug Fixes
Documentation
Better handling of credentials
Support for additional API methods
Explicit enabling of flatten=<rows> via JDBC URL

Release Candidate 1 [RELEASED]

Move to github.com/neo4j-contrib
Changed package to org.neo4j
Released to Neo4j’s maven repository
HTTP protocol module

Milestone 03 [RELEASED]

Batch processing
Bug fix
Neo4j Java Driver 1.0.1
Neo4j 3.0.1

License

The "Neo4j JDBC Driver" is licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License.

You may obtain a copy of the License at

https://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.

See the License for the specific language governing permissions and limitations under the License.

Thank you

We’d like to thank:

The core development team:

Alberto D’Este, Larus-BA - Software Developer
Marco Falcier, Larus-BA - Software Developer
Gianmarco Laggia, Larus-BA - Software Developer
Benoît Simard, Neo4j - Technical Consultant at Neo Technology

Contributors:

Ralf Becher, TiQ solutions - Qlik Luminary
Michael Vitz, InnoQ - Software Developer
Angelo Busato, Larus-BA - Software Developer
Enrico Marin, Larus-BA - Software Developer

Supporters:

Lorenzo Speranzoni, Larus-BA - Founder and CEO
Stefan Armbruster, Neo4j - Customer Success Engineer for EMEA
Michael Hunger, Neo4j - Caretaker Neo4j Community

swamyb4 / neo4j-jdbc Goto Github PK

neo4j-jdbc's Introduction

Overview: Neo4j JDBC Driver

Maven dependency

Minimum viable snippet

Usage with Neo4j Server

Flattening

Building the driver yourself

Release 3.0 Schedule

License

Thank you

Recommend Projects

React

Vue.js

Typescript

TensorFlow

Django

Laravel

D3

Recommend Topics

javascript

web

server

Machine learning

Visualization

Game

Recommend Org

Facebook

Microsoft

Google

Alibaba

D3

Tencent