Skip to main content

Microsoft JDBC Driver for SQL Server

In our continued commitment to interoperability, Microsoft provides a Java Database Connectivity (JDBC) driver for use with SQL Server, SQL Azure, and Parallel Data Warehouse (PDW). The Microsoft JDBC Driver for SQL Server is available at no additional charge, and provides Java Database Connectivity from any Java application, application server, or Java-enabled applet. This driver is a Type 4 JDBC driver that provides database connectivity through the standard JDBC application program interfaces (APIs).

The Microsoft JDBC Driver for SQL Server has been tested against major application servers such as IBM WebSphere, and SAP NetWeaver.

Download Microsoft SQL Server JDBC Driver 3.0 Download the Microsoft JDBC Driver 4.0 for SQL Server

The 4.0 version of the JDBC Driver provides support for features introduced in SQL Server 2012, including AlwaysOn, Correlated Tracing via XEvents, and UTF-16 support. This release also adds Type 4 Kerberos support on Windows and non-Windows platforms.

Register to Redistribute Register to Redistribute the JDBC Driver

The Microsoft JDBC driver is freely redistributable under a separate Redistribution License that requires registration.

Review the Support Matrix Review the Support Matrix

Review the support matrix to understand which operating systems and Java versions we support. The support matrix also explains our support policy for the driver.

Frequently Asked Questions Frequently Asked Questions

This article provides answers to the most frequently asked questions about the driver. For detailed documentation, see the Microsoft JDBC Driver for SQL Server Documentation.

Microsoft JDBC Driver for SQL Server Documentation

Overview of the Microsoft JDBC Driver for SQL Server Overview of the Microsoft JDBC Driver for SQL Server

The Microsoft SQL Server JDBC Driver 4.0 is a Java Database Connectivity (JDBC) 4.0 compliant driver that provides robust data access to SQL Server 2012, SQL Server 2008 R2, SQL Server 2008, SQL Server 2005 and SQL Azure.

Article: Connecting to SQL Server with the JDBC Driver Connecting to SQL Server with the JDBC Driver

One of the most fundamental things that you will do with the JDBC driver is to make a connection to a SQL Server database. All interaction with the database happens through the SQLServerConnection object, and because the JDBC driver has such a flat architecture, almost all interesting behavior touches the SQLServerConnection object.

Article: Understanding the JDBC Driver Data Types Understanding the JDBC Driver Data Types

The JDBC driver supports the use of JDBC basic and advanced data types within a Java application that uses SQL Server as its database.

Article: Using Statements with the JDBC Driver Using Statements with the JDBC Driver

The JDBC driver can be used to work with data in a SQL Server database in a variety of ways. The JDBC driver can be used to run SQL statements against the database, or it can be used to call stored procedures in the database, using both input and output parameters.

Article: Managing Result Sets with the JDBC Driver Managing Result Sets with the JDBC Driver

The JDBC driver supports the use of result sets, including result set cursor types, concurrency, and row locking.

Article: Performing Transactions with the JDBC Driver Performing Transactions with the JDBC Driver

The topics in this section describe how the JDBC driver supports transactions including isolation levels, transaction savepoints, and result set holdability.

Reference: JDBC Driver API Reference JDBC Driver API Reference

The JDBC driver implements a number of classes that make up the JDBC driver application programming interface (API). The JDBC API can be used within Java programming code to connect to and interact with a Microsoft SQL Server database.

Blogs

JDBC Blog

Announcements and discussions related to the Microsoft JDBC Driver for SQL Server.

Data Team Blog

Discussions from the Data Programmability product team on data access components — ODBC, OLE DB, JDBC, ADO, ADO.NET, protocols, and so on.

Protocols Blog

Discussions related to Microsoft's SQL Server Protocols - Netlibs, TDS, SQL Browser, and so on.

Forums

SQL Server Data Access

Answers to JDBC Driver questions as well as SQL Server Data Programmability questions.

Support Matrix

For more information about support for this driver and the support matrix, see our Support Matrix.