<commit_before>= Neo4j JDBC Driver Documentation
:toc: left
:toclevels: 2

include::../README.adoc[]



== Technical Reference

=== Usage Examples


=== The Bolt Driver

The Bolt driver connects to any Neo4j 3.x database that has the binary "Bolt" transport enabled.

It uses the https://github.com/neo4j/neo4j-java-driver[neo4j-java-driver] to provide the connectivity.

Just provide your username and password and you can connect to Neo4j.

The JDBC URL has this format: `jdbc:neo4j:bolt://host:port/?username=neo4j,password=<PASSWORD>`

=== The HTTP Driver

The HTTP driver uses the existing (since Neo4j 2.x) transaction Cypher HTTP API, and is implemented using `Apache Commons httpclient` and `Jackson` for JSON (de)serialization.

The JDBC URL has this format: `jdbc:neo4j:http://host:port/?username=neo4j,password=<PASSWORD>`

=== JDBC Compatibility

We cover these aspects of the JDBC-APIs, everything that's not explicitely mentioned should be assumed to be not implemented:

* Driver handling automatic loading and JDBC URLs
* Connection, incl. autocommit and manual commit
* Transactions
* Statements for reads and writes
* PreparedStatement for reads and writes, including parameters, both question marks `?` and named numbered parameters `{1}`
* ResultSet retrieving all columns as String, Object and their native type with optional conversions

== Libraries and Frameworks

=== Java JDBC Usage

Plain JDBC usage was already shown before:

include::../README.adoc[tags=mvs]

include::spring.adoc[]

include::play.adoc[]

// TODO === Mybatis

== Integration Examples with Popular Database Tools

// todo list of tools here: https://github.com/neo4j-contrib/neo4j-jdbc/issues?utf8=%E2%9C%93&q=is%3Aissue%20label%3ATools%20

== Reporting Tools

include::jasper.adoc[]

include::birt.adoc[]

== Business Intelligence Tools

include::qlik.adoc[]

include::tableau.adoc[]

== ETL Tools

include::pentaho.adoc[]

include::talend.adoc[]

== Database Tools

include::squirrel.adoc[]

include::eclipse.adoc[]

include::sqlshell.adoc[]

include::apoc.adoc[]

// TODO === JDBC-ODBC Bridge<commit_msg>Adding solR doc in index.adoc<commit_after>= Neo4j JDBC Driver Documentation
:toc: left
:toclevels: 2

include::../README.adoc[]



== Technical Reference

=== Usage Examples


=== The Bolt Driver

The Bolt driver connects to any Neo4j 3.x database that has the binary "Bolt" transport enabled.

It uses the https://github.com/neo4j/neo4j-java-driver[neo4j-java-driver] to provide the connectivity.

Just provide your username and password and you can connect to Neo4j.

The JDBC URL has this format: `jdbc:neo4j:bolt://host:port/?username=neo4j,password=<PASSWORD>`

=== The HTTP Driver

The HTTP driver uses the existing (since Neo4j 2.x) transaction Cypher HTTP API, and is implemented using `Apache Commons httpclient` and `Jackson` for JSON (de)serialization.

The JDBC URL has this format: `jdbc:neo4j:http://host:port/?username=neo4j,password=<PASSWORD>`

=== JDBC Compatibility

We cover these aspects of the JDBC-APIs, everything that's not explicitely mentioned should be assumed to be not implemented:

* Driver handling automatic loading and JDBC URLs
* Connection, incl. autocommit and manual commit
* Transactions
* Statements for reads and writes
* PreparedStatement for reads and writes, including parameters, both question marks `?` and named numbered parameters `{1}`
* ResultSet retrieving all columns as String, Object and their native type with optional conversions

== Libraries and Frameworks

=== Java JDBC Usage

Plain JDBC usage was already shown before:

include::../README.adoc[tags=mvs]

include::spring.adoc[]

include::play.adoc[]

// TODO === Mybatis

== Integration Examples with Popular Database Tools

// todo list of tools here: https://github.com/neo4j-contrib/neo4j-jdbc/issues?utf8=%E2%9C%93&q=is%3Aissue%20label%3ATools%20

== Reporting Tools

include::jasper.adoc[]

include::birt.adoc[]

== Business Intelligence Tools

include::qlik.adoc[]

include::tableau.adoc[]

== ETL Tools

include::pentaho.adoc[]

include::talend.adoc[]

== Database Tools

include::squirrel.adoc[]

include::eclipse.adoc[]

include::sqlshell.adoc[]

include::apoc.adoc[]

include::solr.adoc[]

// TODO === JDBC-ODBC Bridge
{'fraction_non_alphanumeric': 0.1107967939651108, 'fraction_numerical': 0.013201320132013201, 'mean_word_length': 5.194160583941605, 'pattern_counts': {'":': 0, '<': 7, '<?xml version=': 0, '>': 7, 'https://': 4, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '5582277', 'n_tokens_mistral': 1394, 'n_tokens_neox': 1274, 'n_words': 436}