9 ORACLE

============================================================================== Simba Oracle ODBC Driver Release Notes ==============================================================================

The release notes provide details of enhancements, features, known issues, and workflow changes in Simba Oracle ODBC Driver 1.4.7, as well as the version history.

1.4.7 ========================================================================

Released 2021-02-26

Resolved Issues The following issue has been resolved in Simba Oracle ODBC Driver 1.4.7.

  • [ORCL-672] In some cases, when you disable statement caching, alter the metadata, and then run a query, an error message is displayed or invalid data is returned because the driver incorrectly caches the queries.

Known Issues The following are known issues that you may encounter due to limitations in the data source, the driver, or an application.

  • If you execute a large query while round-trip timeout is enabled, the connection might time out.

    Round-trip timeout is configured through the Query Timeout (or QueryTimeout) connection property. For more information, see the Installation and Configuration Guide.

  • When converting extremely large values(9.99999999999999e+125 or greater) to SQL_FLOAT, the driver might stop responding.

Workflow Changes =============================================================

The following changes may disrupt established workflows for the driver.

1.4.3 ————————————————————————

  • [ORCL-612] Removing support for Visual C++ Redistributable for Visual Studio 2013

    Beginning with this release, the driver no longer supports Visual C++ Redistributable for Visual Studio 2013. For information about the supported Visual C++ Redistributable for Visual Studio versions, see the Installation and Configuration Guide.

1.4.2 ————————————————————————

  • [ORCL-587] “Enable Auto Encoding” option removed

    Beginning with this release, the driver no longer supports the Enable Auto Encoding (or EnableAutoEncoding) configuration option.

1.4.0 ————————————————————————

  • [ORCL-556] Updated list of supported operating systems

    Beginning with this release, the list of supported operating systems has been updated. For more information, see the Installation and Configuration Guide.

  • [ORCL-526] Oracle Instant Client upgrade

    Beginning with this release, the driver requires Oracle Instant Client 19.3 instead of 12.2. If you installed Oracle Instant Client and the driver through separate installation processes, then the Oracle Instant Client does not get updated automatically and the driver may not work as expected.

    To resolve this, make sure to upgrade your installation of Oracle Instant Client. For instructions, see the Installation and Configuration Guide.

1.2.7 ————————————————————————

  • 32-bit applications no longer supported on macOS

    Beginning with this release, the driver requires Oracle Instant Client 12.2 instead of 12.1. Due to platform support differences in the Oracle Instant Client, the macOS version of the driver no longer supports 32-bit applications.

  • Oracle Instant Client upgrade

    Beginning with this release, the driver requires Oracle Instant Client 12.2 instead of 12.1. If you installed Oracle Instant Client and the driver through separate installation processes, then the Oracle Instant Client does not get updated automatically and the driver may not work as expected.

    To resolve this, make sure to upgrade your installation of Oracle Instant Client. For instructions, see the Installation and Configuration Guide.

Version History ==============================================================

1.4.6 ————————————————————————

Released 2020-12-31

Resolved Issues The following issue has been resolved in Simba Oracle ODBC Driver 1.4.6.

  • [ORCL-672] If a table contains double quotations ("), the driver does not properly parse the query.

1.4.5 ————————————————————————

Released 2020-10-05

Enhancements & New Features

  • [ORCL-666] Updated logging configurations

    You can now configure logging for the current connection by setting the logging configuration properties in the DSN or in a connection string. For more information, see the Installation and Configuration Guide.

  • [ORCL-482] Custom maximum name lengths

    You can now customize the maximum length of the names of catalogs, columns, schemas, and tables. To do this, set the lengths using the connection properties MaxCatalogNameLen, MaxColumnNameLen, MaxSchemaNameLen, and MaxTableNameLen. For more information, see the Installation and Configuration Guide.

  • [ORCL-667] Updated OpenSSL version

    The driver now uses OpenSSL version 1.1.1g. Previously, the driver used OpenSSL version 1.1.1d.

Resolved Issues The following issue has been resolved in Simba Oracle ODBC Driver 1.4.5.

  • [ORCL-668] When converting interval types from C to SQL, the driver terminates unexpectedly.

1.4.4 ————————————————————————

Released 2020-08-28

Resolved Issues The following issues have been resolved in Simba Oracle ODBC Driver 1.4.4.

  • [ORCL-639] If you use a workflow of PREPARE -> BIND -> EXECUTE -> BIND -> EXECUTE, the driver terminates unexpectedly.

  • [ORCL-640] When retrieving data from a NUMBER column that includes the value 1.000001, the driver returns “1.”.

  • [ORCL-654] In some cases, when inserting large BLOB data, the data becomes truncated or replaced with NULL.

  • [ORCL-656] Fetching DECIMAL data truncates the data.

  • [ORCL-657] In some cases, non-English text is truncated.

    This issue has been resolved. The driver incorrectly treated the COLUMNSIZE attribute in SqlBindParameter as a number of bytes rather than a number of characters. Now, the driver treates COLUMNSIZE as a number of characters.

1.4.3 ————————————————————————

Released 2020-06-30

Resolved Issues The following issues have been resolved in Simba Oracle ODBC Driver 1.4.3.

  • [ORCL-617] When using Oracle in-build functions to retrieve data containing errors, the driver returns partial data.

    This issue has been resolved. The driver now returns an error message when using Oracle in-build functions to retrieve data containing errors.

  • [ORCL-630] The Simba Oracle Driver and Oracle Native Driver display
    TIMESTAMP data in different formats.

    This issue has been resolved. The Simba Oracle Driver now follows the Oracle Native Driver’s format for TIMESTAMP data.

1.4.2 ————————————————————————

Released 2020-02-14

Enhancements & New Features

  • [ORCL-583] Updated Expat library

    The driver has been updated to use version 2.2.9 of the Expat library. Previously, the driver used version 2.2.0.

Resolved Issues The following issues have been resolved in Simba Oracle ODBC Driver 1.4.2.

  • [ORCL-569] The driver terminates unexpectedly when both of the following occur:

    • Multiple database drivers are loaded to the same process.
    • One driver unloads and calls ICU’s u_cleanup() function, while another driver continues to run and tries to access the memory space that has been cleaned up.

  • [ORCL-587] In some cases, the driver truncates data that uses a non-default character set encoding.

    This issue has been resolved. As a result of this change, the Enable Auto Encoding (or EnableAutoEncoding) configuration option is no longer supported. For more information, see the “Workflow Changes” section.

1.4.1 ————————————————————————

Released 2019-12-10

Enhancements & New Features

  • [ORCL-572] Implemented timeouts for database round-trip calls using OCI_ATTR_CALL_TIMEOUT

    The driver now uses the OCI_ATTR_CALL_TIMEOUT attribute to set the round-trip timeout. To configure round-trip timeout through the driver, use the new Query Timeout (or QueryTimeout) property. For more information, see the Installation and Configuration Guide.

  • [ORCL-573] Standardized log file names

    When logging is enabled, the driver now produces the following log files:

    • A simbaoracleodbcdriver.log file that logs driver activity that is not specific to a connection.
    • A simbaoracleodbcdriver_connection_[Number].log for each connection made to the database, where [Number] is a number that identifies each log file. This file logs driver activity that is specific to the connection.

Resolved Issues The following issue has been resolved in Simba Oracle ODBC Driver 1.4.1.

  • [ORCL-578] When the driver is installed on a macOS machine, the driver does not load.

1.4.0 ————————————————————————

Released 2019-10-07

Enhancements & New Features

  • [ORCL-442] Return only user-defined table details

    You can now configure the driver to return only user-defined table details. To do this, enable the new Enable User Filtration (or EnableUserFiltration) property. For more information, see the Installation and Configuration Guide.

  • [ORCL-503] Enable driver to automatically use same character set as data source

    You can now configure the driver to automatically use the same character set as that being used by the data source. To do this, enable the new Enable Auto Encoding (or EnableAutoEncoding) property. For more information, see the Installation and Configuration Guide.

  • [ORCL-491][ORCL-382] DSN Setup dialog box enhanced

    The Simba Oracle ODBC Driver DSN Setup dialog box has been enhanced with new tabs; Optimization Options and Metadata Options. The options in the Logging Options dialog box have also been updated. For more information, see the Installation and Configuration Guide.

  • [ORCL-522] Updated driver version information in Linux binary

    You can now check the Linux driver’s version from the driver binary file. To do this, open the .so file in a text editor, and search for the text “\(driver_version_sb\):”. The driver’s version number is listed after this text.

  • [ORCL-526] Updated OCI version

    The driver now uses the OCI 19.3 packages.

  • [ORCL-533] Updated third-party library linking for Linux

    In the Linux driver, minor internal improvements have been implemented for the linking between the third-party libraries and the main driver library.

  • [ORCL-448] Upgrade to OpenSSL 1.1.1d

    The driver now uses OpenSSL 1.1.1d for encryption of data. Previously the driver used OpenSSL 1.1.0j.

  • [ORCL-501] Internal driver improvements

    The driver has been updated with minor internal improvements.

==============================================================================