Amazon DocumentDB JDBC Driver v1.2.4

What's Changed

• FIX Prep Maven step hangs when is running on-demand. by @affonsoBQ in #336
• Bump de.flapdoodle.embed.mongo from 3.4.5 to 3.4.6 by @dependabot in #344
• Bump jackson-core from 2.13.2 to 2.13.3 by @dependabot in #341
• [AD-550] no longer treat schema and catalog as patterns in getPrimaryKeys and getImportedKeys by @alinaliBQ in #343
• [AD-751] add null checks and remove isNullOrWhitespace checks in getColumns and getTables by @alinaliBQ in #345
• Bump jackson-datatype-guava from 2.13.2 to 2.13.3 by @dependabot in #340
• [AD-754] Bump to version 1.2.4 by @affonsoBQ in #346
• Bump calcite-core from 1.28.0 to 1.30.0 by @dependabot in #303

Full Changelog: v1.2.3...v1.2.4

Amazon DocumentDB JDBC Driver v1.2.3

What's Changed

• updating pom file by @affonsoBQ in #320
• Bump junit-jupiter from 5.8.1 to 5.8.2 by @dependabot in #314
• Bump findsecbugs-plugin from 1.11.0 to 1.12.0 by @dependabot in #317
• [AD-719] Use Apache 2.0 license as provided by GitHub by @andiem-bq in #327
• [AD-706] Remove/Clean-up JDBC dependencies by @affonsoBQ in #330
• Bump de.undercouch.download from 5.0.4 to 5.0.5 by @dependabot in #324
• Bump lombok from 1.18.22 to 1.18.24 by @dependabot in #325
• Bump mockito-core from 4.4.0 to 4.5.1 by @dependabot in #329
• Bump checkstyle from 10.1 to 10.2 by @dependabot in #331
• bump to version 1.2.3 by @affonsoBQ in #333
• Sign Artifacts in Github Action by @affonsoBQ in #334

Full Changelog: v1.2.2...v1.2.3

Amazon DocumentDB JDBC Driver v1.2.2

What's Changed

• Bump de.flapdoodle.embed.mongo from 3.4.3 to 3.4.5 by @dependabot in #309
• Bump de.undercouch.download from 5.0.2 to 5.0.4 by @dependabot in #308
• Bump checkstyle from 10.0 to 10.1 by @dependabot in #306
• Bump mongodb-driver-sync from 4.5.0 to 4.5.1 by @dependabot in #305
• Bump io.freefair.aggregate-javadoc from 5.3.3.3 to 6.4.1 by @dependabot in #304
• [AD-473] Publish jar file to Maven Central repository by @affonsoBQ in #315
• bump to version 1.2.2 by @affonsoBQ in #318
• bump pom version 1.2.2 by @affonsoBQ in #319

Full Changelog: v1.2.1...v1.2.2

Amazon DocumentDB JDBC Driver v1.2.1

Amazon DocumentDB JDBC Driver v1.2.1

This release refactored the project to be a single project.

What's Changed

• fixing javadoc task errors by @affonsoBQ in #300
• [AD-659] DatabaseMetaData.getTables and getColumns does not handle escaped patterns by @birschick-bq in #302
• Bump mockito-core from 4.3.1 to 4.4.0 by @dependabot in #298
• Bump de.undercouch.download from 5.0.1 to 5.0.2 by @dependabot in #299
• Bump jackson-datatype-guava from 2.13.1 to 2.13.2 by @dependabot in #297
• Bump jackson-core from 2.13.1 to 2.13.2 by @dependabot in #296
• Bump guava from 29.0-jre to 31.1-jre by @dependabot in #294
• [AD-473] refactor to a slim jar file by @affonsoBQ in #307
• Bumping version to 1.2.1 by @affonsoBQ in #310

Full Changelog: v1.2.0...v1.2.1

Amazon DocumentDB JDBC Driver v1.2.0

Amazon DocumentDB JDBC Driver Changelog

Amazon DocumentDB JDBC Driver v1.2.0

This release focuses on documentation enhancements, minor refactorings and bug fixes, dependency updates, and the introduction of a new connection property defaultAuthDb to support passing an authentication database other than admin. More information about this property has been added to the connection string documentation.

What's Changed

• [AD-520] Add Tableau Server to BI tool setup list by @andiem-bq in #274
• Bump slf4j-log4j12 from 1.7.35 to 1.7.36 by @dependabot in #273
• Bump mongodb-driver-sync from 4.4.1 to 4.4.2 by @dependabot in #276
• [AD-543] Add documentation warnings for syncing JDBC values on ODBC by @andiem-bq in #282
• [Github Issue 279] Add authentication database connection property by @andiem-bq in #281
• Bump de.flapdoodle.embed.mongo from 3.3.1 to 3.4.3 by @dependabot in #288
• Bump checkstyle from 9.3 to 10.0 by @dependabot in #289
• Bump log4j-core from 2.17.1 to 2.17.2 by @dependabot in #290
• Bump log4j-api from 2.17.1 to 2.17.2 by @dependabot in #291
• Bump mongodb-driver-sync from 4.4.2 to 4.5.0 by @dependabot in #277
• [Issue-278] Add check for BsonNull in processDocumentsInArray and processArrayInArray by @andiem-bq in #287
• Bump sslcontext-kickstart from 7.2.1 to 7.3.0 by @dependabot in #293
• [AD-627] Add new method to get aggregate operations as strings by @andiem-bq in #295
• [AD-614] Bump version to v1.2.0 by @andiem-bq in #292

Full Changelog: v1.1.1...v1.2.0

Amazon DocumentDB JDBC Driver v1.1.1

Amazon DocumentDB JDBC Driver Changelog

Amazon DocumentDB JDBC Driver v1.1.1

This release focuses on code coverage and documentation enhancements, minor refactorings, and various dependency updates.

Commits

• Bump mockito-core from 4.0.0 to 4.2.0 by @dependabot in #233
• Bump sslcontext-kickstart from 7.0.2 to 7.1.0 by @dependabot in #215
• Bump checkstyle from 9.1 to 9.2 by @dependabot in #213
• Bump de.flapdoodle.embed.mongo from 3.0.0 to 3.2.3 by @dependabot in #225
• Bump junit-jupiter-params from 5.8.1 to 5.8.2 by @dependabot in #211
• Bump junit-jupiter-engine from 5.8.1 to 5.8.2 by @dependabot in #212
• Bump log4j-api from 2.16.0 to 2.17.0 by @dependabot in #237
• Bump jackson-core from 2.13.0 to 2.13.1 by @dependabot in #238
• Bump de.flapdoodle.embed.mongo from 3.2.3 to 3.2.4 by @dependabot in #239
• Bump log4j-core from 2.16.0 to 2.17.0 by @dependabot in #236
• [AD-400] Increase code coverage in calcite adapter by @andiem-bq in #228
• Bump log4j-core from 2.17.0 to 2.17.1 by @dependabot in #245
• Bump log4j-api from 2.17.0 to 2.17.1 by @dependabot in #243
• [AD-512] Update flapdoodle usage to remove usage of deprecated components after upgrade of library. by @birschick-bq in #247
• [BUG] Increment Tableau Connector Version #251 by @alexey-temnikov in #252
• Bump slf4j-log4j12 from 1.7.32 to 1.7.33 by @dependabot in #255
• Bump jackson-datatype-guava from 2.13.0 to 2.13.1 by @dependabot in #235
• Bump checkstyle from 9.2 to 9.2.1 by @dependabot in #242
• Bump sslcontext-kickstart from 7.1.0 to 7.2.0 by @dependabot in #248
• Bump mongodb-driver-sync from 4.3.4 to 4.4.1 by @dependabot in #253
• Bump de.flapdoodle.embed.mongo from 3.2.6 to 3.3.0 by @dependabot in #260
• Bump value from 2.8.8 to 2.9.0 by @dependabot in #258
• Add PR repository to checkout action + use pull_request_target event instead of pull_request by @andiem-bq in #262
• Bump mockito-core from 4.2.0 to 4.3.1 by @dependabot in #261
• Small refactoring for certificate loading in DocumentDbConnectionProperties by @andiem-bq in #271
• Bump checkstyle from 9.2.1 to 9.3 by @dependabot in #267
• Bump sslcontext-kickstart from 7.2.0 to 7.2.1 by @dependabot in #268
• Bump slf4j-log4j12 from 1.7.33 to 1.7.35 by @dependabot in #269
• Bump de.undercouch.download from 4.1.2 to 5.0.1 by @dependabot in #266
• Bump de.flapdoodle.embed.mongo from 3.3.0 to 3.3.1 by @dependabot in #270
• [AD-509] Update tableau-desktop-driver-setup.md by @alinaliBQ in #257
• [AD-521] Expose SSH local port. by @alinaliBQ in #265
• [AD-531] Bump version to v1.1.1 by @andiem-bq in #272

New Contributors

• @alinaliBQ made their first contribution in #257

Full Changelog: v1.1.0...v1.1.1

Amazon DocumentDB JDBC Driver v1.1.0

Amazon DocumentDB JDBC Driver Changelog

Amazon DocumentDB JDBC Driver v1.1.0

This release focuses on adding support for new string functions and enhancing the Tableau connector.

New Features and Improvements

• Added support for additional string functions:
  • UPPER
  • LOWER
  • CONCAT
  • POSITION
  • CHAR_LENGTH
  • LEFT
  • RIGHT
  • CONTAINS (Tableau only)
  • STARTSWITH (Tableau only)
  • ENDWITH (Tableau only)
• Updated set up documentation with new screenshots
• Added a default application name for telemetry purposes

Bug Fixes

• Addressed Log4j security issues CVE-2021-44228 and CVE-2021-45046

Commits

• Support for additional string functions by @andiem-bq in #214
• Bump log4j-core from 2.14.1 to 2.15.0 by @dependabot in #222
• Bump log4j-api from 2.14.1 to 2.15.0 by @dependabot in #223
• Update Tableau Desktop screenshots by @andiem-bq in #218
• Support for left and right string functions by @andiem-bq in #220
• Bump log4j-core from 2.15.0 to 2.16.0 by @dependabot in #226
• Bump log4j-api from 2.15.0 to 2.16.0 by @dependabot in #227
• Add default application name by @andiem-bq in #229
• Bump version to v1.1.0 by @andiem-bq in #232

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

Amazon DocumentDB JDBC Driver v1.0.1

Amazon DocumentDB JDBC Driver Changelog

Amazon DocumentDB JDBC Driver v1.0.1

This release focuses on stability and performance improvements for the JDBC driver.

Bug Fixes

• #176 Added handling for null/undefined values in SUM().
• #183 Fixed incorrect field name generated when aggregate call has name conflict with existing field.
• #168 Corrected inconsistencies in repeated calls to CURRENT_TIME, CURRENT_TIMESTAMP and CURRENT_DATE within a single query.
• #202 , #208 Corrected formatting issue with TIME literals and added more tests and support for other literal types.

Improvements

• #180 Performance improvement to use single $match stage when WHERE or HAVING clause only requires query operators.
• #199 Update version of Calcite to 1.28.0 to take advantage of fix for Janino (3.1.6) for getDefaultCompilerFactory exception.
• Increased overall unit test coverage.
• Small documentation enhancements.
• Various dependency updates.

v1.0.1-beta.1

Amazon DocumentDB JDBC Driver Changelog

Amazon DocumentDB JDBC Driver v1.0.1-beta.1

This beta release focuses on stability and includes fixes for the JDBC driver.

Bug Fixes

• Added handling for null/undefined values in SUM().
• Fixed incorrect field name generated when aggregate call has name conflict with existing field.
• Corrected inconsistencies in repeated calls to CURRENT_TIME, CURRENT_TIMESTAMP and CURRENT_DATE within a single query.

Improvements

• Performance improvement for to use single $match stage when WHERE or HAVING clause only requires query operators.
• Small documentation enhancements.
• Various dependency updates.

v1.0.0

The Amazon DocumentDB JDBC Driver is a JDBC 4.2 compliant driver (Java 8) which normalizes documents into a relational schema and executes a relational query. The driver supports a subset of SQL-92 along with some common extensions and supports SELECT statements of the general form:

SELECT [ ALL | DISTINCT ] { * | projectItem [, projectItem ]* }
   FROM tableExpression
   [ WHERE booleanExpression ]
   [ GROUP BY { groupItem [, groupItem ]* } ]
   [ HAVING booleanExpression ]
   [ ORDER BY orderItem [ ASC | DESC ] [, orderItem [ ASC | DESC ]* ]
   [ LIMIT limitNumber ]
   [ OFFSET startNumber ]

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

Bug Fixes (Differences from the last beta pre-release)

• Loading JDBC driver in DbVisualizer can fail with IllegalArgumentException: URI is not hierarchical
• Refactor join condition validation

Documentation Updates (Differences from the last beta pre-release)

• Update documentation regarding join limitation
• Remove mention of SSH passphrase since we removed this from a connection dialog