Skip to content

SQL Server Blog


We are pleased to announce availability of the Microsoft JDBC 4.2 Driver for SQL Server! The updated driver provides robust data access to Microsoft SQL Server and Microsoft Azure SQL Database for Java-based applications.

The JDBC Driver for SQL Server is a Java Database Connectivity (JDBC) type 4 driver that implements full compliance with the JDBC specifications 4.1 and 4.2 and supports Java Development Kit (JDK) version 1.8. It supports the Transport Layer Security (TLS) 1.2 protocol for additional security over the internet. The JDBC 4.2 Driver for SQL also supports SQL Server’s AlwaysOn feature for High Availability and Disaster Recovery.

There are several additional enhancements available with the driver:

  • The updated XA Transaction feature includes new timeout options for automatic rollback of unprepared transactions.
  • New SQLServerBulkCopy class enables developers to quickly copy large amounts of data into tables or views in SQL Server and Azure SQL Database databases from other databases. For more details about what is currently supported in the bulk copy feature, please refer to What’s New in the JDBC driver.

The JDBC driver is part of SQL Server and the Microsoft Data Platform’s wider interoperability program, with drivers for PHP 5.6, Node.js, JDBC, ODBC and ADO.NET already available.

SQL Server connectivity landscape

You can download the JDBC 4.2 driver here.  We invite you to explore the latest the Microsoft Data Platform has to offer via a trial of Microsoft Azure SQL Database or by trying the new SQL Server 2016 CTP. Have questions?

Join the discussion on Stack Overflow. Running into an issue or have a suggestion? Let us know.