Home Partners Company

MongoDB

Progress DataDirect for JDBC for MongoDB

An asterisk (*) indicates support that was added in a hotfix or software patch subsequent to a release.

Version 6.0.1

CERTIFICATIONS
  • Certified with MongoDB 3.2*
ENHANCEMENTS
  • The driver has been enhanced to resolve naming conflicts that can occur when exposing native objects using unquoted, uppercase identifiers (the default behavior). To avoid conflicts, the driver appends an underscore separator and integer (for example, _1) to identifiers that differ only by case.
  • The DefaultVarcharSize configuration option has been enhanced to generate dynamic default lengths for VARCHAR columns when specifying a multiplier value (for example, 2x) for the option. When specifying a multiplier value, the default length for a VARCHAR column is determined by multiplying the value specified by the size of the largest value detected in that column. This results in a default length that is proportionate to the size of the data within the column, which can improve the memory efficiency within the driver and application. The default value for this option has been updated to 1.5x.
  • You can further define the default length for VARCHAR columns by tuning the new MaxVarcharSize and MinVarcharSize configuration options. These options allow you to specify maximum and minimum size limits for the default length generated by the DefaultVarcharSize configuration option. When tuned for your data, MaxVarcharSize and MinVarcharSize can improve memory efficiency and avoid the undesired truncation of VARCHAR values.
  • The KeywordConflictSuffix configuration option allows you to specify the suffix that is appended to object and field names that conflict with SQL engine keywords.
  • The driver has been enhanced to use the MongoDB aggregation framework to improve performance in the execution of SQL queries using LIMIT, ORDER BY, and TOP clauses.
  • The following SQL extensions have been added to the driver:
    • REFRESH MAP adds newly discovered objects to your relational view of native data. It also incorporates any configuration changes made to your relational view by reloading the schema definition and associated files. REFRESH MAP is an expensive query since it involves the discovery of native data.
    • RELOAD MAP reloads the schema definition and associated files. This statement allows you to update your relational view of native data while the driver is connected to the data store. RELOAD MAP does not discover changes made to the native data store.
  • The driver has been enhanced to improve the handling of large result sets and reduce the likelihood of out-of-memory errors through the modification of the FetchSize connection property and the introduction of the ResultMemorySize connection property.
  • The driver has been enhanced to further ensure data integrity when mapping native
    MongoDB data types to a relational schema. When inconsistent data types are
    detected, the driver determines which SQL type to use based on the combination
    of native types found. These combinations are handled in the following manner:
    • Bigint and Integer map to BIGINT
    • Double and Integer map to DOUBLE
    • All other combinations map to VARCHAR or LONGVARCHAR
CHANGED BEHAVIOR
  • The driver no longer registers the Statement Pool Monitor as a JMX MBean by
    default. To register the Statement Pool Monitor and manage statement pooling with
    standard JMX API calls, the new RegisterStatementPoolMonitorMBean connection
    property must be set to true.

Version 6.0.0

CERTIFICATIONS
  • Certified with MongoDB 3.0
ENHANCEMENTS
  • When first connecting to a MongoDB server, the driver automatically creates a normalized schema of the data and generates a SchemaDefinition for housing and sharing the normalized schema.
  • Native MongoDB data is fully normalized during the normalization process,
    regardless of the depth of nested arrays, documents, and objects.
  • The driver uses the MongoDB aggregation framework to improve performance in the execution of SQL queries using aggregates, GROUP BY clauses, or HAVING clauses.
  • The following Schema Tool enhancements have been made:
    • The Restart Wizard feature allows you to reset the relational view of your data from the Table Wizard menu.
    • The Update Schema feature allows you to map all new native objects to your schema definition with a single click.
    • Support for selecting multiple objects in the Table Wizard for improved object management when customizing your schema.
CHANGED BEHAVIOR
  • The driver no longer registers the Statement Pool Monitor as a JMX MBean by
    default. To register the Statement Pool Monitor and manage statement pooling with
    standard JMX API calls, the new RegisterStatementPoolMonitorMBean connection
    property must be set to true.

Version 5.1.4

CERTIFICATIONS
  • Certified with MongoDB 2.2, 2.4, and 2.6
ENHANCEMENTS
  • The Schema Tool has been enhanced to normalize native data to an arbitrary
    depth.
  • Eight connection properties have been added to the driver to support SSL.
  • A Connection Options field has been added to the Schema Tool's Open Schema
    Definition dialog (the first window that appears when running the schematool.jar
    file).
  • The following configuration options have been introduced to increase flexibility
    when mapping native data to a relational schema:
    • DefaultVarcharSize determines the default length of fields that are discovered and mapped as VARCHAR by the driver.
    • LeadingUnderscoreReplacement permits the replacement of leading underscores with a string.
  • Support for result set holdability has been added to the driver.

Version 5.1.3

GA Release Features
  • Support for MongoDB 2.2 and higher
  • Supports SQL to select data from MongoDB
  • Supports insert, update, and delete capabilities
  • Translates SQL statements provided by an application into native MongoDB BSON statements
  • Includes the DataDirect Schema Tool, which guides you through the process of mapping the MongoDB dynamic schema data model to a customized relational data model.
GA Release Certifications
  • Certified with MongoDB 2.2, 2.4, and 2.6


patch-whats-new

Read Next

What's new