%3CLINGO-SUB%20id%3D%22lingo-sub-1145002%22%20slang%3D%22en-US%22%3EJDBC%20Driver%208.2%20for%20SQL%20Server%20Released%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1145002%22%20slang%3D%22en-US%22%3E%3CP%3EVersion%208.2%20of%20the%20Microsoft%20JDBC%20Driver%20for%20SQL%20Server%20has%20been%20released.%20Version%208.2.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-1085512907%22%20id%3D%22toc-hId-1085512881%22%3EAdded%3C%2FH3%3E%3CUL%3E%3CLI%3ESupport%20for%20Always%20Encrypted%20with%20secure%20enclaves%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Fpull%2F1155%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%231155%3C%2FA%3E%3C%2FLI%3E%3CLI%3ESupport%20for%20JAVA%2013%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Fpull%2F1151%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%231151%3C%2FA%3E%3C%2FLI%3E%3CLI%3ESupport%20for%20Azure%20national%20clouds%20when%20using%20Azure%20Key%20Vault%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1130%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%231130%3C%2FA%3E%3C%2FLI%3E%3CLI%3EAdded%20ISQLServerBulkData%20to%20remove%20implementation%20details%20from%20ISQLServerBulkRecord%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E-ERR%3AREF-NOT-FOUND-%231099%3C%2FLI%3E%3CLI%3EImplemented%20hashCode()%20and%20equals()%20APIs%20for%20SQLServerDataTable%20and%20SQLServerDataColumn%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Fpull%2F1146%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%231146%3C%2FA%3E%3C%2FLI%3E%3CLI%3E%3CSPAN%3EBackwards%20compatibility%20for%20calling%20SQLServerClob.length()%20on%20nvarchar%20columns%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1214%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%231214%3C%2FA%3E%3C%2FLI%3E%3C%2FUL%3E%3CH3%20id%3D%22toc-hId--721941556%22%20id%3D%22toc-hId--721941582%22%3EChanged%3C%2FH3%3E%3CUL%3E%3CLI%3EMade%20mssql-jdbc_auth%20library%20available%20via%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_auth%2522%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EMaven%20Central%3C%2FA%3E%3C%2FLI%3E%3CLI%3EImproved%20performance%20of%20column%20name%20lookups%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E-ERR%3AREF-NOT-FOUND-%231066%3C%2FLI%3E%3CLI%3EImproved%20performance%20of%20CallableStatement%20and%20ParameterMetaData%20when%20using%20procedure%20names%20that%20contain%20wildcard%20characters%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E-ERR%3AREF-NOT-FOUND-%231149%3C%2FLI%3E%3CLI%3EMade%20internal%20model%20public%20for%20SQLServerSpatialDatatype%20class%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E-ERR%3AREF-NOT-FOUND-%231169%3C%2FLI%3E%3CLI%3EUpdated%20ISQLServerBulkData%20APIs%20to%20throw%20SQLException%20instead%20of%20SQLServerException%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E-ERR%3AREF-NOT-FOUND-%231187%3C%2FLI%3E%3CLI%3EOptimized%20temporal%20datatype%20getter%20methods%20by%20replacing%20Calendar%20with%20LocalDatetime%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E-ERR%3AREF-NOT-FOUND-%231200%3C%2FLI%3E%3CLI%3EUpdated%20com.microsoft.rest%3Aclient-runtime%20to%20its%20latest%20version%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1235%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%231235%3C%2FA%3E%3C%2FLI%3E%3CLI%3ERemoved%20shaded%20jars%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1239%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%231239%3C%2FA%3E%3C%2FLI%3E%3C%2FUL%3E%3CH3%20id%3D%22toc-hId-1765571277%22%20id%3D%22toc-hId-1765571251%22%3EFixed%3C%2FH3%3E%3CUL%3E%3CLI%3EFixed%20Geography.STAsBinary()%20returning%20null%20for%20a%20single%20point%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1066%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%231074%3C%2FA%3E%3C%2FLI%3E%3CLI%3EFixed%20DatabaseMetaData.getImportedKeys()%20returning%20duplicate%20rows%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1149%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%231092%3C%2FA%3E%3C%2FLI%3E%3CLI%3EFixed%20issue%20with%20truststore%20password%20being%20removed%20too%20early%20for%20XA%20connections%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1169%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%231133%3C%2FA%3E%3C%2FLI%3E%3CLI%3EFixed%20issue%20with%20SQLServerDatabaseMetada.getColumns()%20not%20escaping%20wildcard%20characters%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1187%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%231138%3C%2FA%3E%3C%2FLI%3E%3CLI%3ERemoved%20extra%20spaces%20in%20SQLServerDatabaseMetaData.getNumericFunctions()%20and%20SQLServerDatabaseMetaData.getStringFunctions()%20return%20values%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1200%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%231117%3C%2FA%3E%3C%2FLI%3E%3CLI%3EFixed%20a%20potential%20NullPointerException%20in%20SQLServerDataColumn.equals()%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E-ERR%3AREF-NOT-FOUND-%231168%3C%2FLI%3E%3CLI%3EFixed%20an%20issue%20with%20BulkCopy%20when%20source%20is%20unicode%20char%2Fvarchar%20and%20destination%20is%20nchar%2Fnvarchar%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E-ERR%3AREF-NOT-FOUND-%231193%3C%2FLI%3E%3CLI%3EFixed%20an%20issue%20with%20SQLServerDatabaseMetaData.getColumns()%20only%20returning%20the%20first%20column%20against%20Azure%20SQL%20Data%20Warehouse%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E-ERR%3AREF-NOT-FOUND-%231197%3C%2FLI%3E%3CLI%3EFixed%20an%20issue%20with%20SQLServerDatabaseMetaData.getImportedKeys()%20failing%20against%20Azure%20SQL%20Data%20Warehouse%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E-ERR%3AREF-NOT-FOUND-%231205%3C%2FLI%3E%3CLI%3EFixed%20an%20issue%20with%20InputStream%20closing%20when%20calling%20SQLServerBlob.length()%20on%20an%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eimage%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Ecolumn%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1214%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%231214%3C%2FA%3E%3C%2FLI%3E%3CLI%3EFixed%20a%20potential%20performance%20issue%20created%20from%20trailing%20spaces%20in%20PreparedStatement%20queries%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1215%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%231215%3C%2FA%3E%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CH3%20id%3D%22toc-hId--41883186%22%20id%3D%22toc-hId--41883212%22%3EGetting%20the%20latest%20release%3C%2FH3%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%20noopener%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%2Fv8.2.0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%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%20noopener%20noreferrer%20noopener%20noreferrer%22%3EMaven%20Central%3C%2FA%3E.%3C%2FP%3E%3CP%3EAdd%20the%20JDBC%208.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.jre13%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%3E8.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-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-tutorialsto%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-1145002%22%20slang%3D%22en-US%22%3E%3CP%3EJDBC%20Driver%208.2%20for%20SQL%20Server%20has%20been%20released%2C%20adding%20official%20support%20for%20Always%20Encrypted%20with%20secure%20enclaves%2C%20Java%2013%20and%26nbsp%3Bmany%20other%20improvements.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1145002%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESQLServerDrivers%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Senior Member

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

 

Added

  • Support for Always Encrypted with secure enclaves #1155
  • Support for JAVA 13 #1151
  • Support for Azure national clouds when using Azure Key Vault #1130
  • Added ISQLServerBulkData to remove implementation details from ISQLServerBulkRecord #1099
  • Implemented hashCode() and equals() APIs for SQLServerDataTable and SQLServerDataColumn #1146
  • Backwards compatibility for calling SQLServerClob.length() on nvarchar columns #1214

Changed

  • Made mssql-jdbc_auth library available via Maven Central
  • Improved performance of column name lookups #1066
  • Improved performance of CallableStatement and ParameterMetaData when using procedure names that contain wildcard characters #1149
  • Made internal model public for SQLServerSpatialDatatype class #1169
  • Updated ISQLServerBulkData APIs to throw SQLException instead of SQLServerException #1187
  • Optimized temporal datatype getter methods by replacing Calendar with LocalDatetime #1200
  • Updated com.microsoft.rest:client-runtime to its latest version #1235
  • Removed shaded jars #1239

Fixed

  • Fixed Geography.STAsBinary() returning null for a single point #1074
  • Fixed DatabaseMetaData.getImportedKeys() returning duplicate rows #1092
  • Fixed issue with truststore password being removed too early for XA connections #1133
  • Fixed issue with SQLServerDatabaseMetada.getColumns() not escaping wildcard characters #1138
  • Removed extra spaces in SQLServerDatabaseMetaData.getNumericFunctions() and SQLServerDatabaseMetaData.getStringFunctions() return values #1117
  • Fixed a potential NullPointerException in SQLServerDataColumn.equals() #1168
  • Fixed an issue with BulkCopy when source is unicode char/varchar and destination is nchar/nvarchar #1193
  • Fixed an issue with SQLServerDatabaseMetaData.getColumns() only returning the first column against Azure SQL Data Warehouse #1197
  • Fixed an issue with SQLServerDatabaseMetaData.getImportedKeys() failing against Azure SQL Data Warehouse #1205
  • Fixed an issue with InputStream closing when calling SQLServerBlob.length() on an image column #1214
  • Fixed a potential performance issue created from trailing spaces in PreparedStatement queries #1215

 

Getting the latest release

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

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

 

 

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