Amazon Neptune JDBC Driver

v3.0.3 of the Amazon Neptune JDBC Driver is a patch release which brings bug fixes and minor dependency version upgrades.

Bug Fixes

• Fix Jena's initialization (#243) by @jindrichmynarz in #244
• Remove duplicate resultSet field from PreparedStatement by @ryn5 in #246
• Fix Assemble Tableau Connector GHA by @ryn5 in #249
• Pass all GremlinConnectionProperties to SchemaHelperGremlinDataModel by @ryn5 in #250

Improvements

• Update BI setup docs by @ryn5 in #245
• Update troubleshooting guide with Maven information. by @kenhuuu in #234
• Update DbVisualizer Documentation by @ryn5 in #247
• Minor Version Upgrades & Gremlin Test Server Setup by @xiazcy in #252

New Contributors

• @kenhuuu made their first contribution in #234
• @jindrichmynarz made their first contribution in #244
• @ryn5 made their first contribution in #245

Full Changelog: v3.0.2...v3.0.3

Amazon Neptune JDBC Driver

v3.0.2 of the Amazon Neptune JDBC Driver is a patch release which brings compatibility with Neptune engine versions ≥ 1.2.1.0 by upgrading to Apache TinkerPop 3.6.4.

Note, this version is not compatible with engine version <1.2.0.0. If you are using previous version, please refer to the Compatibility Matrix to find what JDBC driver version to choose.

New Features and Improvements

• Upgraded Apache TinkerPop to version 3.6.4 by @vkagamlyk and @xiazcy in #230
• Updates to Tableau Connector Fields by @xiazcy in #225

New Contributors

• @vkagamlyk made their first contribution in #230
• @Cole-Greer made their first contribution in #232

Full Changelog: v3.0.1...v3.0.2

Amazon Neptune JDBC Driver

v3.0.1 of the Amazon Neptune JDBC Driver is a patch release which provides updates to the Tableau connector files.

Note, this version is not compatible with engine version <1.2.0.0. If you are using previous version, please refer to the Compatibility Matrix to find what JDBC driver version to choose.

Bug Fixes

• For Tableau connector, removed unnecessary logging, added string localization, updated connection fields, and set to extract mode only by @xiazcy in #213

Full Changelog: v2.0.0...v3.0.1

Amazon Neptune JDBC Driver

Amazon Neptune JDBC Driver v3.0.0 is a major update release which provides compatibility with Neptune engine version >= 1.2.0.0.

Note, this version is not compatible with engine version <1.2.0.0. If you are using previous version, please refer to the Compatibility Matrix to find what JDBC driver version to choose.

Bug Fixes

• Fixed issues with openCypher IAM auth signature with Neptune engine version 1.2.0.0+ by @asarkar in #204
• Fixed build failures related to checkstyle versions by @asarkar in #210

New Features and Improvements

• Refactored SQL-Gremlin submodule into main module for publishing artifacts onto Maven by @asarkar in #208

Full Changelog: v2.0.0...v3.0.0

Amazon Neptune JDBC Driver

v2.0.0 of the Amazon Neptune JDBC Driver is a major update release which provides compatibility with Neptune engine version 1.1.1.0+.

Additional bug fixes and new features are listed below:

Change log

Bug Fixes

• Fixed issues with openCypher IAM auth signature with Neptune engine version 1.1.1.0 by @asarkar in #201
• Fixed GROUP BY with renamed table by @annapotr in #176
• Fixed bug in getting column names for metadata by @xiazcy in #160

New Features and Improvements

• Added X-Amz-Security-Token to support session token by @asarkar in #201
• Added basic literal comparisons in WHERE and HAVING after INNER JOIN by @annapotr in #177
• Added NOT support to WHERE clause by @annapotr in #173
• Added support for scalar values without column names by @danielmatuki in #155

New Contributors

• @danielmatuki made their first contribution in #155
• @annapotr made their first contribution in #176
• @asarkar made their first contribution in #201

Full Changelog: v1.1.0...v2.0.0

Amazon Neptune JDBC Driver

v1.1.0 of the Amazon Neptune JDBC Driver builds on v1.0.0.

This release provides bug fixes and a new features, details are listed below:

Change log

Bug Fixes

• Fixed issue with LIMIT 1 queries in DBVisualizer
• Fixed results for GROUP BY and WHERE in aggregates
• Fixed bugs in SSH tunnel
• Fixed bug with JOIN on vertices of different labels
• Fixed metadata caching to be on database url basis
• Fixed Log4j security issue (CVE-2021-44228 and CVE-2021-45046)
• Fixed issue with edge mismatch in JOIN returning results
• Fixed ORDER BY column on column that has null values
• Fixed issue with aggregate filtering on null valued columns
• Fixed 'false positive' exception log produced on statement shutdown

New Features and Improvements

• Removed Janino jar for revision control and updated Calcite
• Metadata overhaul
  • Driver version
  • getUrl
  • getTypeInfo
  • Removed incorrect catalog support
  • Fixed incorrect values reported in metadata
• Added Maven central hookup for Gradle publishing
• Moved sql-gremlin errors to resources
• Updated taco file to support SSH tunnel
• Improved error messages in sql-gremlin
• Added comparator support in SELECT clause
• Updated dialect file for taco to remove NULLS FIRST/LAST in ORDER BY

Documentation Enhancements

• Added documentation for DBeaver
• Added documentation around schema collection
• Enhanced documentation for JOIN queries
• Added more connection string and ssh tunnel examples in documentation

Commits

• Fixes for a number of simple issues with metadata and SQL support by @lyndonb-bq in #22
• Bump com.github.spotbugs from 4.7.9 to 4.7.10 by @dependabot in #25
• Bump gson from 2.7 to 2.8.9 by @dependabot in #1
• Rename shadowJar dependencies and minimize by @simonz-bq in #26
• AN-886 Feature and bug templates for the repository by @lyndonb-bq in #27
• Fix for querying columns of an edge by @lyndonb-bq in #44
• Make OFFSET throw an exception instead of being silently ignored by @lyndonb-bq in #29
• AN-887 Temporarily disabling query cancellation by @lyndonb-bq in #28
• Remove additional NOTICE and LICENSE files by @simonz-bq in #42
• Fixed HAVING support and did some rearchitecting to simplify any future additions to this part of the code by @lyndonb-bq in #45
• Adding kylepbit to our additional reviewers by @lyndonb-bq in #50
• ORDER BY using a label fix by @lyndonb-bq in #46
• Fix for COUNT(*) support by @lyndonb-bq in #47
• [AN-893] Tableau Connector Name Change by @alexey-temnikov in #54
• [AN-890] Minor nits in documentation: authScheme by @alexey-temnikov in #52
• Make Service Region into Property by @xiazcy in #48
• Fix for Miscellaneous Query Issues from Bug Bash by @lyndonb-bq in #51
• Fixing Tableau Extract Error by @lyndonb-bq in #55
• Remove Catalog support by @simonz-bq in #49
• Tableau Data Preview Error Fixes by @lyndonb-bq in #58
• [AN-861] Minor improvement. Example walkthrough how to connect to the database. by @alexey-temnikov in #53
• [AN-890] DOC - Added Limitation around Tableau Usage by @alexey-temnikov in #63
• Print all logs when assembling Tableau Connector by @alexey-temnikov in #60
• AN-890 TACO file and documentation update by @xiazcy in #62
• Report driver version in metadata by @simonz-bq in #61
• Updating Release version to 1.0 by @lyndonb-bq in #64
• Remove beta version tag by @lyndonb-bq in #66
• Bump mockito-core from 4.0.0 to 4.1.0 by @dependabot in #57
• Incorrect GROUP BY and WHERE results by @lyndonb-bq in #76
• Fixed exception in DBVisualizer for LIMIT 1 queries. by @lyndonb-bq in #73
• Bump com.github.spotbugs from 4.7.10 to 4.8.0 by @dependabot in #68
• Support more metadata by @simonz-bq in #74
• Remove Janino jar from project by @simonz-bq in #77
• Added Maven Central hookup for Gradle publishing by @lyndonb-bq in #85
• Move sql-gremlin errors to resources by @simonz-bq in #86
• AN-880 SSH Tunnel Revision by @xiazcy in #87
• Improve error message description by @simonz-bq in #89
• Fixed JOIN query bug when operating on vertices of different labels by @lyndonb-bq in #90
• AN-915 fix CAST null pointer exception by @lyndonb-bq in #92
• Fix a couple of copy-paste typos in edge selection by @artem-aliev in #98
• Update Log4J to 2.15.0 by @alexey-temnikov in #99
• Update documentation for BI tools by @simonz-bq in #94
• Ensure metadata cache doesn't apply to wrong connections by @simonz-bq in #101
• Update connectionProperties.js (Tableau Connector) by @alexey-temnikov in #105
• AN-888 Add Comparator Support in Select by @xiazcy in #102
• Fix for false positive exception on statement shutdown by @lyndonb-bq in #111
• Fix edge mismatch JOIN returning results by @lyndonb-bq in #114
• Updating log4j dependency by @alexey-temnikov in #110
• Schema Collection Documentation and JOIN Query Documentation Enhancements by @lyndonb-bq in #112
• Increase SQL test coverage by @simonz-bq in #115
• AN-943 Update Dialect File by @xiazcy in #120
• Fix ORDER BY on column that includes empty (null values) by @lyndonb-bq in #119
• Add slf4j library to the uber jar by @alexey-temnikov in #123
• Add internal SSH tunnel DBeaver docs by @simonz-bq in #124
• Fixed aggregate issue and added unsupported exception for WHERE in JOIN by @lyndonb-bq in #125
• Add CHANGELOG for release and update DBeaver markdown by @lyndonb-bq in #129

New Contributors

• @alexey-temnikov made their first contribution in #54
• @artem-aliev made their first contribution in #98

@simonz-bq made their first contribution in #26 (Enormous props)

Amazon Neptune JDBC Driver

This release for Amazon Neptune's JDBC Driver is the first GA Release of the driver.

What's New

• Bug fixes and enhanced support for SQL to Gremlin conversion
  • HAVING support
  • ORDER BY using label
  • COUNT(*) support
  • Edge column retrieval
  • Various other minor improvements
• Tableau extract mode enabled
• Tableau data preview enabled
• SERVICE_REGION now supported as a connection property
• Cut down the output size of the shadow jar
• Fixes to enhance JDBC metadata
• Enhanced documentation
• Tableau connector updates to support SERVICE_REGION

Commit Log

• Fixes for a number of simple issues with metadata and SQL support by @lyndonb-bq in #22
• Bump com.github.spotbugs from 4.7.9 to 4.7.10 by @dependabot in #25
• Bump gson from 2.7 to 2.8.9 by @dependabot in #1
• Rename shadowJar dependencies and minimize by @simonz-bq in #26
• AN-886 Feature and bug templates for the repository by @lyndonb-bq in #27
• Fix for querying columns of an edge by @lyndonb-bq in #44
• Make OFFSET throw an exception instead of being silently ignored by @lyndonb-bq in #29
• AN-887 Temporarily disabling query cancellation by @lyndonb-bq in #28
• Remove additional NOTICE and LICENSE files by @simonz-bq in #42
• Fixed HAVING support and did some rearchitecting to simplify any future additions to this part of the code by @lyndonb-bq in #45
• Adding kylepbit to our additional reviewers by @lyndonb-bq in #50
• ORDER BY using a label fix by @lyndonb-bq in #46
• Fix for COUNT(*) support by @lyndonb-bq in #47
• [AN-893] Tableau Connector Name Change by @alexey-temnikov in #54
• [AN-890] Minor nits in documentation: authScheme by @alexey-temnikov in #52
• Make Service Region into Property by @xiazcy in #48
• Fix for Miscellaneous Query Issues from Bug Bash by @lyndonb-bq in #51
• Fixing Tableau Extract Error by @lyndonb-bq in #55
• Remove Catalog support by @simonz-bq in #49
• Tableau Data Preview Error Fixes by @lyndonb-bq in #58
• [AN-861] Minor improvement. Example walkthrough how to connect to the database. by @alexey-temnikov in #53
• [AN-890] DOC - Added Limitation around Tableau Usage by @alexey-temnikov in #63
• Print all logs when assembling Tableau Connector by @alexey-temnikov in #60
• AN-890 TACO file and documentation update by @xiazcy in #62
• Report driver version in metadata by @simonz-bq in #61

Full Changelog: 1.0.0-beta.1...1.0.0[](url)

Amazon Neptune JDBC Driver Public Preview

The Amazon Neptune JDBC Driver is a JDBC 4.2 compliant driver (Java 8), which provides read-only JDBC connectivity for the Amazon Neptune service using graph query languages Gremlin, openCypher and SPARQL, as well as SQL.

When using SQL, the graph is represented in a table/columnar format and SQL queries can be executed. The driver supports a subset of SQL-92 along with some common extensions and supports SELECT statements of the general form:

SELECT [ DISTINCT ] { * | <projectItem> [, <projectItem> ]* }
   FROM <tableExpression>
   [ WHERE <booleanExpression> ]
   [ GROUP BY { <column> [, <column> ]* } ]
   [ ORDER BY { <column> [ DESC ] [, <column> [ DESC ] ]* } ]
   [ LIMIT limitNumber ]

projectItem:
    [ agg ]* [ <table>. ]* <column> [ [ AS ] columnAlias ]

The driver can be used to integrate with BI tools that support JDBC Drivers. For Tableau Desktop users a connector is available to use.