要使用 Microsoft JDBC Driver for SQL Server，需要安装对应的驱动和Java Runtime Environment (JRE)。从9.2版开始，支持JDK 15.0和JRE 15.0。此外，不同版本的驱动对应不同的JRE版本，例如JDBC Driver 8.4支持JRE 14.0，JDBC Driver 6.4则需要JRE 9.0。驱动还兼容多种操作系统和Java虚拟机。
JDBC 驱动程序的系统要求System requirements for the JDBC driver
01/29/2021
本文内容
若要使用 SQL ServerSQL Server 访问 Azure SQL 数据库Azure SQL Database 或 Microsoft JDBC Driver for SQL ServerMicrosoft JDBC Driver for SQL Server 中的数据，计算机上必须安装有下列组件：To access data from a SQL ServerSQL Server or Azure SQL 数据库Azure SQL Database by using the Microsoft JDBC Driver for SQL ServerMicrosoft JDBC Driver for SQL Server, you must have the following components installed on your computer:
Microsoft JDBC Driver for SQL ServerMicrosoft JDBC Driver for SQL Server(下载)
Java Runtime EnvironmentJava Runtime Environment
Java Runtime Environment 要求Java Runtime Environment requirements
自 Microsoft JDBC Driver 9.2 for SQL Server 起，支持 Java 开发工具包 (JDK) 15.0 和 Java Runtime Environment (JRE) 15.0。Starting with the Microsoft JDBC Driver 9.2 for SQL Server, Java Development Kit (JDK) 15.0 and Java Runtime Environment (JRE) 15.0 are supported.
自 Microsoft JDBC Driver 8.4 for SQL Server 起，支持 Java 开发工具包 (JDK) 14.0 和 Java Runtime Environment (JRE) 14.0。Starting with the Microsoft JDBC Driver 8.4 for SQL Server, Java Development Kit (JDK) 14.0 and Java Runtime Environment (JRE) 14.0 are supported.
自 Microsoft JDBC Driver 8.2 for SQL Server 起，支持 Java 开发工具包 (JDK) 13.0 和 Java Runtime Environment (JRE) 13.0。Starting with the Microsoft JDBC Driver 8.2 for SQL Server, Java Development Kit (JDK) 13.0 and Java Runtime Environment (JRE) 13.0 are supported.
自 Microsoft JDBC Driver 7.4 for SQL Server 起，支持 Java 开发工具包 (JDK) 12.0 和 Java 运行时环境 (JRE) 12.0。Starting with the Microsoft JDBC Driver 7.4 for SQL Server, Java Development Kit (JDK) 12.0 and Java Runtime Environment (JRE) 12.0 are supported.
自 Microsoft JDBC Driver 7.2 for SQL Server 起，支持 Java 开发工具包 (JDK) 11.0 和 Java 运行时环境 (JRE) 11.0。Starting with the Microsoft JDBC Driver 7.2 for SQL Server, Java Development Kit (JDK) 11.0 and Java Runtime Environment (JRE) 11.0 are supported.
自 Microsoft JDBC Driver 7.0 for SQL Server 起，支持 Java 开发工具包 (JDK) 10.0 和 Java 运行时环境 (JRE) 10.0。Starting with the Microsoft JDBC Driver 7.0 for SQL Server, Java Development Kit (JDK) 10.0 and Java Runtime Environment (JRE) 10.0 are supported.
自 Microsoft JDBC Driver 6.4 for SQL Server 起，支持 Java 开发工具包 (JDK) 9.0 和 Java 运行时环境 (JRE) 9.0。Starting with the Microsoft JDBC Driver 6.4 for SQL Server, Java Development Kit (JDK) 9.0 and Java Runtime Environment (JRE) 9.0 are supported.
自 Microsoft JDBC Driver 4.2 for SQL Server 起，支持 Java 开发工具包 (JDK) 8.0 和 Java 运行时环境 (JRE) 8.0。Starting with the Microsoft JDBC Driver 4.2 for SQL Server, Java Development Kit (JDK) 8.0 and Java Runtime Environment (JRE) 8.0 are supported. 对 JDBC 规范 API 的支持已扩展为包含 JDBC 4.1 和 4.2 API。Support for JDBC Spec API has been extended to include the JDBC 4.1 and 4.2 API.
自 Microsoft JDBC Driver 4.1 for SQL Server 起，支持 Java 开发工具包 (JDK) 7.0 和 Java 运行时环境 (JRE) 7.0。Starting with the Microsoft JDBC Driver 4.1 for SQL Server, Java Development Kit (JDK) 7.0 and Java Runtime Environment (JRE) 7.0 are supported.
从 {1}Microsoft JDBC Driver 4.0 for SQL Server{2}Microsoft JDBC Driver 4.0 for SQL Server 开始，JDBC 规范 API 的JDBC 驱动程序支持扩展为包含 JDBC 4.0 API。Starting with the {1}Microsoft JDBC Driver 4.0 for SQL Server{2}Microsoft JDBC Driver 4.0 for SQL Server, the JDBC driver support for JDBC Spec API has been extended to include the JDBC 4.0 API. 已在 Java 开发工具包 (JDK) 6.0 和 Java 运行时环境 (JRE) 6.0 中引入了 JDBC 4.0 API。The JDBC 4.0 API was introduced as part of the Java Development Kit (JDK) 6.0 and Java Runtime Environment (JRE) 6.0. JDBC 4.0 是 JDBC 3.0 API 的超集。JDBC 4.0 is a superset of the JDBC 3.0 API.
当你在 Windows 和 UNIX 操作系统上部署 Microsoft JDBC Driver for SQL ServerMicrosoft JDBC Driver for SQL Server 时，你必须分别使用安装包 sqljdbc_enu.exe 和 sqljdbcenu.tar.gz。When you deploy the Microsoft JDBC Driver for SQL ServerMicrosoft JDBC Driver for SQL Server on Windows and UNIX operating systems, you must use the installation packages, *sqljdbcenu.exe*, and *sqljdbc_enu.tar.gz*, respectively. 若要详细了解如何部署 JDBC 驱动程序，请参阅部署 JDBC 驱动程序主题。For more information about how to deploy the JDBC Driver, see Deploying the JDBC driver topic.
Microsoft JDBC Driver 9.2 for SQL Server：Microsoft JDBC Driver 9.2 for SQL Server:
JDBC Driver 9.2 在每个安装包中包含三个 JAR 类库：mssql-jdbc-9.2.0.jre8.jar、mssql-jdbc-9.2.0.jre11.jar 和 mssql-jdbc-9.2.0.jre15.jar 。The JDBC Driver 9.2 includes three JAR class libraries in each installation package: mssql-jdbc-9.2.0.jre8.jar, mssql-jdbc-9.2.0.jre11.jar, and mssql-jdbc-9.2.0.jre15.jar.
JDBC Driver 9.2 适用于各种主要 Java 虚拟机，且受到这些虚拟机的支持，但仅在 OpenJDK 1.8、OpenJDK 11.0、OpenJDK 15.0、Azul Zulu JRE 1.8、Azul Zulu JRE 11.0 和 Azul Zulu JRE 15.0 上经过测试。The JDBC Driver 9.2 is designed to work with and be supported by all major Java virtual machines, but is tested only on OpenJDK 1.8, OpenJDK 11.0, OpenJDK 15.0, Azul Zulu JRE 1.8, Azul Zulu JRE 11.0, and Azul Zulu JRE 15.0.
下表汇总了 Microsoft JDBC Driver 9.2 for SQL Server 随附的两个 JAR 文件所提供的支持：The following chart summarizes support provided by the two JAR files included with Microsoft JDBC Drivers 9.2 for SQL Server:
JARJAR
JDBC 版本法规遵从性JDBC Version Compliance
推荐的 Java 版本Recommended Java Version
说明Description
mssql-jdbc-9.2.0.jre8.jarmssql-jdbc-9.2.0.jre8.jar
4.24.2
88
需要 Java Runtime Environment (JRE) 1.8。Requires a Java Runtime Environment (JRE) 1.8. 使用 JRE 1.7 或更低版本会引发异常。Using JRE 1.7 or lower throws an exception.
9.2 中的新功能包括：JDK 15 支持、Azure Active Directory 交互式身份验证支持、Azure Active Directory 服务主体身份验证支持以及适用于非 Azure Synapse Analytics 服务器的 useBulkCopyForBatchInsert 支持。New Features in 9.2 include: JDK 15 support, support for Azure Active Directory Interactive Authentication, support for Azure Active Directory Service Principal Authentication, and support for useBulkCopyForBatchInsert for non-Azure Synapse Analytics servers.
mssql-jdbc-9.2.0.jre11.jarmssql-jdbc-9.2.0.jre11.jar
4.34.3
1111
需要 Java 运行时环境 (JRE) 11.0.Requires a Java Runtime Environment (JRE) 11.0. 使用 JRE 10.0 或更低版本会引发异常。Using JRE 10.0 or lower throws an exception.
9.2 中的新功能包括：JDK 15 支持、Azure Active Directory 交互式身份验证支持、Azure Active Directory 服务主体身份验证支持以及适用于非 Azure Synapse Analytics 服务器的 useBulkCopyForBatchInsert 支持。New Features in 9.2 include: JDK 15 support, support for Azure Active Directory Interactive Authentication, support for Azure Active Directory Service Principal Authentication, and support for useBulkCopyForBatchInsert for non-Azure Synapse Analytics servers.
mssql-jdbc-9.2.0.jre15.jarmssql-jdbc-9.2.0.jre15.jar
4.34.3
1515
需要 Java Runtime Environment (JRE) 15.0。Requires a Java Runtime Environment (JRE) 15.0. 使用 JRE 14.0 或更低版本会引发异常。Using JRE 14.0 or lower throws an exception.
9.2 中的新功能包括：JDK 15 支持、Azure Active Directory 交互式身份验证支持、Azure Active Directory 服务主体身份验证支持以及适用于非 Azure Synapse Analytics 服务器的 useBulkCopyForBatchInsert 支持。New Features in 9.2 include: JDK 15 support, support for Azure Active Directory Interactive Authentication, support for Azure Active Directory Service Principal Authentication, and support for useBulkCopyForBatchInsert for non-Azure Synapse Analytics servers.
JDBC Driver 9.2 还适用于 Maven Central Repository，并且可以通过在 POM.XML 中添加以下代码来添加到 Maven 项目：The JDBC Driver 9.2 is also available on the Maven Central Repository and can be added to a Maven project by adding the following code in the POM.XML:
com.microsoft.sqlserver
mssql-jdbc
9.2.0.jre11
Microsoft JDBC Driver 8.4 for SQL Server：Microsoft JDBC Driver 8.4 for SQL Server:
JDBC Driver 8.4 在每个安装包中包含三个 JAR 类库：mssql-jdbc-8.4.1.jre8.jar、mssql-jdbc-8.4.1.jre11.jar 和 mssql-jdbc-8.4.1.jre14.jar。The JDBC Driver 8.4 includes three JAR class libraries in each installation package: mssql-jdbc-8.4.1.jre8.jar, mssql-jdbc-8.4.1.jre11.jar, and mssql-jdbc-8.4.1.jre14.jar.
JDBC Driver 8.4 适用于各种主要 Java 虚拟机，且受到这些虚拟机的支持，但仅在 OpenJDK 1.8、OpenJDK 11.0、OpenJDK 14.0、Azul Zulu JRE 1.8、Azul Zulu JRE 11.0 和 Azul Zulu JRE 14.0 上经过测试。The JDBC Driver 8.4 is designed to work with and be supported by all major Java virtual machines, but is tested only on OpenJDK 1.8, OpenJDK 11.0, OpenJDK 14.0, Azul Zulu JRE 1.8, Azul Zulu JRE 11.0, and Azul Zulu JRE 14.0.
下表汇总了 Microsoft JDBC Driver 8.4 for SQL Server 随附的两个 JAR 文件所提供的支持：The following chart summarizes support provided by the two JAR files included with Microsoft JDBC Drivers 8.4 for SQL Server:
JARJAR
JDBC 版本法规遵从性JDBC Version Compliance
推荐的 Java 版本Recommended Java Version
说明Description
mssql-jdbc-8.4.1.jre8.jarmssql-jdbc-8.4.1.jre8.jar
4.24.2
88
需要 Java Runtime Environment (JRE) 1.8。Requires a Java Runtime Environment (JRE) 1.8. 使用 JRE 1.7 或更低版本会引发异常。Using JRE 1.7 or lower throws an exception.
8.4 中的新功能包括：JDK 14 支持、支持使用托管标识进行 Azure Key Vault 身份验证、扩展了 Azure 数据仓库大容量复制支持、Azure SQL DNS 缓存、流式处理 LOB 对象支持向后兼容性，以及用于环回方案的客户端证书身份验证。New Features in 8.4 include: JDK 14 support, support for authentication to Azure Key Vault using Managed Identity, extended support for bulk copy for Azure Data Warehouse, Azure SQL DNS caching, support for backwards compatibility for streaming LOB objects, and client certificate authentication for loopback scenarios.
mssql-jdbc-8.4.1.jre11.jarmssql-jdbc-8.4.1.jre11.jar
4.34.3
1111
需要 Java 运行时环境 (JRE) 11.0.Requires a Java Runtime Environment (JRE) 11.0. 使用 JRE 10.0 或更低版本会引发异常。Using JRE 10.0 or lower throws an exception.
8.4 中的新功能包括：JDK 14 支持、支持使用托管标识进行 Azure Key Vault 身份验证、扩展了 Azure 数据仓库大容量复制支持、Azure SQL DNS 缓存、流式处理 LOB 对象支持向后兼容性，以及用于环回方案的客户端证书身份验证。New Features in 8.4 include: JDK 14 support, support for authentication to Azure Key Vault using Managed Identity, extended support for bulk copy for Azure Data Warehouse, Azure SQL DNS caching, support for backwards compatibility for streaming LOB objects, and client certificate authentication for loopback scenarios.
mssql-jdbc-8.4.1.jre13.jarmssql-jdbc-8.4.1.jre13.jar
4.34.3
1414
需要 Java Runtime Environment (JRE) 14.0。Requires a Java Runtime Environment (JRE) 14.0. 使用 JRE 13.0 或更低版本会引发异常。Using JRE 13.0 or lower throws an exception.
8.4 中的新功能包括：JDK 14 支持、支持使用托管标识进行 Azure Key Vault 身份验证、扩展了 Azure 数据仓库大容量复制支持、Azure SQL DNS 缓存、流式处理 LOB 对象支持向后兼容性，以及用于环回方案的客户端证书身份验证。New Features in 8.4 include: JDK 14 support, support for authentication to Azure Key Vault using Managed Identity, extended support for bulk copy for Azure Data Warehouse, Azure SQL DNS caching, support for backwards compatibility for streaming LOB objects, and client certificate authentication for loopback scenarios.
JDBC Driver 8.4 还适用于 Maven Central Repository，并且可以通过在 POM.XML 中添加以下代码来添加到 Maven 项目：The JDBC Driver 8.4 is also available on the Maven Central Repository and can be added to a Maven project by adding the following code in the POM.XML:
com.microsoft.sqlserver
mssql-jdbc
8.4.1.jre11
Microsoft JDBC Driver 8.2 for SQL Server：Microsoft JDBC Driver 8.2 for SQL Server:
JDBC Driver 8.2 在每个安装包中包含三个 JAR 类库：mssql-JDBC-8.2.2.jre8.JAR、mssql-JDBC-8.2.2.jre11.JAR 和 mssql-JDBC-8.2.2.jre13.JAR 。The JDBC Driver 8.2 includes three JAR class libraries in each installation package: mssql-jdbc-8.2.2.jre8.jar, mssql-jdbc-8.2.2.jre11.jar, and mssql-jdbc-8.2.2.jre13.jar.
JDBC Driver 8.2 适用于各种主要 Java 虚拟机，且受到这些虚拟机的支持，但仅在 OpenJDK 1.8、OpenJDK 11.0、OpenJDK 13.0、Azul Zulu JRE 1.8、Azul Zulu JRE 11.0 和 Azul Zulu JRE 13.0 上经过测试。The JDBC Driver 8.2 is designed to work with and be supported by all major Java virtual machines, but is tested only on OpenJDK 1.8, OpenJDK 11.0, OpenJDK 13.0, Azul Zulu JRE 1.8, Azul Zulu JRE 11.0, and Azul Zulu JRE 13.0.
下表汇总了 Microsoft JDBC Driver 8.2 for SQL Server 随附的两个 JAR 文件所提供的支持：The following chart summarizes support provided by the two JAR files included with Microsoft JDBC Drivers 8.2 for SQL Server:
JARJAR
JDBC 版本法规遵从性JDBC Version Compliance
推荐的 Java 版本Recommended Java Version
说明Description
mssql-jdbc-8.2.2.jre8.jarmssql-jdbc-8.2.2.jre8.jar
4.24.2
88
需要 Java Runtime Environment (JRE) 1.8。Requires a Java Runtime Environment (JRE) 1.8. 使用 JRE 1.7 或更低版本会引发异常。Using JRE 1.7 or lower throws an exception.
8.2 中的新功能包括：JDK 13 支持、具有安全 Enclave 的 Always Encrypted 和临时数据类型性能改进。New Features in 8.2 include: JDK 13 support, Always Encrypted with Secure Enclaves, and temporal datatype performance improvements.
mssql-jdbc-8.2.2.jre11.jarmssql-jdbc-8.2.2.jre11.jar
4.34.3
1111
需要 Java 运行时环境 (JRE) 11.0.Requires a Java Runtime Environment (JRE) 11.0. 使用 JRE 10.0 或更低版本会引发异常。Using JRE 10.0 or lower throws an exception.
8.2 中的新功能包括：JDK 13 支持、具有安全 Enclave 的 Always Encrypted 和临时数据类型性能改进。New Features in 8.2 include: JDK 13 support, Always Encrypted with Secure Enclaves, and temporal datatype performance improvements.
mssql-jdbc-8.2.2.jre13.jarmssql-jdbc-8.2.2.jre13.jar
4.34.3
1313
需要 Java Runtime Environment (JRE) 13.0。Requires a Java Runtime Environment (JRE) 13.0. 使用 JRE 11.0 或更低版本会引发异常。Using JRE 11.0 or lower throws an exception.
8.2 中的新功能包括：JDK 13 支持、具有安全 Enclave 的 Always Encrypted 和临时数据类型性能改进。New Features in 8.2 include: JDK 13 support, Always Encrypted with Secure Enclaves, and temporal datatype performance improvements.
JDBC Driver 8.2 还适用于 Maven Central Repository，并且可以通过在 POM.XML 中添加以下代码来添加到 Maven 项目：The JDBC Driver 8.2 is also available on the Maven Central Repository and can be added to a Maven project by adding the following code in the POM.XML:
com.microsoft.sqlserver
mssql-jdbc
8.2.2.jre11
Microsoft JDBC Driver 7.4 for SQL Server：Microsoft JDBC Driver 7.4 for SQL Server:
JDBC Driver 7.4 在每个安装包中包含三个 JAR 类库：mssql-jdbc-7.4.1.jre8.jar、mssql-jdbc-7.4.1.jre11.jar 和 mssql-jdbc-7.4.1.jre12.jar。The JDBC Driver 7.4 includes three JAR class libraries in each installation package: mssql-jdbc-7.4.1.jre8.jar, mssql-jdbc-7.4.1.jre11.jar, and mssql-jdbc-7.4.1.jre12.jar.
JDBC Driver 7.4 适用于各种主要 Java 虚拟机，且受到这些虚拟机的支持，但仅在 OpenJDK 1.8、OpenJDK 11.0、OpenJDK 12.0、Azul Zulu JRE 1.8、Azul Zulu JRE 11.0 和 Azul Zulu JRE 12.0 上经过测试。The JDBC Driver 7.4 is designed to work with and be supported by all major Java virtual machines, but is tested only on OpenJDK 1.8, OpenJDK 11.0, OpenJDK 12.0, Azul Zulu JRE 1.8, Azul Zulu JRE 11.0, and Azul Zulu JRE 12.0.
下表汇总了 Microsoft JDBC Driver 7.4 for SQL Server 随附的两个 JAR 文件所提供的支持：The following chart summarizes support provided by the two JAR files included with Microsoft JDBC Drivers 7.4 for SQL Server:
JARJAR
JDBC 版本法规遵从性JDBC Version Compliance
推荐的 Java 版本Recommended Java Version
说明Description
mssql-jdbc-7.4.1.jre8.jarmssql-jdbc-7.4.1.jre8.jar
4.24.2
88
需要 Java Runtime Environment (JRE) 1.8。Requires a Java Runtime Environment (JRE) 1.8. 使用 JRE 1.7 或更低版本会引发异常。Using JRE 1.7 or lower throws an exception.
7.4 中的新功能包括：JDK 12 支持、NTLM 身份验证和 useFmtOnly。New Features in 7.4 include: JDK 12 support, NTLM authentication, and useFmtOnly.
mssql-jdbc-7.4.1.jre11.jarmssql-jdbc-7.4.1.jre11.jar
4.34.3
1111
需要 Java 运行时环境 (JRE) 11.0.Requires a Java Runtime Environment (JRE) 11.0. 使用 JRE 10.0 或更低版本会引发异常。Using JRE 10.0 or lower throws an exception.
7.4 中的新功能包括：JDK 12 支持、NTLM 身份验证和 useFmtOnly。New Features in 7.4 include: JDK 12 support, NTLM authentication, and useFmtOnly.
mssql-jdbc-7.4.1.jre12.jarmssql-jdbc-7.4.1.jre12.jar
4.34.3
1212
需要 Java Runtime Environment (JRE) 12.0。Requires a Java Runtime Environment (JRE) 12.0. 使用 JRE 11.0 或更低版本会引发异常。Using JRE 11.0 or lower throws an exception.
7.4 中的新功能包括：JDK 12 支持、NTLM 身份验证和 useFmtOnly。New Features in 7.4 include: JDK 12 support, NTLM authentication, and useFmtOnly.
JDBC Driver 7.4 还适用于 Maven Central Repository，并且可以通过在 POM.XML 中添加以下代码来添加到 Maven 项目：The JDBC Driver 7.4 is also available on the Maven Central Repository and can be added to a Maven project by adding the following code in the POM.XML:
com.microsoft.sqlserver
mssql-jdbc
7.4.1.jre11
Microsoft JDBC Driver 7.2 for SQL Server：Microsoft JDBC Driver 7.2 for SQL Server:
JDBC Driver 7.2 在每个安装包内有两个 JAR 类库：mssql-jdbc-7.2.2.jre8.jar 和 mssql-jdbc-7.2.2.jre11.jar。The JDBC Driver 7.2 includes two JAR class libraries in each installation package: mssql-jdbc-7.2.2.jre8.jar, and mssql-jdbc-7.2.2.jre11.jar.
JDBC Driver 7.2 适用于各种主要 Java 虚拟机，且受到这些虚拟机的支持，但仅在 OpenJDK 8.0、OpenJDK 11.0、Azul Zulu JRE 8.0 和 Azul Zulu JRE 11.0 上经过测试。The JDBC Driver 7.2 is designed to work with and be supported by all major Java virtual machines, but is tested only on OpenJDK 8.0, OpenJDK 11.0, Azul Zulu JRE 8.0, and Azul Zulu JRE 11.0.
下表汇总了 Microsoft JDBC Driver 7.2 for SQL Server 随附的两个 JAR 文件所提供的支持：The following chart summarizes support provided by the two JAR files included with Microsoft JDBC Drivers 7.2 for SQL Server:
JARJAR
JDBC 版本法规遵从性JDBC Version Compliance
推荐的 Java 版本Recommended Java Version
说明Description
mssql-jdbc-7.2.2.jre8.jarmssql-jdbc-7.2.2.jre8.jar
4.24.2
88
需要 Java Runtime Environment (JRE) 8.0。Requires a Java Runtime Environment (JRE) 8.0. 使用 JRE 7.0 或更低版本会引发异常。Using JRE 7.0 or lower throws an exception.
7.2 中的新功能包括：JDK 11 支持、Active Directory 托管标识 (MSI) 身份验证、OSGi 支持、SQLServerError API。New Features in 7.2 include: JDK 11 support, Active Directory Managed Identity (MSI) authentication, OSGi support, SQLServerError APIs.
mssql-jdbc-7.2.2.jre11.jarmssql-jdbc-7.2.2.jre11.jar
4.34.3
1010
需要 Java 运行时环境 (JRE) 11.0.Requires a Java Runtime Environment (JRE) 11.0. 使用 JRE 10.0 或更低版本会引发异常。Using JRE 10.0 or lower throws an exception.
7.2 中的新功能包括：JDK 11 支持、Active Directory 托管标识 (MSI) 身份验证、OSGi 支持、SQLServerError API。New Features in 7.2 include: JDK 11 support, Active Directory Managed Identity (MSI) authentication, OSGi support, SQLServerError APIs.
JDBC Driver 7.2 还适用于 Maven Central Repository，并且可以通过在 POM.XML 中添加以下代码来添加到 Maven 项目：The JDBC Driver 7.2 is also available on the Maven Central Repository and can be added to a Maven project by adding the following code in the POM.XML:
com.microsoft.sqlserver
mssql-jdbc
7.2.2.jre11
Microsoft JDBC Driver 7.0 for SQL Server：Microsoft JDBC Driver 7.0 for SQL Server:
JDBC Driver 7.0 在每个安装包中包含两个 JAR 类库：mssql-jdbc-7.0.0.jre8.jar 和 mssql-jdbc-7.0.0.jre10.jar。The JDBC Driver 7.0 includes two JAR class libraries in each installation package: mssql-jdbc-7.0.0.jre8.jar, and mssql-jdbc-7.0.0.jre10.jar.
JDBC Driver 7.0 专门适用于各种主要 Java 虚拟机且受到这些虚拟机的支持，但仅在 OpenJDK 8.0 和 10.0 上经过测试。The JDBC Driver 7.0 is designed to work with and be supported by all major Java virtual machines, but is tested only on OpenJDK 8.0, and 10.0.
下表汇总了 Microsoft JDBC Driver 7.0 for SQL Server 随附的两个 JAR 文件所提供的支持：The following chart summarizes support provided by the two JAR files included with Microsoft JDBC Drivers 7.0 for SQL Server:
JARJAR
JDBC 版本法规遵从性JDBC Version Compliance
推荐的 Java 版本Recommended Java Version
说明Description
mssql-jdbc-7.0.0.jre8.jarmssql-jdbc-7.0.0.jre8.jar
4.24.2
88
需要 Java Runtime Environment (JRE) 8.0。Requires a Java Runtime Environment (JRE) 8.0. 使用 JRE 7.0 或更低版本会引发异常。Using JRE 7.0 or lower throws an exception.
7.0 中的新增功能包括：JDK 10 支持、已将默认符合性级别更新为 JDBC 4.2 规范、空间数据类型支持、cancelQueryTimeout 连接属性、请求边界方法、useBulkCopyForBatchInsert 连接属性、数据发现和分类信息、UTF-8 功能扩展和 CityHash 支持。New Features in 7.0 include: JDK 10 support, updated default compliance level to JDBC 4.2 specifications, Spatial Datatypes support, cancelQueryTimeout connection property, Request Boundary methods, useBulkCopyForBatchInsert connection property, Data Discovery and Classification information, UTF-8 feature extension, and CityHash support.
mssql-jdbc-7.0.0.jre10.jarmssql-jdbc-7.0.0.jre10.jar
4.34.3
1010
需要 Java Runtime Environment (JRE) 10.0。Requires a Java Runtime Environment (JRE) 10.0. 使用 JRE 9.0 或更低版本会引发异常。Using JRE 9.0 or lower throws an exception.
7.0 中的新增功能包括：JDK 10 支持、已将默认符合性级别更新为 JDBC 4.2 规范、空间数据类型支持、cancelQueryTimeout 连接属性、请求边界方法、useBulkCopyForBatchInsert 连接属性、数据发现和分类信息、UTF-8 功能扩展和 CityHash 支持。New Features in 7.0 include: JDK 10 support, updated default compliance level to JDBC 4.2 specifications, Spatial Datatypes support, cancelQueryTimeout connection property, Request Boundary methods, useBulkCopyForBatchInsert connection property, Data Discovery and Classification information, UTF-8 feature extension, and CityHash support.
JDBC Driver 7.0 还适用于 Maven Central Repository，并且可以通过在 POM.XML 中添加以下代码来添加到 Maven 项目：The JDBC Driver 7.0 is also available on the Maven Central Repository and can be added to a Maven project by adding the following code in the POM.XML:
com.microsoft.sqlserver
mssql-jdbc
7.0.0.jre10
Microsoft JDBC Driver 6.4 for SQL Server：Microsoft JDBC Driver 6.4 for SQL Server:
JDBC Driver 6.4 在每个安装包中包含三个 JAR 类库：mssql-jdbc-6.4.0.jre7.jar、mssql-jdbc-6.4.0.jre8.jar 和 mssql-jdbc-6.4.0.jre9.jar。The JDBC Driver 6.4 includes three JAR class libraries in each installation package: mssql-jdbc-6.4.0.jre7.jar, mssql-jdbc-6.4.0.jre8.jar, and mssql-jdbc-6.4.0.jre9.jar.
JDBC Driver 6.4 专门适用于各种主要 Java 虚拟机且受到这些虚拟机的支持，但仅在 OpenJDK 7.0、8.0 和 9.0 上经过测试。The JDBC Driver 6.4 is designed to work with and be supported by all major Java virtual machines, but is tested only on OpenJDK 7.0, 8.0, and 9.0.
下表概述了由 Microsoft JDBC Driver 6.4 for SQL Server 附带的三个 JAR 文件提供的支持：The following chart summarizes support provided by the three JAR files included with Microsoft JDBC Drivers 6.4 for SQL Server:
JARJAR
JDBC 版本法规遵从性JDBC Version Compliance
推荐的 Java 版本Recommended Java Version
说明Description
mssql-jdbc-6.4.0.jre7.jarmssql-jdbc-6.4.0.jre7.jar
4.14.1
77
需要 Java Runtime Environment (JRE) 7.0。Requires a Java Runtime Environment (JRE) 7.0. 使用 JRE 6.0 或更低版本会引发异常。Using JRE 6.0 or lower throws an exception.
6.4 中的新功能包括：适用于 Linux 的 Azure AD 身份验证、Kerberos 的主体/密码方法、在跨域身份验证的 SPN 中自动检测领域、Kerberos 约束委派、查询超时、套接字超时和已准备好的语句句柄重复使用。New Features in 6.4 include: Azure AD authentication for Linux, Principal/Password method for Kerberos, automatic detection of REALM in SPN for Cross-Domain authentication, Kerberos Constrained Delegation, Query Timeout, Socket Timeout, and prepared statement handle reuse.
mssql-jdbc-6.4.0.jre8.jarmssql-jdbc-6.4.0.jre8.jar
4.24.2
88
需要 Java Runtime Environment (JRE) 8.0。Requires a Java Runtime Environment (JRE) 8.0. 使用 JRE 7.0 或更低版本会引发异常。Using JRE 7.0 or lower throws an exception.
6.4 中的新功能包括：适用于 Linux 的 Azure AD 身份验证、Kerberos 的主体/密码方法、在跨域身份验证的 SPN 中自动检测领域、Kerberos 约束委派、查询超时、套接字超时和已准备好的语句句柄重复使用。New Features in 6.4 include: Azure AD authentication for Linux, Principal/Password method for Kerberos, automatic detection of REALM in SPN for Cross-Domain authentication, Kerberos Constrained Delegation, Query Timeout, Socket Timeout, and prepared statement handle reuse.
mssql-jdbc-6.4.0.jre9.jarmssql-jdbc-6.4.0.jre9.jar
4.34.3
99
需要 Java Runtime Environment (JRE) 9.0。Requires a Java Runtime Environment (JRE) 9.0. 使用 JRE 8.0 或更低版本会引发异常。Using JRE 8.0 or lower throws an exception.
6.4 中的新功能包括：适用于 Linux 的 Azure AD 身份验证、Kerberos 的主体/密码方法、在跨域身份验证的 SPN 中自动检测领域、Kerberos 约束委派、查询超时、套接字超时和已准备好的语句句柄重复使用。New Features in 6.4 include: Azure AD authentication for Linux, Principal/Password method for Kerberos, automatic detection of REALM in SPN for Cross-Domain authentication, Kerberos Constrained Delegation, Query Timeout, Socket Timeout, and prepared statement handle reuse.
JDBC Driver 6.4 还适用于 Maven Central Repository，并且可以通过在 POM.XML 中添加以下代码来添加到 Maven 项目The JDBC Driver 6.4 is also available on the Maven Central Repository and can be added to a Maven project by adding the following code in the POM.XML
com.microsoft.sqlserver
mssql-jdbc
6.4.0.jre9
Microsoft JDBC Driver 6.2 for SQL Server：Microsoft JDBC Driver 6.2 for SQL Server:
JDBC Driver 6.2 在每个安装包中包含两个 JAR 类库：mssql-jdbc-6.2.2.jre7.jar 和 mssql-jdbc-6.2.2.jre8.jar。The JDBC Driver 6.2 includes two JAR class libraries in each installation package: mssql-jdbc-6.2.2.jre7.jar, and mssql-jdbc-6.2.2.jre8.jar.
JDBC Driver 6.2 专门适用于各种主要 Java 虚拟机且受到这些虚拟机的支持，但仅在 Sun JRE 5.0、6.0、7.0 和 8.0 上经过测试。The JDBC Driver 6.2 is designed to work with and be supported by all major Java virtual machines, but is tested only on Sun JRE 5.0, 6.0, 7.0, and 8.0.
下表概述了由 Microsoft JDBC Driver for SQL Server 6.0 和 4.2 附带的两个 JAR 文件提供的支持：The following chart summarizes support provided by the two JAR files included with Microsoft JDBC Drivers 6.0 and 4.2 for SQL Server:
JARJAR
JDBC 版本法规遵从性JDBC Version Compliance
推荐的 Java 版本Recommended Java Version
说明Description
mssql-jdbc-6.2.2.jre7.jarmssql-jdbc-6.2.2.jre7.jar
4.14.1
77
需要 Java Runtime Environment (JRE) 7.0。Requires a Java Runtime Environment (JRE) 7.0. 使用 JRE 6.0 或更低版本会引发异常。Using JRE 6.0 or lower throws an exception.
6.2 中的新功能包括：适用于 Linux 的 Azure AD 身份验证、Kerberos 的主体/密码方法、在跨域身份验证的 SPN 中自动检测领域、Kerberos 约束委派、查询超时、套接字超时和已准备好的语句句柄重复使用。New Features in 6.2 include: Azure AD authentication for Linux, Principal/Password method for Kerberos, automatic detection of REALM in SPN for Cross-Domain authentication, Kerberos Constrained Delegation, Query Timeout, Socket Timeout, and prepared statement handle reuse.
mssql-jdbc-6.2.3.jre8.jarmssql-jdbc-6.2.3.jre8.jar
4.24.2
88
需要 Java Runtime Environment (JRE) 8.0。Requires a Java Runtime Environment (JRE) 8.0. 使用 JRE 7.0 或更低版本会引发异常。Using JRE 7.0 or lower throws an exception.
6.2 中的新功能包括：适用于 Linux 的 Azure AD 身份验证、Kerberos 的主体/密码方法、在跨域身份验证的 SPN 中自动检测领域、Kerberos 约束委派、查询超时、套接字超时和已准备好的语句句柄重复使用New Features in 6.2 include: Azure AD authentication for Linux, Principal/Password method for Kerberos, automatic detection of REALM in SPN for Cross-Domain authentication, Kerberos Constrained Delegation, Query Timeout, Socket Timeout, and prepared statement handle reuse
JDBC Driver 6.2 还适用于 Maven Central Repository，并且可以通过在 POM.XML 中添加以下代码来添加到 Maven 项目The JDBC Driver 6.2 is also available on the Maven Central Repository and can be added to a Maven project by adding the following code in the POM.XML
com.microsoft.sqlserver
mssql-jdbc
6.2.2.jre8
Microsoft JDBC Driver 6.0 and 4.2 for SQL Server：Microsoft JDBC Driver 6.0 and 4.2 for SQL Server:
JDBC Drivers 6.0 和 4.2 的每个安装包中都有两个 JAR 类库：sqljdbc41.jar 和 sqljdbc42.jar。The JDBC Drivers 6.0 and 4.2 include two JAR class libraries in each installation package: sqljdbc41.jar, and sqljdbc42.jar.
DBC Drivers 6.0 和 4.2 专门适用于各种主要 Java 虚拟机且受到这些虚拟机的支持，但仅在 Sun JRE 5.0、6.0、7.0 和 8.0 上经过测试。The JDBC Drivers 6.0 and 4.2 are designed to work with and be supported by all major Java virtual machines, but is tested only on Sun JRE 5.0, 6.0, 7.0, and 8.0.
下表概述了由 Microsoft JDBC Driver for SQL Server 6.0 和 4.2 附带的两个 JAR 文件提供的支持：The following chart summarizes support provided by the two JAR files included with Microsoft JDBC Drivers 6.0 and 4.2 for SQL Server:
JARJAR
JDBC 版本法规遵从性JDBC Version Compliance
推荐的 Java 版本Recommended Java Version
说明Description
sqljdbc41.jarsqljdbc41.jar
4.14.1
77
需要 Java Runtime Environment (JRE) 7.0。Requires a Java Runtime Environment (JRE) 7.0. 使用 JRE 6.0 或更低版本会引发异常。Using JRE 6.0 or lower throws an exception.
6.0 和 4.2 包中的新增功能包括：JDBC 4.1 符合性和大容量复制New Features in 6.0 & 4.2 packages include: JDBC 4.1 Compliance and Bulk Copy
此外，6.0 包中独有的新增功能包括：Always Encrypted、表值参数、Azure Active Directory 身份验证、与 AlwaysOn 可用性组的透明连接、已准备好的查询和国际化域名 (IDN) 的参数元数据检索的改进In Addition, new Features in only the 6.0 package include: Always Encrypted, Table-Valued Parameters, Azure Active Directory Authentication, transparent connections to Always On Availability Groups, improvement in parameter metadata retrieval for prepared queries and Internationalized Domain Name (IDN)
sqljdbc42.jarsqljdbc42.jar
4.24.2
88
需要 Java Runtime Environment (JRE) 8.0。Requires a Java Runtime Environment (JRE) 8.0. 使用 JRE 7.0 或更低版本会引发异常。Using JRE 7.0 or lower throws an exception.
6.0 和 4.2 包中的新增功能包括：JDBC 4.1 符合性、JDBC 4.2 符合性和大容量复制New Features in 6.0 & 4.2 packages include: JDBC 4.1 Compliance, JDBC 4.2 Compliance, and Bulk Copy
此外，6.0 包中独有的新增功能包括：Always Encrypted、表值参数、Azure Active Directory 身份验证、与 AlwaysOn 可用性组的透明连接、已准备好的查询和国际化域名 (IDN) 的参数元数据检索的改进In Addition, new Features in only the 6.0 package include: Always Encrypted, Table-Valued Parameters, Azure Active Directory Authentication, transparent connections to Always On Availability Groups, improvement in parameter metadata retrieval for prepared queries and Internationalized Domain Name (IDN)
Microsoft JDBC Driver 4.1 for SQL Server：Microsoft JDBC Driver 4.1 for SQL Server:
JDBC Driver 4.1 的每个安装包中都有一个 JAR 类库：sqljdbc41.jar。The JDBC Driver 4.1 includes one JAR class library in each installation package: sqljdbc41.jar.
JARJAR
说明Description
sqljdbc41.jarsqljdbc41.jar
sqljdbc41.jar 类库提供对 JDBC 4.0 API 的支持。sqljdbc41.jar class library provides support for JDBC 4.0 API. 它包含 JDBC 4.0 驱动程序的所有功能以及 JDBC 4.0 API 方法。It includes all of the features of the JDBC 4.0 driver and the JDBC 4.0 API methods. JDBC 4.1 不受支持(引发异常“SQLFeatureNotSupportedException”)。JDBC 4.1 is not supported (throws an exception "SQLFeatureNotSupportedException").
sqljdbc41.jar 类库要求使用 Java Runtime Environment (JRE) 7.0。sqljdbc41.jar class library requires a Java Runtime Environment (JRE) 7.0. 使用 JRE 6.0 和 5.0 上的 sqljdbc41.jar 引发异常。Using sqljdbc41.jar on JRE 6.0 and 5.0 throws an exception.
JDBC 驱动程序专门适用于各种主要 Java 虚拟机且受到这些虚拟机的支持，但是在 Sun JRE 5.0、6.0 和 7.0 上测试的。The JDBC driver is designed to work with and be supported by all major Java virtual machines, but is tested on Sun JRE 5.0, 6.0 and 7.0.
下表概述了由 Microsoft JDBC Driver 4.1 for SQL Server 附带的 JAR 文件提供的支持。The following chart summarizes support provided by the JAR file included with Microsoft JDBC Driver 4.1 for SQL Server.
JARJAR
JDBC 版本JDBC Version
JRE(可以运行)JRE (can run)
JDK(可以编译)JDK (can compile)
sqljdbc41.jarsqljdbc41.jar
44
77
7 6 57 6 5
SQL Server 要求SQL Server requirements
JDBC 驱动程序支持连接到 Azure SQL Database 和 SQL Server。The JDBC driver supports connections to Azure SQL database and SQL Server. 对于适用于 SQL Server 的 Microsoft JDBC Driver 4.2 和 4.1，该支持从 SQL Server 2008 开始。For Microsoft JDBC Driver 4.2 and 4.1 for SQL Server, support begins with SQL Server 2008.
操作系统要求Operating System requirements
JDBC 驱动程序可在任何支持使用 Java 虚拟机 (JVM) 的操作系统上工作。The JDBC driver is designed to work on any operating system that supports the use of a Java Virtual Machine (JVM). 但是，只有 Sun Solaris、SUSE Linux、Ubuntu Linux、CentOS Linux、macOS 以及 Windows 操作系统经过了官方测试。However, only Sun Solaris, SUSE Linux, Ubuntu Linux, CentOS Linux, macOS, and Windows operating systems have officially been tested.
支持的语言Supported languages
JDBC 驱动程序支持所有的 SQL ServerSQL Server 列排序规则。The JDBC driver supports all SQL ServerSQL Server column collations. 若要详细了解 JDBC 驱动程序支持的排序规则，请参阅 JDBC 驱动程序的国际功能。For more information about the collations supported by the JDBC driver, see International features of the JDBC driver.
有关排序规则的详细信息，请参阅 SQL ServerSQL Server 联机丛书中的“使用排序规则”。For more information about collations, see "Working with Collations" in SQL ServerSQL Server Books Online.
另请参阅See also
扫一扫
285
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
