%3CLINGO-SUB%20id%3D%22lingo-sub-1425429%22%20slang%3D%22en-US%22%3EEarly%20technical%20preview%20of%20JDBC%20Driver%208.3.1%20for%20SQL%20Server%20released%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1425429%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%20contains%20numerous%20additions%20and%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.1%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noreferrer%20noopener%20noreferrer%20noopener%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%20noopener%20noreferrer%20noopener%20noreferrer%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-1169494604%22%20id%3D%22toc-hId-1169494604%22%3EAdded%3C%2FH3%3E%3CUL%3E%3CLI%3EAdded%20delayed%20durability%20option%20to%20SQLServerConnection.commit()%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1310%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%231310%3C%2FA%3E%3C%2FLI%3E%3CLI%3EIntroduced%20SQLServerBulkCSVFileRecord.setEscapeColumnDelimitersCSV()%20to%20escape%20delimiters%20and%20double%20quotes%20when%20using%20bulk%20copy%20to%20load%20from%20CSV%20files%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1312%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%231312%3C%2FA%3E%3C%2FLI%3E%3CLI%3EAdded%20certificate%20expiry%20validation%20when%20using%20Always%20Encrypted%20with%20secure%20enclaves%20feature%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1321%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%231321%3C%2FA%3E%3C%2FLI%3E%3CLI%3EAdded%20SQL%20State%20to%20Exception%20when%20connection%20is%20closed%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1326%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%231326%3C%2FA%3E%3C%2FLI%3E%3CLI%3EIntroduced%20extended%20bulk%20copy%20support%20against%20Azure%20Data%20Warehouse%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1331%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%231331%3C%2FA%3E%3C%2FLI%3E%3CLI%3EIntroduced%20'delayLoadingLobs'%20connection%20property%20to%20provide%20backward%20compatibility%20when%20streaming%20LOBs%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1336%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%231336%3C%2FA%3E%3C%2FLI%3E%3C%2FUL%3E%3CH3%20id%3D%22toc-hId--637959859%22%20id%3D%22toc-hId--637959859%22%3EFixed%20issues%3C%2FH3%3E%3CUL%3E%3CLI%3EFixed%20an%20issue%20with%20MSI%20authentication%20failing%20due%20to%20expiry%20date%20format%20mismatch%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1308%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%231308%3C%2FA%3E%3C%2FLI%3E%3CLI%3EFixed%20an%20issue%20with%20streams%20not%20getting%20closed%20when%20using%20Always%20Encrypted%20with%20secure%20enclaves%20feature%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1315%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%231315%3C%2FA%3E%3C%2FLI%3E%3CLI%3EFixed%20an%20issue%20with%20retrieving%20SQL%20VARIANT%20as%20its%20underlying%20type%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1320%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%231320%3C%2FA%3E%3C%2FLI%3E%3CLI%3EFixed%20issues%20with%20the%20driver%20not%20being%20JAVA%208%20compliant%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1328%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%231328%3C%2FA%3E%3C%2FLI%3E%3CLI%3EFixed%20an%20issue%20with%20PreparedStatement%20when%20inserting%20large%20spatial%20data%20types%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1337%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%231337%3C%2FA%3E%3C%2FLI%3E%3C%2FUL%3E%3CH3%20id%3D%22toc-hId-1849552974%22%20id%3D%22toc-hId-1849552974%22%3EChanged%3C%2FH3%3E%3CUL%3E%3CLI%3EUpdated%20driver%20and%20test%20dependencies%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1294%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%231294%3C%2FA%3E%2C%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1313%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%231313%3C%2FA%3E%3C%2FLI%3E%3CLI%3EImproved%20exception%20message%20when%20connecting%20to%20redirection-enabled%20Azure%20server%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1311%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%231311%3C%2FA%3E%3C%2FLI%3E%3CLI%3EImproved%20performance%20when%20parsing%20connection%20string%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1317%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%231317%3C%2FA%3E%3C%2FLI%3E%3CLI%3EUpdated%20the%20driver%20to%20throw%20a%20warning%20when%20TLS%20version%20lower%20than%201.2%20is%20negotiated%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1322%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%231322%3C%2FA%3E%3C%2FLI%3E%3CLI%3ERemoved%20unused%20code%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1330%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%231330%3C%2FA%3E%3C%2FLI%3E%3C%2FUL%3E%3CH3%20id%3D%22toc-hId-42098511%22%20id%3D%22toc-hId-42098511%22%3EGetting%20the%20latest%20release%3C%2FH3%3E%3CP%3EThe%20latest%20bits%20are%20available%20on%20our%26nbsp%3B-ERR%3AREF-NOT-FOUND-GitHub%20repository%2C%20and%20-ERR%3AREF-NOT-FOUND-Maven%20Central.%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%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%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.1.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%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EHelp%20us%20improve%20the%20JDBC%20Driver%20by%20taking%20our%20%3C%2FSPAN%3E-ERR%3AREF-NOT-FOUND-survey%3CSPAN%3E%2C%20%3C%2FSPAN%3E-ERR%3AREF-NOT-FOUND-filing%20issues%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-ERR%3AREF-NOT-FOUND-tutorials%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-1425429%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%20contains%20numerous%20additions%20and%20changes.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1425429%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESQLServerDrivers%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Senior Member

We have released a new early technical preview of the JDBC Driver for SQL Server which contains numerous additions and 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 delayed durability option to SQLServerConnection.commit() #1310
  • Introduced SQLServerBulkCSVFileRecord.setEscapeColumnDelimitersCSV() to escape delimiters and double quotes when using bulk copy to load from CSV files #1312
  • Added certificate expiry validation when using Always Encrypted with secure enclaves feature #1321
  • Added SQL State to Exception when connection is closed #1326
  • Introduced extended bulk copy support against Azure Data Warehouse #1331
  • Introduced 'delayLoadingLobs' connection property to provide backward compatibility when streaming LOBs #1336

Fixed issues

  • Fixed an issue with MSI authentication failing due to expiry date format mismatch #1308
  • Fixed an issue with streams not getting closed when using Always Encrypted with secure enclaves feature #1315
  • Fixed an issue with retrieving SQL VARIANT as its underlying type #1320
  • Fixed issues with the driver not being JAVA 8 compliant #1328
  • Fixed an issue with PreparedStatement when inserting large spatial data types #1337

Changed

  • Updated driver and test dependencies #1294, #1313
  • Improved exception message when connecting to redirection-enabled Azure server #1311
  • Improved performance when parsing connection string #1317
  • Updated the driver to throw a warning when TLS version lower than 1.2 is negotiated #1322
  • Removed unused code #1330

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.1.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