Release Information
Microsoft JDBC Driver 7.4 for SQL Server
August 2019
------------
INTRODUCTION
------------
This file contains late-breaking or other important information that supplements the Microsoft JDBC
Driver 7.4 for SQL Server documentation. You should read this file completely before installing
the JDBC driver.
Your feedback is very important to us and we will strive to respond to your feedback in a timely
manner. For information about providing feedback by using the JDBC driver blogs and online forums,
see the Microsoft JDBC Driver 7.4 for SQL Server page at https://aka.ms/mssql-jdbc-feedback
------------
INSTALLATION
------------
Instructions for installing the JDBC driver are located in install.txt. Refer to that file for
information about installing the JDBC driver on Windows, Linux and Mac operating systems.
---------------------------
SUPPORTED OPERATING SYSTEMS
---------------------------
Supported operating systems for Microsoft JDBC Driver 7.4 for SQL Server include:
Windows Server 2008 SP2
Windows Server 2008 R2 SP1
Windows Server 2012
Windows Server 2012 R2
Windows Server 2016
Windows Server 2019
Windows 8
Windows 8.1
Windows 10
Linux
Mac
The list above is an example of some of the supported operating systems. The JDBC driver is designed
to work on any operating system that supports the use of a Java Virtual Machine (JVM).
However, only the latest operating systems of Linux and Mac OS (Ubuntu 19.04, Ubuntu 18.10, CentOs 7, Suse 12,
macOS 10.14) have been tested for compatibility and support.
-----------------------
SUPPORTED JAVA VERSIONS
-----------------------
The Microsoft JDBC Driver 7.4 for SQL Server has been tested and supports latest versions of Java
Development Kit(JDK) builds from Open JDK and Zulu on supported Operating Systems as mentioned above.
The below family versions of Java Runtime Environment (JRE) System Library are supported:
----------------------------------------------------------------------
JRE Family Version | Driver JAR for Maximum Support
----------------------------------------------------------------------
8+ | mssql-jdbc-7.4.1.jre8.jar
11+ | mssql-jdbc-7.4.1.jre11.jar
12+ | mssql-jdbc-7.4.1.jre12.jar
----------------
RELEASE CONTENTS
----------------
The Microsoft JDBC Driver 7.4 for SQL Server executable zip or tar file unpacks the following files
in the specified locations, relative to the selected installation directory:
<installation directory>\sqljdbc_<version>\<language>\install.txt
<installation directory>\sqljdbc_<version>\<language>\release.txt
<installation directory>\sqljdbc_<version>\<language>\license.txt
<installation directory>\sqljdbc_<version>\<language>\thirdpartynotices.txt
<installation directory>\sqljdbc_<version>\<language>\mssql-jdbc-7.4.1.jre8.jar
<installation directory>\sqljdbc_<version>\<language>\mssql-jdbc-7.4.1.jre8-shaded.jar
<installation directory>\sqljdbc_<version>\<language>\mssql-jdbc-7.4.1.jre11.jar
<installation directory>\sqljdbc_<version>\<language>\mssql-jdbc-7.4.1.jre11-shaded.jar
<installation directory>\sqljdbc_<version>\<language>\mssql-jdbc-7.4.1.jre12.jar
<installation directory>\sqljdbc_<version>\<language>\mssql-jdbc-7.4.1.jre12-shaded.jar
<installation directory>\sqljdbc_<version>\<language>\auth\x86\sqljdbc_auth.dll
<installation directory>\sqljdbc_<version>\<language>\auth\x64\sqljdbc_auth.dll
<installation directory>\sqljdbc_<version>\<language>\samples\<sample files...>
<installation directory>\sqljdbc_<version>\<language>\xa\xa_install.sql
<installation directory>\sqljdbc_<version>\<language>\xa\x86\sqljdbc_xa.dll
<installation directory>\sqljdbc_<version>\<language>\xa\x64\sqljdbc_xa.dll
For detailed information about each component please refer to the online documentation,
Microsoft JDBC Driver for SQL Server Documentation:
https://msdn.microsoft.com/en-us/library/dn197850(v=sql.10).aspx
-------------
DOCUMENTATION
-------------
This release information, installation instructions, and license terms are included in this package.
All other documentation may be found online.
Please note that the offline help files have been discontinued.
---------
JAR FILES
---------
To support backward compatibility and possible upgrade scenarios, 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
mssql-jdbc-7.4.1.jre12.jar
----------------------
FEATURE SPECIFIC FILES
----------------------
Azure Active Directory and Integrated Authentication (on Windows) components are included
in the 'auth' directory.
JDBC distributed transaction components are included in the 'xa' directory.
--------------------
FEATURE DEPENDENCIES
--------------------
A few features in Microsoft JDBC Driver 7.4 for SQL Server are dependent on external libraries
as listed below:
1. Using 'Always Encrypted' with Azure Key Vault Provider
Dependent libraries: azure-keyvault(version 1.2.1), adal4j(version 1.6.4),
and client-runtime(version 1.6.10)
2. Using 'Azure Active Directory Integrated Authentication' on Windows, Linux and Mac Operating Systems
Dependent libraries: adal4j(version 1.6.4), and client-runtime(version 1.6.10)
3. Using 'useFmtOnly' to retrieve parameter metadata
Dependent libraries: antlr-runtime (version 4.7.2)
Detailed information on including these dependent libraries in a Standard Java Application
or a Maven Application can be found here: https://go.microsoft.com/fwlink/?linkid=867575
-------
SAMPLES
-------
Sample applications that demonstrate various features of the JDBC driver are included in the 'samples'
directory. For more details about each sample and how to run them, please refer to the online
documentation.
-----------
CHANGE LIST
-----------
Changes from 7.2.2.0 to 7.4.1.0
- Added support for NTLM authentication.
- Added new connection property 'useFmtOnly' to retrieve parameter metadata.
- Added support for JDK 12 with an additional "jre12" JAR.
- Added 'keyVaultProviderClientId' and 'keyVaultProviderClientKey' connection properties to enhance Always Encrypted usability.
- Added Maven Shade Plugin configuration to package the driver jars and all its dependencies in uber-jars.
- Added support in 'SQLServerBulkCopy' to allow 'PooledConnection'/'XAConnection' instances during object creation.
- Added support for FLOAT data type in 'SQLServerBulkCopy' when using 'RowSet'.
- Introduced a new Maven dependency of "ANTLR 4 Runtime" (Version: 4.7.2).
- Updated the Maven dependency of "Microsoft Azure Active Directory Authentication Library (ADAL4J) for Java"
to 1.6.4 version of the library.
- Updated the Maven dependency of "Java Client Runtime for AutoRest" to 1.6.10 version of the library.
- Updated the Maven dependency of "Microsoft Azure Key Vault SDK for Java" to 1.2.1 version of the library,
which also removes "Microsoft Azure SDK for Key Vault WebKey" from Maven dependencies.
- Updated the Maven dependency of "OSGi Core" to 6.0.0 version of the library.
- Updated the Maven dependency of "OSGi Compendium" to 5.0.0 version of the library.
Improvements:
- Improved 'SQLServerParameterMetadata' API implementations to prevent 'NullPointerException'.
- Improved performance by removing 'Enum.values()' calls to avoid unnecessary array cloning.
- Improved performance of driver by continuously cleaning up 'ActivityIds' stored in internal Map.
- Improved performance of 'SQLServerDataTable.internalAddRow()' method.
- Improved performance of several 'SQLServerBulkCopy' and 'PreparedStatement' methods by eliminating unnecessary object creation.
Bug Fixes:
- Fixed 'DatabaseMetadata.getColumns()' API to return 'ResultSet' as per JDBC 4.3 Specifications.
- Fixed issue wit
评论0