JDBC Driver 9.4 for SQL Server Released

Published Aug 05 2021 11:41 AM 1,696 Views
Senior Member

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

 

Added

  • Added Java 16 support #1579
  • Added optional realm connection string property for Kerberos authentication #1581
  • Added support for replication connections via a replication connection string option #1566
  • Added Open Connection Retry feature #1535
  • Added server recognition for Azure Synapse serverless SQL pool, and Azure SQL Edge #1543
  • Added support for multiple, successive connections using different settings for the Azure Key Vault key store provider #1594
  • Added sending the driver version to the database during prelogin #1583

Changed

  • Updated error messages for Always Encrypted with secure enclave exceptions to link to a troubleshooting guide #1585
  • Appended the MSAL exception error message to the error string returned during Azure AD authentication failures #1576
  • Send the client process ID to the server when running on Java 9+ #1595
  • Updated dependency versions #1613
  • Removed unused Java 9-specific class references from the Java 8 jar #1626

Fixed

  • Fixed an issue where batch fails when always encrypted is enabled in the connection string and clearParameters is called #1578
  • Fixed a small memory leak on new connections #1633
  • Fixed an issue where trustStorePassword is null when using applicationIntent=ReadOnly #1565
  • Fixed an issue where redirected token contains named instance in servername #1568
  • Fixed potential integer overflow in TDSWriter.writeString() #1531

 

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.4 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 .jre16 for your required Java version).

 

 

<dependency> 
  <groupId>com.microsoft.sqlserver</groupId> 
  <artifactId>mssql-jdbc</artifactId> 
  <version>9.4.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-2616513%22%20slang%3D%22en-US%22%3EJDBC%20Driver%209.4%20for%20SQL%20Server%20Released%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2616513%22%20slang%3D%22en-US%22%3E%3CP%3EVersion%209.4%20of%20the%20Microsoft%20JDBC%20Driver%20for%20SQL%20Server%20has%20been%20released.%20Version%209.4.0%20brings%20several%20added%20features%2C%20changes%2C%20and%20fixed%20issues%20over%20the%20previous%20production%20release.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EAdded%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3EAdded%20Java%2016%20support%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1579%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%20data-hovercard-type%3D%22pull_request%22%20data-hovercard-url%3D%22%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1579%2Fhovercard%22%3E%231579%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3EAdded%20optional%20realm%20connection%20string%20property%20for%20Kerberos%20authentication%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1581%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%20data-hovercard-type%3D%22pull_request%22%20data-hovercard-url%3D%22%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1581%2Fhovercard%22%3E%231581%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3EAdded%20support%20for%20replication%20connections%20via%20a%20replication%20connection%20string%20option%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1566%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3E%231566%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3EAdded%20Open%20Connection%20Retry%20feature%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1535%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%20data-hovercard-type%3D%22pull_request%22%20data-hovercard-url%3D%22%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1535%2Fhovercard%22%3E%231535%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3EAdded%20server%20recognition%20for%20Azure%20Synapse%20serverless%20SQL%20pool%2C%20and%20Azure%20SQL%20Edge%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1543%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%20data-hovercard-type%3D%22pull_request%22%20data-hovercard-url%3D%22%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1543%2Fhovercard%22%3E%231543%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3EAdded%20support%20for%20multiple%2C%20successive%20connections%20using%20different%20settings%20for%20the%20Azure%20Key%20Vault%20key%20store%20provider%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1594%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%20data-hovercard-type%3D%22pull_request%22%20data-hovercard-url%3D%22%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1594%2Fhovercard%22%3E%231594%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3EAdded%20sending%20the%20driver%20version%20to%20the%20database%20during%20prelogin%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1583%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%20data-hovercard-type%3D%22pull_request%22%20data-hovercard-url%3D%22%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1583%2Fhovercard%22%3E%231583%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%3CSTRONG%3EChanged%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3EUpdated%20error%20messages%20for%20Always%20Encrypted%20with%20secure%20enclave%20exceptions%20to%20link%20to%20a%20troubleshooting%20guide%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1585%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%20data-hovercard-type%3D%22pull_request%22%20data-hovercard-url%3D%22%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1585%2Fhovercard%22%3E%231585%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3EAppended%20the%20MSAL%20exception%20error%20message%20to%20the%20error%20string%20returned%20during%20Azure%20AD%20authentication%20failures%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1576%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%20data-hovercard-type%3D%22pull_request%22%20data-hovercard-url%3D%22%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1576%2Fhovercard%22%3E%231576%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3ESend%20the%20client%20process%20ID%20to%20the%20server%20when%20running%20on%20Java%209%2B%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1595%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%20data-hovercard-type%3D%22pull_request%22%20data-hovercard-url%3D%22%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1595%2Fhovercard%22%3E%231595%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3EUpdated%20dependency%20versions%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Fpull%2F1613%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%20data-hovercard-type%3D%22pull_request%22%20data-hovercard-url%3D%22%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1613%2Fhovercard%22%3E%231613%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3ERemoved%20unused%20Java%209-specific%20class%20references%20from%20the%20Java%208%20jar%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1626%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%20data-hovercard-type%3D%22pull_request%22%20data-hovercard-url%3D%22%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1626%2Fhovercard%22%3E%231626%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%3CSTRONG%3EFixed%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3EFixed%20an%20issue%20where%20batch%20fails%20when%20always%20encrypted%20is%20enabled%20in%20the%20connection%20string%20and%20clearParameters%20is%20called%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1578%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%20data-hovercard-type%3D%22pull_request%22%20data-hovercard-url%3D%22%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1578%2Fhovercard%22%3E%231578%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3EFixed%20a%20small%20memory%20leak%20on%20new%20connections%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1633%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%20data-hovercard-type%3D%22pull_request%22%20data-hovercard-url%3D%22%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1633%2Fhovercard%22%3E%231633%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3EFixed%20an%20issue%20where%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CCODE%3EtrustStorePassword%3C%2FCODE%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eis%20null%20when%20using%20applicationIntent%3DReadOnly%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1565%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%20data-hovercard-type%3D%22pull_request%22%20data-hovercard-url%3D%22%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1565%2Fhovercard%22%3E%231565%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3EFixed%20an%20issue%20where%20redirected%20token%20contains%20named%20instance%20in%20servername%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1568%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%20data-hovercard-type%3D%22pull_request%22%20data-hovercard-url%3D%22%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1568%2Fhovercard%22%3E%231568%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3EFixed%20potential%20integer%20overflow%20in%20TDSWriter.writeString()%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1531%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%20data-hovercard-type%3D%22pull_request%22%20data-hovercard-url%3D%22%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1531%2Fhovercard%22%3E%231531%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EGetting%20the%20latest%20release%3C%2FSTRONG%3E%3C%2FP%3E%0A%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.4.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%0A%3CP%3EAdd%20the%20JDBC%209.4%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.jre16%20for%20your%20required%20Java%20version).%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%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.4.0.jre11%3C%2FVERSION%3E%20%0A%3C%2FDEPENDENCY%3E%20%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%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%0A%3CDIV%3E%0A%3CDIV%3E%0A%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%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%0A%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-2616513%22%20slang%3D%22en-US%22%3E%3CP%3EJDBC%20Driver%209.4%20for%20SQL%20Server%20has%20been%20released%2C%20adding%20official%20support%20for%20Java%2016%20and%26nbsp%3Bseveral%20other%20improvements.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2616513%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESQLServerDrivers%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Co-Authors
Version history
Last update:
‎Aug 05 2021 10:59 AM
Updated by: