Home
%3CLINGO-SUB%20id%3D%22lingo-sub-385938%22%20slang%3D%22en-US%22%3EEarly%20technical%20preview%20of%20JDBC%206.5.4%20for%20SQL%20Server%20released%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-385938%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3EFirst%20published%20on%20MSDN%20on%20Jul%2002%2C%202018%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%20We%20have%20a%20new%20early%20technical%20preview%20of%20the%20JDBC%20Driver%20for%20SQL%20Server.%20Precompiled%20binaries%20are%20available%20on%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Freleases%2Ftag%2Fv6.5.4%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20GitHub%20%3C%2FA%3E%20and%20also%20on%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%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%20Maven%20Central%20%3C%2FA%3E%20.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Below%20is%20a%20summary%20of%20the%20new%20additions%20to%20the%20project%2C%20changes%20made%2C%20and%20issues%20fixed.%20%3CBR%20%2F%3E%3CH3%20id%3D%22toc-hId-1511084482%22%20id%3D%22toc-hId-1535899272%22%3EAdded%3C%2FH3%3E%3CBR%20%2F%3E%3CUL%3E%3CBR%20%2F%3E%3CLI%3EAdded%20new%20connection%20property%20%22useBulkCopyForBatchInsert%22%20to%20enable%20Bulk%20Copy%20API%20support%20for%20batch%20insert%20operation%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Fpull%2F686%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20%23686%3C%2FA%3E%3C%2FLI%3E%3CBR%20%2F%3E%3CLI%3EAdded%20implementation%20for%20Java%209%20introduced%20Boundary%20method%20APIs%20on%20Connection%20interface%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Fpull%2F708%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20%23708%3C%2FA%3E%3C%2FLI%3E%3CBR%20%2F%3E%3CLI%3EAdded%20support%20for%20%22Data%20Classification%20Specifications%22%20on%20fetched%20resultsets%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Fpull%2F709%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20%23709%3C%2FA%3E%3C%2FLI%3E%3CBR%20%2F%3E%3CLI%3EAdded%20support%20for%20UTF-8%20feature%20extension%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Fpull%2F722%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20%23722%3C%2FA%3E%3C%2FLI%3E%3CBR%20%2F%3E%3C%2FUL%3E%3CBR%20%2F%3E%3CH3%20id%3D%22toc-hId--1041072479%22%20id%3D%22toc-hId--1016257689%22%3EFixed%20Issues%3C%2FH3%3E%3CBR%20%2F%3E%3CUL%3E%3CBR%20%2F%3E%3CLI%3EFixed%20issue%20with%20escaping%20catalog%20name%20when%20retrieving%20from%20database%20metadata%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Fpull%2F718%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20%23718%3C%2FA%3E%3C%2FLI%3E%3CBR%20%2F%3E%3CLI%3EFixed%20issue%20with%20tests%20requiring%20additional%20dependencies%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Fpull%2F729%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20%23729%3C%2FA%3E%3C%2FLI%3E%3CBR%20%2F%3E%3C%2FUL%3E%3CBR%20%2F%3E%3CH3%20id%3D%22toc-hId-701737856%22%20id%3D%22toc-hId-726552646%22%3EChanged%3C%2FH3%3E%3CBR%20%2F%3E%3CUL%3E%3CBR%20%2F%3E%3CLI%3EMade%20driver%20default%20compliant%20to%20JDBC%204.2%20specifications%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Fpull%2F711%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20%23711%3C%2FA%3E%3C%2FLI%3E%3CBR%20%2F%3E%3CLI%3EUpdated%20ADAL4J%20dependency%20version%20to%201.6.0%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Fpull%2F711%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20%23711%3C%2FA%3E%3C%2FLI%3E%3CBR%20%2F%3E%3CLI%3ECleaned%20up%20socket%20handling%20implementation%20to%20generalize%20functionality%20for%20different%20JVMs%20and%20simplified%20the%20logic%20for%20single%20address%20case%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Fpull%2F663%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20%23663%3C%2FA%3E%3C%2FLI%3E%3CBR%20%2F%3E%3C%2FUL%3E%3CBR%20%2F%3E%20%3CSTRONG%3EGetting%20the%20Preview%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%20The%20latest%20bits%20are%20available%20on%20our%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Freleases%2Ftag%2Fv6.5.4%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20GitHub%20repository%20%3C%2FA%3E%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%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%20Maven%20Central%20%3C%2FA%3E%20.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Add%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%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Java%208%3A%20%3CBR%20%2F%3E%3CCODE%3E%0A%20%20%20%3CDEPENDENCY%3E%0A%20%20%20%3CBR%20%2F%3E%0A%20%20%20%3CGROUPID%3Ecom.microsoft.sqlserver%3C%2FGROUPID%3E%0A%20%20%20%3CBR%20%2F%3E%0A%20%20%20%3CARTIFACTID%3Emssql-jdbc%3C%2FARTIFACTID%3E%0A%20%20%20%3CBR%20%2F%3E%0A%20%20%20%3CVERSION%3E6.5.4.jre8-preview%3C%2FVERSION%3E%0A%20%20%20%3CBR%20%2F%3E%0A%20%20%20%3C%2FDEPENDENCY%3E%0A%20%20%3C%2FCODE%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20Java%2010%3A%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CCODE%3E%0A%20%20%20%3CDEPENDENCY%3E%0A%20%20%20%3CBR%20%2F%3E%0A%20%20%20%3CGROUPID%3Ecom.microsoft.sqlserver%3C%2FGROUPID%3E%0A%20%20%20%3CBR%20%2F%3E%0A%20%20%20%3CARTIFACTID%3Emssql-jdbc%3C%2FARTIFACTID%3E%0A%20%20%20%3CBR%20%2F%3E%0A%20%20%20%3CVERSION%3E6.5.4.jre10-preview%3C%2FVERSION%3E%0A%20%20%20%3CBR%20%2F%3E%0A%20%20%20%3C%2FDEPENDENCY%3E%0A%20%20%3C%2FCODE%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20We%20provide%20limited%20support%20while%20in%20preview.%20Should%20you%20run%20into%20any%20issues%2C%20please%20file%20an%20issue%20on%20our%0A%20%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Fissues%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%0A%20%20%20GitHub%20Issues%0A%20%20%3C%2FA%3E%0A%20%20page.%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20As%20always%2C%20we%20welcome%20contributions%20of%20any%20kind.%20We%20appreciate%20everyone%20who%20has%20taken%20the%20time%20to%20contribute%20to%20the%20project%20thus%20far.%20For%20feature%20requests%2C%20please%20file%20an%20issue%20on%20the%0A%20%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fmssql-jdbc%2Fissues%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%0A%20%20%20GitHub%20Issues%0A%20%20%3C%2FA%3E%0A%20%20page%20to%20help%20us%20track%20and%20follow-up%20directly.%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20We%20would%20also%20appreciate%20if%20you%20could%20take%0A%20%20%3CA%20href%3D%22https%3A%2F%2Faka.ms%2Fmssqljdbcsurvey%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%0A%20%20%20this%20survey%0A%20%20%3C%2FA%3E%0A%20%20to%20help%20us%20continue%20to%20improve%20the%20JDBC%20Driver.%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20Please%20also%20check%20out%20our%0A%20%20%3CA%20href%3D%22http%3A%2F%2Faka.ms%2Fsqldev%3Futm_medium%3DReferral%26amp%3Butm_source%3Dhttps%3A%2F%2Fblogs.msdn.microsoft.com%2Fjdbcteam%2F2017%2F07%2F31%2Fearly-technical-preview-of-jdbc-6-3-0-for-sql-server-released%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%0A%20%20%20tutorials%0A%20%20%3C%2FA%3E%0A%20%20to%20get%20started%20with%20developing%20apps%20in%20your%20programming%20language%20of%20choice%20and%20SQL%20Server.%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20David%20Engel%0A%20%0A%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-385938%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20MSDN%20on%20Jul%2002%2C%202018%20We%20have%20a%20new%20early%20technical%20preview%20of%20the%20JDBC%20Driver%20for%20SQL%20Server.%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-385938%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESQLServerDrivers%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Microsoft
First published on MSDN on Jul 02, 2018
We have a new early technical preview of the JDBC Driver for SQL Server. Precompiled binaries are available on GitHub and also on Maven Central .

Below is a summary of the new additions to the project, changes made, and issues fixed.

Added



  • Added new connection property "useBulkCopyForBatchInsert" to enable Bulk Copy API support for batch insert operation #686

  • Added implementation for Java 9 introduced Boundary method APIs on Connection interface #708

  • Added support for "Data Classification Specifications" on fetched resultsets #709

  • Added support for UTF-8 feature extension #722


Fixed Issues



  • Fixed issue with escaping catalog name when retrieving from database metadata #718

  • Fixed issue with tests requiring additional dependencies #729


Changed



  • Made driver default compliant to JDBC 4.2 specifications #711

  • Updated ADAL4J dependency version to 1.6.0 #711

  • Cleaned up socket handling implementation to generalize functionality for different JVMs and simplified the logic for single address case #663


Getting the Preview
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.

Java 8:
<dependency>
<groupId>com.microsoft.sqlserver</groupId>
<artifactId>mssql-jdbc</artifactId>
<version>6.5.4.jre8-preview</version>
</dependency>

Java 10:
<dependency>
<groupId>com.microsoft.sqlserver</groupId>
<artifactId>mssql-jdbc</artifactId>
<version>6.5.4.jre10-preview</version>
</dependency>

We provide limited support while in preview. Should you run into any issues, please file an issue on our GitHub Issues page.

As always, we welcome contributions of any kind. We appreciate everyone who has taken the time to contribute to the project thus far. For feature requests, please file an issue on the GitHub Issues page to help us track and follow-up directly.

We would also appreciate if you could take this survey to help us continue to improve the JDBC Driver.

Please also check out our tutorials to get started with developing apps in your programming language of choice and SQL Server.

David Engel