Home
%3CLINGO-SUB%20id%3D%22lingo-sub-782588%22%20slang%3D%22en-US%22%3EJDBC%20Driver%207.4%20for%20SQL%20Server%20Released%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-782588%22%20slang%3D%22en-US%22%3E%3CP%3EVersion%207.4%20of%20the%20Microsoft%20JDBC%20Driver%20for%20SQL%20Server%20has%20been%20released.%20Version%207.4.0%20brings%20several%20added%20features%2C%20changes%2C%20and%20fixed%20issues%20over%20the%20previous%20production%20release.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CH3%20id%3D%22toc-hId-1598727645%22%20id%3D%22toc-hId-1598727645%22%3EAdded%3C%2FH3%3E%3CUL%3E%3CLI%3ESupport%20in%20SQLServerBulkCopy%20to%20allow%20Pooled%2FXA%20Connection%20instances%20during%20object%20creation%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Fpull%2F968%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%23968%3C%2FA%3E%3C%2FLI%3E%3CLI%3ESupport%20for%20FLOAT%20data%20type%20for%20bulk%20copy%20operation%20when%20using%20RowSet%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Fpull%2F986%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%23986%3C%2FA%3E%3C%2FLI%3E%3CLI%3ESupport%20for%20NTLM%20Authentication%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Fpull%2F998%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%23998%3C%2FA%3E%3C%2FLI%3E%3CLI%3ENew%20connection%20property%20'useFmtOnly'%20to%20retrieve%20parameter%20metadata%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Fpull%2F1044%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%231044%3C%2FA%3E%3C%2FLI%3E%3CLI%3ESupport%20for%20JDK%2012%20with%20an%20additional%20%22jre12%22%20JAR%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Fpull%2F1050%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%231050%3C%2FA%3E%3C%2FLI%3E%3CLI%3E'keyVaultProviderClientId'%20and%20'keyVaultProviderClientKey'%20connection%20properties%20to%20enhance%20Always%20Encrypted%20usability%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Fpull%2F902%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%23902%3C%2FA%3E%3C%2FLI%3E%3CLI%3EImplemented%20hashCode()%20and%20equals()%20APIs%20for%20SQLServerDataTable%20and%20SQLServerDataColumn%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Fpull%2F1025%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%231025%3C%2FA%3E%3C%2FLI%3E%3CLI%3EMaven%20Shade%20plugin%20configuration%20to%20package%20the%20driver%20jars%20in%20uber-jars%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Fpull%2F1043%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%231043%3C%2FA%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Fpull%2F1078%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%231078%3C%2FA%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Fpull%2F1081%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%231081%3C%2FA%3E%3C%2FLI%3E%3C%2FUL%3E%3CH3%20id%3D%22toc-hId--953429316%22%20id%3D%22toc-hId--953429316%22%3EChanged%3C%2FH3%3E%3CUL%3E%3CLI%3ERefactored%20SELECT_METHOD%20in%20SQLServerConnection%20to%20not%20fetch%20the%20same%20connection%20property%20twice%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Fpull%2F987%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%23987%3C%2FA%3E%3C%2FLI%3E%3CLI%3EImproved%20SQLServerParameterMetadata%20API%20implementations%20and%20code%20coverage%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Fpull%2F973%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%23973%3C%2FA%3E%3C%2FLI%3E%3CLI%3EImproved%20performance%20of%20driver%20by%20continuously%20cleaning%20up%20ActivityIds%20stored%20in%20internal%20Map%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Fpull%2F1020%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%231020%3C%2FA%3E%3C%2FLI%3E%3CLI%3EImproved%20performance%20by%20removing%20Enum.values()%20calls%20to%20avoid%20unnecessary%20array%20cloning%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Fpull%2F1065%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%231065%3C%2FA%3E%3C%2FLI%3E%3CLI%3EImproved%20performance%20of%20SQLServerDataTable.internalAddRow()%20function%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Fpull%2F990%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%23990%3C%2FA%3E%3C%2FLI%3E%3CLI%3EPerformance%20improvements%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Fpull%2F1075%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%231075%3C%2FA%3E%3C%2FLI%3E%3CLI%3EUpdated%20the%20Maven%20dependency%20of%20'Java%20Client%20Runtime%20for%20AutoRest'%20to%201.6.10%20version%20of%20the%20library%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Fpull%2F1097%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%231097%3C%2FA%3E%3C%2FLI%3E%3C%2FUL%3E%3CH3%20id%3D%22toc-hId-789381019%22%20id%3D%22toc-hId-789381019%22%3EFixed%3C%2FH3%3E%3CUL%3E%3CLI%3EFixed%20a%20possible%20Statement%20leak%20in%20SQLServerConnection.isValid()%20API%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Fpull%2F955%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%23955%3C%2FA%3E%3C%2FLI%3E%3CLI%3EFixed%20rounding%20behavior%20when%20inserting%20datetime%20values%20into%20SQL%20Server%20version%202016%20and%20later%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Fpull%2F962%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%23962%3C%2FA%3E%3C%2FLI%3E%3CLI%3EFixed%20SQLServerConnection.abort()%20API%20behavior%20to%20clear%20resources%20consistently%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Fpull%2F983%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%23983%3C%2FA%3E%3C%2FLI%3E%3CLI%3EFixed%20SQLServerConnection%20documentation%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Fpull%2F984%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%23984%3C%2FA%3E%3C%2FLI%3E%3CLI%3EFixed%20SQL%20Exception%20Error%20State%20length%20to%20respect%20SQLSTATE%20Standards%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Fpull%2F977%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%23977%3C%2FA%3E%3C%2FLI%3E%3CLI%3EFixed%20DatabaseMetadata.getColumns()%20API%20to%20return%20ResultSet%20as%20per%20JDBC%204.3%20Specifications%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Fpull%2F1016%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%231016%3C%2FA%3E%3C%2FLI%3E%3CLI%3EFixed%20issue%20with%20invalid%20Spatial%20data%20types%20by%20marking%20them%20valid%20by%20default%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1035%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%231035%3C%2FA%3E%3C%2FLI%3E%3CLI%3EFixed%20issues%20with%20Login%20Timeout%20not%20getting%20applied%20appropriately%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Fpull%2F1049%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%231049%3C%2FA%3E%3C%2FLI%3E%3CLI%3EFixed%20SharedTimer%20implementation%20to%20use%20class%20level%20lock%20for%20thread%20safety%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Fpull%2F1046%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%231046%3C%2FA%3E%3C%2FLI%3E%3CLI%3EFixed%20issues%20with%20SQLServerDatabaseMetadata.getMaxConnections()%20API%20query%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Fpull%2F1009%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%231009%3C%2FA%3E%3C%2FLI%3E%3CLI%3EFixed%20issues%20with%20next%20ResultSet%20being%20consumed%20when%20reading%20warnings%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Fpull%2F991%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%23991%3C%2FA%3E%3C%2FLI%3E%3CLI%3EFixed%20exception%20handling%20in%20SQLServerPreparedStatement%20to%20make%20it%20consistent%20with%20SQLServerStatement%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Fpull%2F1003%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%231003%3C%2FA%3E%3C%2FLI%3E%3CLI%3EFixed%20misleading%20exception%20message%20in%20SQLServerCallableStatement%20implementation%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Fpull%2F1064%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%231064%3C%2FA%3E%3C%2FLI%3E%3C%2FUL%3E%3CH3%20id%3D%22toc-hId--1762775942%22%20id%3D%22toc-hId--1762775942%22%3EGetting%20the%20latest%20release%3C%2FH3%3E%3CP%3EThe%20latest%20bits%20are%20available%20on%20the%20%3CA%20href%3D%22https%3A%2F%2Fwww.microsoft.com%2Fdownload%2Fdetails.aspx%3Fid%3D58505%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3EMicrosoft%20Download%20Center%3C%2FA%3E%2C%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Freleases%2Ftag%2Fv7.4.0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%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%20noopener%20noreferrer%20noopener%20noreferrer%22%3EMaven%20Central%3C%2FA%3E.%3C%2FP%3E%3CP%3EAdd%20the%20JDBC%207.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.jre12%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-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%3E7.4.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%20noopener%20noreferrer%20noopener%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%20noopener%20noreferrer%20noopener%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%20noopener%20noreferrer%20noopener%20noreferrer%22%3Etutorials%3C%2FA%3Eto%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-782588%22%20slang%3D%22en-US%22%3E%3CP%3EJDBC%20Driver%207.4%20for%20SQL%20Server%20has%20been%20released%2C%20adding%20support%20for%20Java%2012%20and%26nbsp%3Bmany%20other%20improvements.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-782588%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESQLServerDrivers%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Senior Member

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

 

Added

  • Support in SQLServerBulkCopy to allow Pooled/XA Connection instances during object creation #968
  • Support for FLOAT data type for bulk copy operation when using RowSet #986
  • Support for NTLM Authentication #998
  • New connection property 'useFmtOnly' to retrieve parameter metadata #1044
  • Support for JDK 12 with an additional "jre12" JAR #1050
  • 'keyVaultProviderClientId' and 'keyVaultProviderClientKey' connection properties to enhance Always Encrypted usability #902
  • Implemented hashCode() and equals() APIs for SQLServerDataTable and SQLServerDataColumn #1025
  • Maven Shade plugin configuration to package the driver jars in uber-jars #1043 #1078 #1081

Changed

  • Refactored SELECT_METHOD in SQLServerConnection to not fetch the same connection property twice #987
  • Improved SQLServerParameterMetadata API implementations and code coverage #973
  • Improved performance of driver by continuously cleaning up ActivityIds stored in internal Map #1020
  • Improved performance by removing Enum.values() calls to avoid unnecessary array cloning #1065
  • Improved performance of SQLServerDataTable.internalAddRow() function #990
  • Performance improvements #1075
  • Updated the Maven dependency of 'Java Client Runtime for AutoRest' to 1.6.10 version of the library #1097

Fixed

  • Fixed a possible Statement leak in SQLServerConnection.isValid() API #955
  • Fixed rounding behavior when inserting datetime values into SQL Server version 2016 and later #962
  • Fixed SQLServerConnection.abort() API behavior to clear resources consistently #983
  • Fixed SQLServerConnection documentation #984
  • Fixed SQL Exception Error State length to respect SQLSTATE Standards #977
  • Fixed DatabaseMetadata.getColumns() API to return ResultSet as per JDBC 4.3 Specifications #1016
  • Fixed issue with invalid Spatial data types by marking them valid by default #1035
  • Fixed issues with Login Timeout not getting applied appropriately #1049
  • Fixed SharedTimer implementation to use class level lock for thread safety #1046
  • Fixed issues with SQLServerDatabaseMetadata.getMaxConnections() API query #1009
  • Fixed issues with next ResultSet being consumed when reading warnings #991
  • Fixed exception handling in SQLServerPreparedStatement to make it consistent with SQLServerStatement #1003
  • Fixed misleading exception message in SQLServerCallableStatement implementation #1064

Getting the latest release

The latest bits are available on the Microsoft Download Center, GitHub repository, and Maven Central.

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

 

 

<dependency> 
  <groupId>com.microsoft.sqlserver</groupId> 
  <artifactId>mssql-jdbc</artifactId> 
  <version>7.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