============================================================================== Simba Couchbase JDBC Driver with SQL Connector Release Notes ============================================================================== The release notes provide details of enhancements, features, known issues, and workflow changes in Simba Couchbase JDBC Driver 1.0.9, as well as the version history. 1.0.9 ======================================================================== Released 2019-07-31 Resolved Issues The following issues have been resolved in Simba Couchbase JDBC Driver 1.0.9. * [COUCHJ-308] When attempting to run an INFER query in N1QL, the driver returns an error. * [COUCHJ-310] If any column names in the database contain Unicode characters, the driver fails to connect to the database. Known Issues The following are known issues that you may encounter due to limitations in the data source, the driver, or an application. * For versions of Couchbase Server prior to 4.6, if the authentication method is set to username and password and incorrect credentials are provided, the connection still succeeds. This issue is resolved for Couchbase Server 4.6 and later. * For versions of Couchbase Server prior to 5.0, if incorrect credentials are provided in the credentials file, the driver reports that the connection succeeded but does not return any data. This issue is resolved for Couchbase Server 5.0 and later. * Joins are not fully optimized. Currently, the way that the driver handles joins is not fully optimized. In some cases, you may experience issues with driver performance. * Write-back is not fully optimized. Currently, the way that the driver handles DML statements is not fully optimized. In some cases, you may experience issues with driver performance. * Primary keys and foreign keys not supported in catalog functions. You cannot use catalog functions to retrieve primary keys or foreign keys. * Driver cannot execute UNION queries written in N1QL. When executing queries in N1QL, the driver does not support UNION queries. Workflow Changes ============================================================= The following changes may disrupt workflows from earlier versions. 1.0.6 ------------------------------------------------------------------------ * Removed support for JDBC 4.0 (Java 6) Beginning with this release, the driver no longer supports JDBC 4.0 (Java 6). Only JDBC 4.1 (Java 7) is supported. Version History ============================================================== 1.0.8 ------------------------------------------------------------------------ Released 2018-12-14 Enhancements & New Features * [COUCHJ-282] Specify credentials in connection URL You can now provide your authentication credentials directly in the connection URL. To do this, set the AuthMech connection property to 2. For more information, see the Installation and Configuration Guide. * [COUCHJ-294] Support for latest version of Couchbase Server The driver now supports Couchbase Server 6.0 and earlier. * [COUCHJ-297] Support for OpenJDK 8 The driver now supports OpenJDK 8. * [COUCHJ-295] Updated virtual table naming convention If an array is contained in an object, the name of the virtual table that corresponds to that array is now DocumentType_ObjectName_ArrayName. For more information, see the Installation and Configuration Guide. Resolved Issues The following issue has been resolved in Simba Couchbase JDBC Driver 1.0.8. * [COUCHJ-272] If an array is contained in an object, data from the array cannot be retrieved from Couchbase Server 4.6 and later. 1.0.7 ------------------------------------------------------------------------ Released 2018-10-25 Enhancements & New Features * [COUCHJ-265] Improved installation process Third-party libraries are now bundled in a shaded JAR file. * [COUCHJ-266][COUCHJ-283] Updated third-party libraries The driver now uses Jackson 2.9.7. * [COUCHJ-286] Updated Couchbase support The driver now supports Couchbase Server 5.5. Resolved Issues The following issues have been resolved in Simba Couchbase JDBC Driver 1.0.7. * [COUCHJ-276][COUCHJ-277][COUCHJ-283] During batch operations for UPDATE and DELETE, only one row is being modified. * [COUCHJ-284] For virtual tables the getPrimaryKeys() method returns only one row containing description of the Primary Key column. This issue has been resolved. The getPrimaryKeys() results for virtual tables now include the index column name in addition to the primary key value. 1.0.6 ------------------------------------------------------------------------ Released 2018-09-12 Enhancements & New Features * [COUCHJ-274] Support for latest version of Couchbase Server The driver now supports Couchbase Server 5.1. Resolved Issues The following issue was resolved in Simba Couchbase JDBC Driver 1.0.6. * [COUCHJ-270] If incorrect credentials are provided in the credentials file, the driver reports that the connection succeeded but does not return any data. This issue has been resolved for Couchbase Server 5.0 and later. The driver now returns an error message when incorrect credentials are provided. 1.0.5 ------------------------------------------------------------------------ Released 2016-12-16 Enhancements & New Features * Additional data type support The driver now supports the following additional SQL data types: - Character types: CHAR, LONGVARCHAR, WCHAR, WVARCHAR, WLONGVARCHAR - Numeric types: TINYINT, SMALLINT, INTEGER - Date-time types: DATE, TIME, TIMESTAMP Resolved Issues The following issues have been resolved in Simba Couchbase JDBC Driver 1.0.5. * Connectivity issues when load balancing is enabled. * Batch insert does not work. * Bucket names should not be used as table names if no TypeNameList is provided. * Slow INSERT performance. * Error messages from REST API are not being propagated. * UPDATE queries do not work properly for nested objects and virtual tables. 1.0.4 ------------------------------------------------------------------------ Released 2016-08-15 Enhancements & New Features * SSL with load balancing support for Couchbase Server 4.5 If you are using Couchbase Server 4.5 or later, you can now enable load balancing and communicate with the server through SSL. Resolved Issues The following issues have been resolved in Simba Couchbase JDBC Driver 1.0.4. * Column metadata query not including WHERE clause. * MaxRows property does not set maximum number of rows returned. 1.0.3 ------------------------------------------------------------------------ Released 2016-06-30 Resolved Issues The following issues have been resolved in Simba Couchbase JDBC Driver 1.0.3. * When executing a query that contains a COUNT() function and a WHERE clause, the driver omits the WHERE clause and the results are not filtered as expected. * In some cases, when multiple threads query the database through the same connection, the driver returns an error. * Driver does not support the use of arrays and objects as parameters for N1QL queries. * In some cases, when querying a database that does not contain a schema definition and the connection information does not specify a schema definition file, the query fails. This issue has been resolved. When there is no schema definition available, the driver will now create a schema definition in memory and use it to support queries. * Driver fails to connect when using the DataSource class (com.simba.couchbase.jdbc4.DataSource or com.simba.couchbase.jdbc41.DataSource). * Driver would encounter an error when trying to join a parent table with two virtual tables. * Queries containing some special characters (for example, "."), would not be executed properly. 1.0.1 ------------------------------------------------------------------------ Released 2015-12-11 Resolved Issues The following issues have been resolved in Simba Couchbase JDBC Driver 1.0.1. * In some cases, the data sampling process is not as precise as expected. Issues in the data sampling process have been resolved. The driver can now generate schema definitions that provide better support for Couchbase data. 1.0.0 ------------------------------------------------------------------------ Released 2015-10-06 * Version 1.0.0 was the initial release of the Simba Couchbase JDBC Driver. ==============================================================================