JDBC Driver 9.2 for SQL Server Released

Published Jan 29 2021 03:47 PM 2,002 Views
Senior Member

Version 9.2 of the Microsoft JDBC Driver for SQL Server has been released. Version 9.2.0 brings many added features, changes, and fixed issues over the previous production release.

 

Added

  • Added a connection property for maxResultBuffer 1431
  • Added support for Azure Active Directory Service Principal authentication 1456
  • Added support for Azure Active Directory Interactive (MFA) authentication 1464
  • Added support for already connected sockets when using a custom socket factory #1420
  • Added JAVA 15 support #1434
  • Added LocalDateTime and OffsetDateTime support in CallableStatement #1393
  • Added new endpoints to the list of trusted Azure Key Vault endpoints #1445

Changed

  • Enabled useBulkCopyForBatchInsert against any server, not just Azure Synapse Analytics #1465
  • Changed the visibility of SQLServerBulkBatchInsertRecord to package-private #1408 (Potential breaking change)
  • Upgraded to the latest Azure Key Vault libraries #1413
  • Updated the API version when using MSI authentication #1418
  • Updated the driver to remove clientKeyPassword from memory #1428
  • Updated SQLServerPreparedStatement.getMetaData() to retain exception details #1430
  • Made ADALGetAccessTokenForWindowsIntegrated thread-safe #1441

Fixed

  • Fixed an issue with high memory allocation during bulk copy #1475
  • Fixed an issue with column ordinal mapping not being sorted when using bulk copy #1406
  • Fixed an issue with bulk copy when inserting non-unicode multibyte strings #1421
  • Fixed an issue with SQLServerBulkCSVFileRecord ignoring empty trailing columns when using the setEscapeColumnDelimitersCSV() API #1438

 

Getting the latest release

The latest bits are available to download from Microsoft, from the GitHub repository, and via Maven Central.

Add the JDBC 9.2 RTW 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 .jre15 for your required Java version).

 

 

<dependency> 
  <groupId>com.microsoft.sqlserver</groupId> 
  <artifactId>mssql-jdbc</artifactId> 
  <version>9.2.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-2108693%22%20slang%3D%22en-US%22%3EJDBC%20Driver%209.2%20for%20SQL%20Server%20Released%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2108693%22%20slang%3D%22en-US%22%3E%3CP%3EVersion%209.2%20of%20the%20Microsoft%20JDBC%20Driver%20for%20SQL%20Server%20has%20been%20released.%20Version%209.2.0%20brings%20many%20added%20features%2C%20changes%2C%20and%20fixed%20issues%20over%20the%20previous%20production%20release.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EAdded%3C%2FSTRONG%3E%3C%2FP%3E%3CUL%3E%3CLI%3EAdded%20a%20connection%20property%20for%20maxResultBuffer%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1431%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E1431%3C%2FA%3E%3C%2FLI%3E%3CLI%3EAdded%20support%20for%20Azure%20Active%20Directory%20Service%20Principal%20authentication%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1456%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E1456%3C%2FA%3E%3C%2FLI%3E%3CLI%3EAdded%20support%20for%20Azure%20Active%20Directory%20Interactive%20(MFA)%20authentication%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1464%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E1464%3C%2FA%3E%3C%2FLI%3E%3CLI%3EAdded%20support%20for%20already%20connected%20sockets%20when%20using%20a%20custom%20socket%20factory%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1420%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%231420%3C%2FA%3E%3C%2FLI%3E%3CLI%3EAdded%20JAVA%2015%20support%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1434%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%231434%3C%2FA%3E%3C%2FLI%3E%3CLI%3EAdded%20LocalDateTime%20and%20OffsetDateTime%20support%20in%20CallableStatement%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1393%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%231393%3C%2FA%3E%3C%2FLI%3E%3CLI%3EAdded%20new%20endpoints%20to%20the%20list%20of%20trusted%20Azure%20Key%20Vault%20endpoints%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1445%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%231445%3C%2FA%3E%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%3CSTRONG%3EChanged%3C%2FSTRONG%3E%3C%2FP%3E%3CUL%3E%3CLI%3EEnabled%20useBulkCopyForBatchInsert%20against%20any%20server%2C%20not%20just%20Azure%20Synapse%20Analytics%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1465%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%231465%3C%2FA%3E%3C%2FLI%3E%3CLI%3EChanged%20the%20visibility%20of%20SQLServerBulkBatchInsertRecord%20to%20package-private%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1408%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%231408%3C%2FA%3E%26nbsp%3B(Potential%20breaking%20change)%3C%2FLI%3E%3CLI%3EUpgraded%20to%20the%20latest%20Azure%20Key%20Vault%20libraries%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1413%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%231413%3C%2FA%3E%3C%2FLI%3E%3CLI%3EUpdated%20the%20API%20version%20when%20using%20MSI%20authentication%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1418%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%231418%3C%2FA%3E%3C%2FLI%3E%3CLI%3EUpdated%20the%20driver%20to%20remove%20clientKeyPassword%20from%20memory%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1428%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%231428%3C%2FA%3E%3C%2FLI%3E%3CLI%3EUpdated%20SQLServerPreparedStatement.getMetaData()%20to%20retain%20exception%20details%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1430%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%231430%3C%2FA%3E%3C%2FLI%3E%3CLI%3EMade%20ADALGetAccessTokenForWindowsIntegrated%20thread-safe%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1441%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%231441%3C%2FA%3E%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%3CSTRONG%3EFixed%3C%2FSTRONG%3E%3C%2FP%3E%3CUL%3E%3CLI%3EFixed%20an%20issue%20with%20high%20memory%20allocation%20during%20bulk%20copy%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1475%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%231475%3C%2FA%3E%3C%2FLI%3E%3CLI%3EFixed%20an%20issue%20with%20column%20ordinal%20mapping%20not%20being%20sorted%20when%20using%20bulk%20copy%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1406%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%231406%3C%2FA%3E%3C%2FLI%3E%3CLI%3EFixed%20an%20issue%20with%20bulk%20copy%20when%20inserting%20non-unicode%20multibyte%20strings%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1421%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%231421%3C%2FA%3E%3C%2FLI%3E%3CLI%3EFixed%20an%20issue%20with%20SQLServerBulkCSVFileRecord%20ignoring%20empty%20trailing%20columns%20when%20using%20the%20setEscapeColumnDelimitersCSV()%20API%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1438%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%231438%3C%2FA%3E%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EGetting%20the%20latest%20release%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EThe%20latest%20bits%20are%20available%20to%20%3CA%20title%3D%22download%20Microsoft%20JDBC%20Driver%20for%20SQL%20Server%22%20href%3D%22https%3A%2F%2Faka.ms%2Fdownloadmssqljdbc%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Edownload%20from%20Microsoft%3C%2FA%3E%2C%20from%20the%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Freleases%2Ftag%2Fv9.2.0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EGitHub%20repository%3C%2FA%3E%2C%20and%20via%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%22noopener%20nofollow%20noreferrer%22%3EMaven%20Central%3C%2FA%3E.%3C%2FP%3E%3CP%3EAdd%20the%20JDBC%209.2%20RTW%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.jre15%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%3E9.2.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%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%3E%20on%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-2108693%22%20slang%3D%22en-US%22%3E%3CP%3EJDBC%20Driver%209.2%20for%20SQL%20Server%20has%20been%20released%2C%20adding%20official%20support%20Java%2015%20and%26nbsp%3Bmany%20other%20improvements.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2108693%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESQLServerDrivers%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Co-Authors
Version history
Last update:
‎Jan 29 2021 03:47 PM
Updated by: