According to Technet Blog of Microsoft, developers of JDBC driver for SQL Server recently released version 6.2. The JDBC Driver provides Java database connectivity from any Java application, application server or Java-enabled applet to Microsoft SQL Server, Azure SQL Database and Azure SQL Data Warehouse. The driver is open source and available at no additional charge.
— Microsoft SQL Server (@SQLServer) July 5, 2017
Let's figure out what developers had made for users.
Performance improvements for Prepared Statements
Can be tuned using new properties to become more suitable for your application.
Azure Active Directory (AAD) support for Linux
You can connect your Linux applications to Azure SQL Database using AAD authentication via username/password and access token methods.
Federal Information Processing Standard (FIPS) enabled Java virtual machines
The JDBC Driver can now be used on Java virtual machines (JVMs) that run in FIPS 140 compliance mode to meet federal standards and compliance.
Kerberos Authentication Improvements
Now this driver has support for:
- Principal/Password method for applications where the Kerberos configuration cannot be modified or is unable to retrieve a new token or keytab. This method can be used for authenticating to a SQL Server that only allows Kerberos authentication.
- Cross-realm authentication using Kerberos integrated authentication without explicitly setting the server service principal name (SPN). The driver now automatically computes the REALM even when it has not been provided.
- Kerberos constrained delegation by accepting impersonated user credentials as a GSS credential object via data source. This impersonated credential is then used to establish a Kerberos connection.
The JDBC driver now supports the following configurable timeouts you can change based on your application’s needs:
- Query Timeout to control the number of seconds to wait before a timeout occurs when running a query
- Socket Timeout to specify the number of milliseconds to wait before a timeout occurs on a socket read or accept
You can download the JDBC driver 6.2 jars directly from:
- Maven Central Repository
- Microsoft Download Center
Or you can add the new driver to your Maven project by adding the following code to your POM file:
<dependency> <groupId>com.microsoft.sqlserver</groupId> <artifactId>mssql-jdbc</artifactId> <version>6.2.0.jre8</version> </dependency>
Developers also ask to help them improve their product and submit any spotted issues.