============================================================================== Magnitude Simba MongoDB JDBC Data Connector Release Notes ============================================================================== The release notes provide details of enhancements, features, known issues, and workflow changes in Simba MongoDB JDBC Connector 1.3.21, as well as the version history. 1.3.21 ======================================================================= Released 2024-03-15 Enhancements & New Features * [MDBJ-570] MongoDB 7.0 support The connector now supports MongoDB version 7.0. For a list of supported versions, see the Installation and Configuration Guide. * [MDBJ-571] Updated third-party libraries The connector now uses the following third-party libraries: - jackson-annotations 2.16.0 (previously 2.13.4) - jackson-core 2.16.0 (previously 2.13.4) - jackson-databind 2.16.0 (previously 2.13.4.2) * [MDBJ-571] Updated Schema Editor The connector has been updated to use Schema Editor 3.2.9. * [MDBJ-572] UseSrvConnection support The connector can now connect to a host that corresponds to a DNS SRV record. To do this, set the UseSrvConnection property to true. For more information, see the Installation and Configuration Guide. * [MDBJ-588] Internal connector improvements The connector has been updated with minor internal improvements. Known Issues The following are known issues that you may encounter due to limitations in the data source, the connector, or an application. * [MDBJ-356] Reserved characters in user names and passwords If the user name, password, or Kerberos principal name contains reserved characters, those characters must be encoded in the connection URL using URL encoding (percent encoding). For example, the user name ch@ng would be encoded in the connection URL as ch%40ng. * The connector only supports Java Runtime Environment (JRE) 8 or greater. Alternatively, if the Mongo server uses TLS 1.2, any runtime environment that is configured for TLS 1.2 can also be used. * When connecting through a client application that has auto-commit mode disabled, the connection fails and the connector returns an error. Connections where auto-commit is disabled in the client application are not supported. As a workaround, set the EnableTransaction property to true. For more information about this property, see the Simba MongoDB JDBC Connector Installation and Configuration Guide. * Not a Number (NaN) values are not processed correctly in floating-point comparisons. When you execute a floating-point comparison involving NaN values, the connector completes the comparison but the NaN values are not processed correctly and the results may be incorrect. * In some cases, the unique parameter in the GetIndexInfo() catalog function does not work as expected. When you call GetIndexInfo() with unique set to false, instead of returning indices regardless of whether they are unique or not, the connector only returns indices that are not unique. Workflow Changes ============================================================= The following changes may disrupt established workflows for the connector. 1.3.20 ----------------------------------------------------------------------- * [MDBJ-558] Removed support for MongoDB 4.2 Beginning with this release, the connector will no longer support MongoDB server version 4.2. For a list of supported MongoDB versions, see the Installation and Configuration Guide. 1.3.17 ----------------------------------------------------------------------- * [MDBJ-549] Removing support for MongoDB 3.6 and 4.0 Beginning with this release, the connector will no longer support MongoDB versions 3.6 and 4.0. For a list of supported MongoDB versions, see the Installation and Configuration Guide. 1.3.13 ----------------------------------------------------------------------- * [MDBJ-496] Updated UPSERT statement virtual table rules The rules for UPSERT statements for virtual tables have been updated. For a list of the rules, see the Installation and Configuration Guide. 1.3.12 ----------------------------------------------------------------------- * [MDBJ-482] Removed support for JDBC 4.1 (Java 7) Beginning with this release, the driver no longer supports JDBC 4.1 (Java 7). For a list of supported JDBC versions, see the Installation and Configuration Guide. 1.3.9 ------------------------------------------------------------------------ * Removed support for MongoDB 3.4 Beginning with this release, the driver no longer supports MongoDB version 3.4. For a list of supported MongoDB versions, see the Installation and Configuration Guide. 1.3.8 ------------------------------------------------------------------------ * Removed support for JDBC 4.0 (Java 6) Beginning with this release, the driver no longer supports JDBC 4.0 (Java 6). For a list of supported JDBC versions, see the Installation and Configuration Guide. 1.3.7 ------------------------------------------------------------------------ * Updated format for JSON data Beginning with this release, the driver uses a different format when returning documents as JSON strings in a DocumentAsJson column. Specifically, the driver no longer includes spaces in these parts of the strings: - Between the field name and the colon (:) - After an opening brace ({) - Before a closing brace (}) For example, if a previous version of the driver returned this JSON string: '{ "_id" : { "$oid" : "567892e6f1204beaf38556be" }, "LOG_C" : 1 }' Then, beginning with this release, the driver now returns this JSON string: '{"_id": {"$oid": "567892e6f1204beaf38556be"}, "LOG_C": 1}' If any of your existing query statements specify DocumentAsJson values, make sure to update those values to use this new format. 1.3.1 ------------------------------------------------------------------------ * Removed support for MongoDB 3.0 and 3.2 Beginning with this release, the driver no longer supports MongoDB versions 3.0 and 3.2. For a list of supported MongoDB versions, see the Installation and Configuration Guide. Version History ============================================================== 1.3.20 ----------------------------------------------------------------------- Released 2023-04-28 Enhancements & New Features * [MDBJ-556][MDBJ-557] MongoDB 6.0 support The connector now supports MongoDB version 6.0. For a list of supported versions, see the Installation and Configuration Guide. * [MDBJ-557][MDBJ-559] Updated third-party libraries The connector now uses the following third-party libraries: - Jackson 2.14.0 (previously 2.13.2) - MongoDB Java driver 4.9.0 (previously 4.6.0) * [MDBJ-559] Updated Schema Editor The connector has been updated to use Schema Editor 3.2.8. 1.3.19 ----------------------------------------------------------------------- Released 2023-01-27 Enhancements & New Features * [MDBJ-550] Updated third-party libraries The connector now uses the following third-party libraries: - jackson-annotations 2.13.4 (previously 2.13.2) - jackson-core 2.13.4 (previously 2.13.2) - jackson-databind 2.13.4.2 (previously 2.13.2.2) * Updated Schema Editor The connector has been updated to use Schema Editor 3.2.7. ==============================================================================