9 ORACLE
============================================================================== Magnitude Simba Oracle ODBC Data Connector Release Notes ==============================================================================
The release notes provide details of enhancements, features, known issues, and workflow changes in Simba Oracle ODBC Connector 1.4.8, as well as the version history.
1.4.8 ========================================================================
Released 2021-03-31
Enhancements & New Features
- [ORCL-664] Autonomous data source support
The connector now supports autonomous data sources within documents.
- [ORCL-709] Upgraded third-party libraries
The connector has been updated to use the following libraries: - OpenSSL version 1.1.1i (previously 1.1.1g) - ICU version 58.3.x (previously 58.2.x)
Resolved Issues The following issues have been resolved in Simba Oracle ODBC Connector 1.4.8.
[ORCL-695] When inserting data using multiple parameter sets, and the first parameter set is NULL, only the NULL data is inserted (all of the parameter sets are considered NULL).
[ORCL-695] Aggregate function columns and Oracle NUMBER data type without scale and precision are not mapped correctly.
[ORCL-696] When using NULL columns in an aggregate function, the connector returns an error.
Known Issues The following are known issues that you may encounter due to limitations in the data source, the connector, 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 connector might stop responding.
Workflow Changes =============================================================
The following changes may disrupt established workflows for the connector.
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.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.
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.
==============================================================================