Home
%3CLINGO-SUB%20id%3D%22lingo-sub-916854%22%20slang%3D%22en-US%22%3EEarly%20technical%20preview%20of%20JDBC%20Driver%208.1.0%20for%20SQL%20Server%20released%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-916854%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%20adds%20support%20for%20Always%20Encrypted%20with%20enclaves.%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.0%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-1649581816%22%20id%3D%22toc-hId-1650354465%22%3EAdded%3C%2FH3%3E%3CUL%3E%3CLI%3EAdded%20ISQLServerBulkData%20to%20remove%20implementation%20details%20from%20ISQLServerBulkRecord%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fmicrosoft%2Fmssql-jdbc%2Fpull%2F1099%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%231099%3C%2FA%3E%3C%2FLI%3E%3CLI%3EAdded%20support%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%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%3EAdded%20support%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%3EAdded%20support%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%3C%2FUL%3E%3CH3%20id%3D%22toc-hId--902575145%22%20id%3D%22toc-hId--901802496%22%3EFixed%20Issues%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%2F1074%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%2F1092%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%2F1133%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%2F1138%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%2F1117%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%231117%3C%2FA%3E%3C%2FLI%3E%3C%2FUL%3E%3CH3%20id%3D%22toc-hId-840235190%22%20id%3D%22toc-hId-841007839%22%3EChanged%3C%2FH3%3E%3CUL%3E%3CLI%3EImproved%20performance%20of%20column%20name%20lookups%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%231066%3C%2FA%3E%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%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%231149%3C%2FA%3E%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CH3%20id%3D%22toc-hId--1711921771%22%20id%3D%22toc-hId--1711149122%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.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%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%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.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%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-916854%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%20adds%20support%20for%20Always%20Encrypted%20with%20enclaves.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-916854%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 adds support for Always Encrypted with enclaves.

 

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 ISQLServerBulkData to remove implementation details from ISQLServerBulkRecord #1099
  • Added support for Azure national clouds when using Azure Key Vault #1130
  • Implemented hashCode() and equals() APIs for SQLServerDataTable and SQLServerDataColumn #1146
  • Added support for JAVA 13 #1151
  • Added support for Always Encrypted with secure enclaves #1155

Fixed Issues

  • 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

Changed

  • Improved performance of column name lookups #1066
  • Improved performance of CallableStatement and ParameterMetaData when using procedure names that contain wildcard characters #1149

 

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.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