Early technical preview of JDBC Driver 8.3.0 for SQL Server released

Published Apr 01 2020 02:01 PM 1,731 Views
Senior Member

We have released a new early technical preview of the JDBC Driver for SQL Server which adds support for Java 14 along with other changes.

 

Precompiled binaries are available on GitHub and also on Maven Central.

Below is a summary of the new additions, changes made, and issues fixed.

Added

  • Added connection properties to specify a custom SocketFactory #1217
  • Added support for Client Certificate Authentication #1284
  • Added support for JAVA 14 #1290
  • Added support for authentication to Azure Key Vault using Managed Identity #1286

Fixed issues

  • Fixed an issue with escaping curly brackets in the connection string #1251
  • Fixed a warning when retrieving Operating System information from SQL Server on Linux when using distributed transactions #1279

Changed

  • Updated Gradle dependencies #1244
  • Updated SQLServerPreparedStatement.setObject() to retrieve TVP name from SQLServerDataTable #1282

Getting the latest release

The latest bits are available on our GitHub repository, and Maven Central.

Add the JDBC preview driver to your Maven project by adding the following code to your POM file to include it as a dependency in your project (choose .jre8, .jre11, or .jre14 for your required Java version).

 

<dependency> 
  <groupId>com.microsoft.sqlserver</groupId> 
  <artifactId>mssql-jdbc</artifactId> 
  <version>8.3.0.jre11</version> 
</dependency> 

 

Help us improve the JDBC Driver by taking our survey, filing issues on GitHub or contributing to the project.


Please also check out our tutorials to get started with developing apps in your programming language of choice and SQL Server.


David Engel

%3CLINGO-SUB%20id%3D%22lingo-sub-1272814%22%20slang%3D%22en-US%22%3EEarly%20technical%20preview%20of%20JDBC%20Driver%208.3.0%20for%20SQL%20Server%20released%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1272814%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EWe%20have%20released%20a%20new%20early%20technical%20preview%20of%20the%20JDBC%20Driver%20for%20SQL%20Server%20which%20adds%20support%20for%20Java%2014%20along%20with%20other%20changes.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EPrecompiled%20binaries%20are%20available%20on%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Freleases%2Ftag%2Fv8.3.0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EGitHub%3C%2FA%3E%26nbsp%3Band%20also%20on%26nbsp%3B%3CA%20href%3D%22http%3A%2F%2Fsearch.maven.org%2F%23search%257Cgav%257C1%257Cg%253A%2522com.microsoft.sqlserver%2522%2520AND%2520a%253A%2522mssql-jdbc%2522%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EMaven%20Central%3C%2FA%3E.%3CBR%20%2F%3E%3CBR%20%2F%3EBelow%20is%20a%20summary%20of%20the%20new%20additions%2C%20changes%20made%2C%20and%20issues%20fixed.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CH3%20id%3D%22toc-hId-1116710656%22%20id%3D%22toc-hId-1116732879%22%3EAdded%3C%2FH3%3E%3CUL%3E%3CLI%3EAdded%20connection%20properties%20to%20specify%20a%20custom%20SocketFactory%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Fpull%2F1217%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%231217%3C%2FA%3E%3C%2FLI%3E%3CLI%3EAdded%20support%20for%20Client%20Certificate%20Authentication%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1284%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%231284%3C%2FA%3E%3C%2FLI%3E%3CLI%3EAdded%20support%20for%20JAVA%2014%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1290%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%231290%3C%2FA%3E%3C%2FLI%3E%3CLI%3EAdded%20support%20for%20authentication%20to%20Azure%20Key%20Vault%20using%20Managed%20Identity%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1286%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%231286%3C%2FA%3E%3C%2FLI%3E%3C%2FUL%3E%3CH3%20id%3D%22toc-hId--690743807%22%20id%3D%22toc-hId--690721584%22%3EFixed%20issues%3C%2FH3%3E%3CUL%3E%3CLI%3EFixed%20an%20issue%20with%20escaping%20curly%20brackets%20in%20the%20connection%20string%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1251%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%231251%3C%2FA%3E%3C%2FLI%3E%3CLI%3EFixed%20a%20warning%20when%20retrieving%20Operating%20System%20information%20from%20SQL%20Server%20on%20Linux%20when%20using%20distributed%20transactions%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1279%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%231279%3C%2FA%3E%3C%2FLI%3E%3C%2FUL%3E%3CH3%20id%3D%22toc-hId-1796769026%22%20id%3D%22toc-hId-1796791249%22%3EChanged%3C%2FH3%3E%3CUL%3E%3CLI%3EUpdated%20Gradle%20dependencies%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1244%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%231244%3C%2FA%3E%3C%2FLI%3E%3CLI%3EUpdated%20SQLServerPreparedStatement.setObject()%20to%20retrieve%20TVP%20name%20from%20SQLServerDataTable%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1282%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%231282%3C%2FA%3E%3C%2FLI%3E%3C%2FUL%3E%3CH3%20id%3D%22toc-hId--10685437%22%20id%3D%22toc-hId--10663214%22%3EGetting%20the%20latest%20release%3C%2FH3%3E%3CP%3EThe%20latest%20bits%20are%20available%20on%20our%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Freleases%2Ftag%2Fv8.3.0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EGitHub%20repository%3C%2FA%3E%2C%20and%20%3CA%20href%3D%22http%3A%2F%2Fsearch.maven.org%2F%23search%257Cgav%257C1%257Cg%253A%2522com.microsoft.sqlserver%2522%2520AND%2520a%253A%2522mssql-jdbc%2522%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EMaven%20Central%3C%2FA%3E.%3C%2FP%3E%3CP%3EAdd%20the%20JDBC%20preview%20driver%20to%20your%20Maven%20project%20by%20adding%20the%20following%20code%20to%20your%20POM%20file%20to%20include%20it%20as%20a%20dependency%20in%20your%20project%20(choose%20.jre8%2C%20.jre11%2C%20or%20.jre14%20for%20your%20required%20Java%20version).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3CDEPENDENCY%3E%20%0A%20%20%3CGROUPID%3Ecom.microsoft.sqlserver%3C%2FGROUPID%3E%20%0A%20%20%3CARTIFACTID%3Emssql-jdbc%3C%2FARTIFACTID%3E%20%0A%20%20%3CVERSION%3E8.3.0.jre11%3C%2FVERSION%3E%20%0A%3C%2FDEPENDENCY%3E%20%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EHelp%20us%20improve%20the%20JDBC%20Driver%20by%20taking%20our%20%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Faka.ms%2Fmssqljdbcsurvey%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Esurvey%3C%2FA%3E%3CSPAN%3E%2C%20%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Fissues%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Efiling%20issues%3C%2FA%3E%3CSPAN%3Eon%20GitHub%20or%20contributing%20to%20the%20project.%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%3E%3CDIV%3E%3CDIV%3E%3CBR%20%2F%3EPlease%20also%20check%20out%20our%20%3CA%20href%3D%22http%3A%2F%2Faka.ms%2Fsqldev%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Etutorials%3C%2FA%3E%20to%20get%20started%20with%20developing%20apps%20in%20your%20programming%20language%20of%20choice%20and%20SQL%20Server.%3CP%3E%3CBR%20%2F%3EDavid%20Engel%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1272814%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EWe%20have%20released%20a%20new%20early%20technical%20preview%20of%20the%20JDBC%20Driver%20for%20SQL%20Server%20which%20adds%20support%20for%20Java%2014%20along%20with%20other%20changes.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1272814%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESQLServerDrivers%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Version history
Last update:
‎Apr 01 2020 02:01 PM
Updated by: