MySQL Connector/Java 8.0.9-rc has been released
Dear MySQL users, MySQL Connector/Java 8.0.9-rc is the first Release Candidate of the 8.0 branch of MySQL Connector/J, providing an insight into upcoming features. It is suitable for use with MySQL Server versions 5.5, 5.6, 5.7, and 8.0. It supports the Java Database Connectivity (JDBC) 4.2 API. This release includes the following new features and changes, also described in more detail on https://dev.mysql.com/doc/relnotes/connector-j/8.0/en/news-8-0-9.html MySQL Connectors and other MySQL client tools and applications now synchronize the first digit of their version number with the (highest) MySQL server version they support. This change makes it easy and intuitive to decide which client version to use for which server version. As always, we recommend that you check the "CHANGES" file in the download archive to be aware of changes in behavior that might affect your application. To download MySQL Connector/Java 8.0.9-rc, see the "Development Releases" tab at http://dev.mysql.com/downloads/connector/j/ Enjoy! Changes in MySQL Connector/J 8.0.9 (2018-01-30, Release Candidate) Functionality Added or Changed * X DevAPI: In the process of refining the definition of the X DevAPI to cover the most relevant usage scenarios, the following API components have been removed from the X DevAPI implementation for Connector/J: + Components that support DDLs for views, including the createView(), dropView(), and modifyView() methods. + Components that support DDLS for tables, including the createTable(), dropTable(), and modifyTable() methods. + Components that support session configurations, including the SessionConfig object, the PersistenceHandler interface, the PasswordHandler interface, and the SessionConfigManager class. * X DevAPI: Added the setSavepoint(), rollbackTo(), and releaseSavepoint() methods to the Session interface to support the SAVEPOINT (http://dev.mysql.com/doc/refman/8.0/en/savepoint.html), ROLLBACK TO SAVEPOINT (http://dev.mysql.com/doc/refman/8.0/en/savepoint.html), and RELEASE SAVEPOINT (http://dev.mysql.com/doc/refman/8.0/en/savepoint.html) statements. See MySQL Connector/J X DevAPI Reference (http://dev.mysql.com/doc/dev/connector-j) for more details. * X DevAPI: A new patch() function has been added to the ModifyStatement interface. The function accepts an JSON-like object describing document changes and applies them to documents matched by the modify() filter. See MySQL Connector/J X DevAPI Reference (http://dev.mysql.com/doc/dev/connector-j) for more details. * X DevAPI: The createIndex() method for the Collection interface now has a new syntax. See MySQL Connector/J X DevAPI Reference (http://dev.mysql.com/doc/dev/connector-j) for more details. * X DevAPI: Added the following methods for single-document operations in the X DevAPI: + replaceOne() + addOrReplaceOne() + getOne() + removeOne() See MySQL Connector/J X DevAPI Reference (http://dev.mysql.com/doc/dev/connector-j) for more details. * X DevAPI: Setters and getters methods have been added for the configuration properties with the MysqlDataSource, MysqlXADataSource, and MysqlConnectionPoolDataSource classes. * X DevAPI: The connection property enabledTLSProtocols can now be used to select the allowed TLS versions for an X Protocol connection to the server. * Connector/J now supports the new caching_sha2_password authentication plugin, which is the default authentication plugin for MySQL 8.0.4 and later (see Caching SHA-2 Pluggable Authentication (http://dev.mysql.com/doc/refman/8.0/en/caching-sha2-plug gable-authentication.html) for details). Note To authenticate accounts with the caching_sha2_password plugin, either a secure connection to the server using SSL (http://dev.mysql.com/doc/connector-j/8.0/en/connector-j-reference-using-ssl.html) or an unencrypted connection that supports password exchange using an RSA key pair (enabled by setting one or both of the connecting properties allowPublicKeyRetrieval and serverRSAPublicKeyFile) must be used. Because earlier versions of Connector/J 8.0 do not support the caching_sha2_password authentication plugin and therefore will not be able to connect to accounts that authenticate with the new plugin (which might include the root account created by default during a new installation of a MySQL 8.0 Server), it is highly recommended that you upgrade now to Connector/J 8.0.9, to help ensure that your applications
MySQL Connector/Net 8.0.10-rc has been released
Dear MySQL users, MySQL Connector/Net 8.0.10 is the first release candidate of MySQL Connector/Net to add support for the new X DevAPI. The X DevAPI enables application developers to write code that combines the strengths of the relational and document models using a modern, NoSQL-like syntax that does not assume previous experience writing traditional SQL. To learn more about how to write applications using the X DevAPI, see http://dev.mysql.com/doc/x-devapi-userguide/en/index.html. For more information about how the X DevAPI is implemented in Connector/Net, see http://dev.mysql.com/doc/dev/connector-net. Please note that the X DevAPI requires at least MySQL Server version 5.7.12 or higher with the X Plugin enabled. For general documentation about how to get started using MySQL as a document store, see http://dev.mysql.com/doc/refman/5.7/en/document-store.html. To download MySQL Connector/Net 8.0.10-rc, see the "Development Releases" tab at http://dev.mysql.com/downloads/connector/net/ Changes in MySQL Connector/Net 8.0.10 (2018-01-30, Release Candidate) Functionality Added or Changed * The .NET Core 2.0 implementation now supports the following connection-string options: AutoEnlist, InteractiveSession, Logging, Replication, and UseUsageAdvisor. For more information about the options, see Connector/Net Connection-String Options Reference (http://dev.mysql.com/doc/connector-net/en/connector-net-connection-options.html). (Bug #27297337) * X DevAPI: In the process of refining the definition of the X DevAPI to cover the most relevant usage scenarios, the following API components have been removed from the X DevAPI implementation for MySQL Connector/Net: + API components that support session configurations The MySqlX.XDevAPI.Config namespace and all members of the namespace. + API components that support views CreateView(), DropView(), and ModifyView() methods from the MySqlX.XDevAPI.Schema class. ViewAlgorithm, ViewSqlSecurityEnum, and ViewCheckOptionEnum enumerations from the MySqlX.DataAccess namespace. Note The Table.IsView property remains available for query operations. * Support for .NET Core 2.0 and .NET Standard 2.0 has been added (.NET Core 1.1 support continues). With .NET Core 2.0, most of the common ADO.NET classes are available for use, such as: + System.Data.DataTable, System.Data.DataColumn, and System.Data.DataRow + System.Data.DataSet + System.Data.Common.DataAdapter * Support for Entity Framework Core 2.0 has been added (Entity Framework 1.1 support continues). Currently, the MySQL Connector/Net implementation excludes the following 2.0 features: + Modeling: table splitting, owned types, model-level query filters, database scalar function mapping, self-contained type configuration for code first. + High performance: DbContext pooling and explicitly compiled queries. + Change tracking: attach can track a graph of new and existing entities. + Query: improved LINQ translation, group-join improvements, string interpolation in FromSql and ExecuteSqlCommand, new EF.Functions.Like(). + Database management: pluralization hook for DbContext scaffolding. + Others: only one provider per model, consolidated logging and diagnostics. * X DevAPI: MySQL Connector/Net now supports setting and releasing named transaction savepoints, which can be assigned a name explicitly or by default using the savepoint_(uuid) format. In addition, a transaction can be rolled back to a named savepoint. New methods were added to the MySqlX.XDevAPI.BaseSession class to implement corresponding SQL statements using the X Protocol: + SetSavepoint() and SetSavepoint(name) correspond to the SAVEPOINT statement. + ReleaseSavepoint() corresponds to the RELEASE SAVEPOINT statement. + RollbackTo() corresponds to the ROLLBACK TO statement. All errors generated by MySQL when one of the new methods is called will be returned by MySQL Connector/Net. * X DevAPI: The MySqlX.XDevAPI.CRUD.ModifyStatement.Patch method was added to enable the inclusion of JSON-like objects within Collection.Modify() operations that describe the changes to apply to all documents matching the condition. * Support for the caching_sha2_password authentication plugin through the classic MySQL protocol was added. Support through the X Protocol is limited to secure connections only (sslmode=required). C
