MySQL Connector/J 8.0 开发指南：安装、配置和开发数据库应用

需积分: 10 187 浏览量更新于2024-07-17 收藏 475KB PDF 举报

MySQL Connector/J 8.0 开发者指南 MySQL Connector/J 8.0 是一个 JDBC 和 X DevAPI 驱动程序，用于与 MySQL 服务器进行通信。该驱动程序是高度推荐的用于 MySQL Server 8.0、5.7 和 5.6 的开发环境中。 **安装和配置** 在开始使用 MySQL Connector/J 8.0 之前，需要首先安装和配置驱动程序。安装过程可以从二进制分布式安装、使用 Maven 安装或从源代码安装。安装完成后，需要配置驱动程序以便与 MySQL 服务器进行通信。 **Connector/J 版本和支持的 MySQL 和 Java 版本** MySQL Connector/J 8.0 支持多个 MySQL 和 Java 版本。了解 Connector/J 的版本历史和支持的版本是非常重要的，以便选择适合的驱动程序版本。 **什么是新的 Connector/J 8.0？** Connector/J 8.0 带来了许多新的功能和改进，包括对 MySQL Server 8.0 的支持、改进的性能和安全性等。了解这些变化可以帮助开发者更好地使用 Connector/J 8.0。 **Connector/J 安装** Connector/J 安装可以从二进制分布式安装、使用 Maven 安装或从源代码安装。每种安装方法都有其特点和优缺点，选择合适的安装方法取决于开发者的需求和环境。 **升级到 Connector/J 8.0** 如果您已经使用了旧版本的 Connector/J，需要升级到 Connector/J 8.0。升级过程需要注意一些重要的细节，以确保升级成功。 **JDBC 和 X DevAPI** Connector/J 8.0 不仅是一个 JDBC 驱动程序，还提供了 X DevAPI，用于与 MySQL 服务器进行交互。了解 JDBC 和 X DevAPI 的区别和使用场景可以帮助开发者更好地使用 Connector/J 8.0。 **开发指南** 本指南提供了详细的开发指南，包括安装、配置、使用和升级 Connector/J 8.0。按照本指南可以帮助开发者快速掌握 Connector/J 8.0 的使用。 **法律信息** 本指南还提供了法律信息，包括许可信息和版权信息。了解这些信息可以帮助开发者遵守相关的法律规定。 **社区支持** 如果您在使用 Connector/J 8.0 时遇到了问题，可以访问 MySQL 论坛，そこで您可以与其他 MySQL 用户讨论问题和分享经验。

Installing from Source

• Protocol Buffers Java API 3.6.1 (protobuf-java-3.6.1.jar, available from, for example,

the Maven Central Repository at https://repo1.maven.org/maven2/com/google/protobuf/protobuf-

java/3.6.1/).

• C3P0 0.9.1 or newer (both c3p0-0.9.1.x.jar and c3p0-0.9.1.x.src.zip, available from

https://sourceforge.net/projects/c3p0/).

• JBoss common JDBC wrapper 3.2.3 or newer (jboss-common-jdbc-wrapper-3.2.3.jar,

available from, for example, the Maven Central Repository at http://central.maven.org/maven2/jboss/

jboss-common-jdbc-wrapper/).

• Simple Logging Facade API 1.6.1 or newer (slf4j-api-1.6.1.jar, available from https://

www.slf4j.org/download.html).

To build MySQL Connector/J from source, follow these steps:

1. Make sure that you have JDK 1.8.x installed.

2. Obtain the sources for Connector/J by one of the following means:

• Download the platform independent distribution archive (in .tar.gz or .zip format) for Connector/

J, which contains the sources, from the Connector/J Download page. Extract contents of the archive

into a folder named, for example, mysql-connector-j.

• Download a source RPM package for Connector/J from Connector/J Download page and install it.

• Check out the code from the source code repository for MySQL Connector/J located on GitHub at

https://github.com/mysql/mysql-connector-j. The latest release of the Connector/J 8.0 series is on the

release/8.0 branch; use the following command to check it out:

shell> git clone --branch release/8.0 https://github.com/mysql/mysql-connector-j.git

Under the current directory, the command creates a mysql-connector-j subdirectory , which

contains the code you want.

3. Place all the required third-party libraries in a separate directory—for example, /home/username/

ant-extralibs.

4. Change your current working directory to the mysql-connector-j directory created in step 2 above.

5. In the directory, create a file named build.properties to indicate to Ant the locations of the root

directories for your JDK 1.8.x installation, as well as the location of the extra libraries. The file should

contain the following property settings, with the “path_to_*” parts replaced by the appropriate file

paths:

com.mysql.cj.build.jdk=path_to_jdk_1.8

com.mysql.cj.extra.libs=path_to_folder_for_extra_libraries

Alternatively, you can set the values of those properties through the Ant -D options.

Note

Going from Connector/J 5.1 to 8.0, a number of Ant properties for building

Connector/J have been renamed or removed; see Section 4.4.1.4, “Changes for

Build Properties” for details.

Upgrading from an Older Version

6. Issue the following command to compile the driver and create a .jar file for Connector/J:

shell> ant dist

This creates a build directory in the current directory, where all the build output goes. A directory

is created under the build directory, whose name includes the version number of the release you

are building. That directory contains the sources, the compiled .class files, and a .jar file for

deployment.

For information on all the build targets, including those that create a fully packaged distribution, issue

the following command:

shell> ant -projecthelp

7. Install the newly created .jar file for the JDBC driver as you would install a binary .jar file you

download from MySQL by following the instructions given in Configuring the CLASSPATH or

Configuring Connector/J for Application Servers.

4.4 Upgrading from an Older Version

This section has information for users who are upgrading from one version of Connector/J to another,

or to a new version of the MySQL server that supports a more recent level of JDBC. A newer version of

Connector/J might include changes to support new features, improve existing functionality, or comply with

new standards.

4.4.1 Upgrading to MySQL Connector/J 8.0

Upgrading an application developed for Connector/J 5.1 to use Connector/J 8.0 might require certain

changes to your code or the environment in which it runs. Here are some changes for Connector/J going

from 5.1 to 8.0, for which adjustments might be required:

4.4.1.1 Running on the Java 8 Platform

Connector/J 8.0 is created specifically to run on the Java 8 platform. While Java 8 is known to be strongly

compatible with earlier Java versions, incompatibilities do exist, and code designed to work on Java 7

might need to be adjusted before being run on Java 8. Developers should refer to the incompatibility

information provided by Oracle.

4.4.1.2 Changes in Connection Properties

A complete list of Connector/J 8.0 connection properties are available in connector-j-reference-set-config.

The following are connection properties that have been changed (removed, added, have their names

changed, or have their default values changed) going from Connector/J 5.1 to 8.0.

Properties that have been removed (do not use them during connection):

• useDynamicCharsetInfo

• useBlobToStoreUTF8OutsideBMP , utf8OutsideBmpExcludedColumnNamePattern, and

utf8OutsideBmpIncludedColumnNamePattern: MySQL 5.6 and later supports the utf8mb4

character set, which is the character set that should be used by Connector/J applications for supporting

characters beyond the Basic Multilingual Plane (BMP) of Unicode Version 3.

• useJvmCharsetConverters: JVM character set conversion is now used in all cases

• The following date and time properties:

Upgrading to MySQL Connector/J 8.0

• The names of these commonly-used classes and interfaces have also been changed:

• ExceptionInterceptor: from com.mysql.jdbc.ExceptionInterceptor to

com.mysql.cj.exceptions.ExceptionInterceptor

• StatementInterceptor: from com.mysql.jdbc.StatementInterceptorV2 to

com.mysql.cj.interceptors.QueryInterceptor

• ConnectionLifecycleInterceptor: from com.mysql.jdbc.ConnectionLifecycleInterceptor to

com.mysql.cj.jdbc.interceptors.ConnectionLifecycleInterceptor

• AuthenticationPlugin: from com.mysql.jdbc.AuthenticationPlugin to

com.mysql.cj.protocol.AuthenticationPlugin

• BalanceStrategy: from com.mysql.jdbc.BalanceStrategy to

com.mysql.cj.jdbc.ha.BalanceStrategy

• MysqlDataSource: from com.mysql.jdbc.jdbc2.optional.MysqlDataSource to

com.mysql.cj.jdbc.MysqlDataSource

• MysqlDataSourceFactory: from com.mysql.jdbc.jdbc2.optional.MysqlDataSourceFactory

to com.mysql.cj.jdbc.MysqlDataSourceFactory

• MysqlConnectionPoolDataSource: from

com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource to

com.mysql.cj.jdbc.MysqlConnectionPoolDataSource

• MysqlXADataSource: from com.mysql.jdbc.jdbc2.optional.MysqlXADataSource to

com.mysql.cj.jdbc.MysqlXADataSource

• MysqlXid: from com.mysql.jdbc.jdbc2.optional.MysqlXid to

com.mysql.cj.jdbc.MysqlXid

4.4.1.4 Changes for Build Properties

A number of Ant properties for building Connector/J from source have been renamed; see Table 4.1,

“Changes with the Build Properties from Connector/J 5.1 to 8.0”

Table 4.1 Changes with the Build Properties from Connector/J 5.1 to 8.0

Old name New name

com.mysql.jdbc.extra.libs com.mysql.cj.extra.libs

com.mysql.jdbc.jdk com.mysql.cj.build.jdk

debug.enable com.mysql.cj.build.addDebugInfo

com.mysql.jdbc.noCleanBetweenCompiles com.mysql.cj.build.noCleanBetweenCompiles

com.mysql.jdbc.commercialBuild com.mysql.cj.build.commercial

com.mysql.jdbc.filterLicense com.mysql.cj.build.filterLicense

com.mysql.jdbc.noCryptoBuild com.mysql.cj.build.noCrypto

com.mysql.jdbc.noSources com.mysql.cj.build.noSources

com.mysql.jdbc.noMavenSources com.mysql.cj.build.noMavenSources

major_version com.mysql.cj.build.driver.version.major

minor_version com.mysql.cj.build.driver.version.minor

剩余135页未读，继续阅读

qq13174115

粉丝: 1
资源: 29

MySQL Connector/J 8.0 开发指南：安装、配置和开发数据库应用

jdbc-mysql-connector-j-8.0.31.jar jdbc-sqljdbc41.jar

mysql-connector-j-8.0.31.7z

mysql-connector-j-8.0.31

mysql-connector-java-8.0.34.jar

mysql-connector-java-8.0.31.jar

mysql-connector-java-8.0.jar下周

mysql-connector-java.jar下载8.0.34

mysql-connector-java-8.0.31jar放在那里

[root@node11 bin]# cp mysql-connector-java-8.0.25/mysql-connector-java-8.0.25.jar $SPARK_HOME/jars/ cp: 无法创建普通文件"/jars/": 不是目录

mysql-connector-java-8.0.34-jar包下载

最新资源