Home
%3CLINGO-SUB%20id%3D%22lingo-sub-1059160%22%20slang%3D%22en-US%22%3EEarly%20technical%20preview%20of%20JDBC%20Driver%208.1.1%20for%20SQL%20Server%20released%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1059160%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%20improves%20support%20for%20Always%20Encrypted%20with%20enclaves%20along%20with%20other%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.1.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.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CH3%20id%3D%22toc-hId-1057807273%22%20id%3D%22toc-hId-1057807313%22%3EAdded%3C%2FH3%3E%3CUL%3E%3CLI%3EAdded%20more%20tests%20to%20improve%20code%20coverage%20for%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%2F1186%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%231186%3C%2FA%3E%3C%2FLI%3E%3CLI%3EAdded%20certificate%20and%20enclave%20session%20caching%20for%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%2F1189%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%231189%3C%2FA%3E%3C%2FLI%3E%3C%2FUL%3E%3CH3%20id%3D%22toc-hId--749647190%22%20id%3D%22toc-hId--749647150%22%3EFixed%20issues%3C%2FH3%3E%3CUL%3E%3CLI%3EFixed%20a%20potential%20NullPointerException%20in%20SQLServerDataColumn.equals()%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1168%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%231168%3C%2FA%3E%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%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1193%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%231193%3C%2FA%3E%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%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1197%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%231197%3C%2FA%3E%3C%2FLI%3E%3CLI%3EFixed%20an%20issue%20with%20SQLServerDatabaseMetaData.getImportedKeys()%20failing%20against%20Azure%20SQL%20Data%20Warehouse%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1205%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%231205%3C%2FA%3E%3C%2FLI%3E%3C%2FUL%3E%3CH3%20id%3D%22toc-hId-1737865643%22%20id%3D%22toc-hId-1737865683%22%3EChanged%3C%2FH3%3E%3CUL%3E%3CLI%3EMade%20internal%20model%20public%20for%20SQLServerSpatialDatatype%20class%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%20noreferrer%20noopener%20noreferrer%22%3E%231169%3C%2FA%3E%3C%2FLI%3E%3CLI%3EUpdated%20ISQLServerBulkData%20APIs%20to%20throw%20SQLException%20instead%20of%20SQLServerException%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%20noreferrer%20noopener%20noreferrer%22%3E%231187%3C%2FA%3E%3C%2FLI%3E%3CLI%3EChanged%20SQLServerConnection.state%20to%20volatile%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1194%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%231194%3C%2FA%3E%3C%2FLI%3E%3CLI%3EOptimized%20temporal%20datatype%20getter%20methods%20by%20replacing%20Calendar%20with%20LocalDatetime%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%20noreferrer%20noopener%20noreferrer%22%3E%231200%3C%2FA%3E%3C%2FLI%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%2F1203%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%231203%3C%2FA%3E%3C%2FLI%3E%3C%2FUL%3E%3CH3%20id%3D%22toc-hId--69588820%22%20id%3D%22toc-hId--69588780%22%3EGetting%20the%20latest%20release%3C%2FH3%3E%3CP%3EThe%20latest%20bits%20are%20available%20on%20our%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Freleases%2Ftag%2Fv8.1.1%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%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.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.1.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%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%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-1059160%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%20improves%20support%20for%20Always%20Encrypted%20with%20enclaves.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1059160%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 improves support for Always Encrypted with enclaves along with other 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 more tests to improve code coverage for Always Encrypted with secure enclaves feature #1186
  • Added certificate and enclave session caching for Always Encrypted with secure enclaves feature #1189

Fixed issues

  • 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

Changed

  • Made internal model public for SQLServerSpatialDatatype class #1169
  • Updated ISQLServerBulkData APIs to throw SQLException instead of SQLServerException #1187
  • Changed SQLServerConnection.state to volatile #1194
  • Optimized temporal datatype getter methods by replacing Calendar with LocalDatetime #1200
  • Updated driver and test dependencies #1203

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

 

 

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