Skip to main content

Microsoft JDBC Driver for SQL Server Support Matrix

This page contains the support matrix and support lifecycle policy for the Microsoft JDBC Driver for SQL Server.

List of Driver Versions

Driver NameDriver Version
Microsoft SQL Server JDBC Driver 4.1 for SQL Server4.1
Microsoft JDBC Driver 4.0 for SQL Server4.0
Microsoft SQL Server JDBC Driver 3.03.0
Unsupported Versions Below
Microsoft SQL Server JDBC Driver 2.02.0
Microsoft SQL Server 2005 JDBC Driver 1.21.2
Microsoft SQL Server 2005 JDBC Driver 1.11.1
Microsoft SQL Server 2005 JDBC Driver 1.01.0
Microsoft SQL Server 2000 JDBC Driver2000

Microsoft JDBC Driver Support Lifecycle Matrix and Policy

The Microsoft Support Lifecycle (MSL) policy provides transparent, predictable information regarding the support lifecycle of Microsoft products. JDBC driver versions 3.0 and 4.0 have five year Mainstream support from the driver release date. Mainstream support is defined on the Microsoft support lifecycle website.

Extended and custom support options are not available for the Microsoft JDBC Driver.

Support will end as per the matrix below.

JDBC Driver VersionEnd of Support
4.1December 12th 2019
4.0March 6th 2017
3.0April 23rd 2015
2.0December 31st 2012
1.2June 25th 2011
1.1June 25th 2011
1.0June 25th 2011
2000July 9th 2010

SQL Version Compatibility

JDBC Driver VersionSQL Server 2000SQL Server 2005SQL Server 2008SQL Server 2008R2SQL Server 2012Azure SQL DatabasePDW 2008R2 AU34SQL Server 2014
4.1NNYYYYYY
4.0NYYYYYYY
3.0YYYYY1Y2NY5
2.0YYY3Y3NNNN
1.2YYY3NNNNN
1.1YYNNNNNN
1.0YYNNNNNN
2000YNNNNNNN

1Microsoft SQL Server JDBC Driver version 3.0 can connect to SQL Server 2012 as a down-level client.

2Support for Azure SQL Database was introduced in the 3.0 driver as a hotfix. We recommend that Azure SQL Database customers use the latest driver version available.

3Microsoft SQL Server JDBC Driver version 2.0 and Microsoft SQL Server 2005 JDBC Driver version 1.2 can connect to SQL Server 2008 as a down-level client. When down-level conversions are allowed, applications can execute queries and perform updates on the new SQL Server 2008 data types, such as time, date, datetime2, datetimeoffset, and FILESTREAM. For more information about how to use these new data types with the JDBC driver, see Working with SQL Server 2008 Date/Time Data Types using JDBC Driver and Working with SQL Server 2008 FileStream using JDBC Driver. For more information about the down-level compatibility of these new data types, see Using Date and Time Data and FILESTREAM Support topics in SQL Server Books Online.

4Support for connections between the Microsoft JDBC Driver and Parallel Data Warehouse was first introduced in the Microsoft JDBC Driver 4.0 for SQL Server and Microsoft SQL Server 2008 R2 Parallel Data Warehouse Appliance Update 3.

5Microsoft SQL Server JDBC Driver version 3.0 can connect to SQL Server 2014 as a down-level client.

Java and JDBC Specification Support

JDBC Driver VersionJRE VersionsJDBC API Version
4.11.5, 1.6, 1.73.0, 4.0
4.01.5, 1.6, 1.73.0, 4.0
3.01.5, 1.63.0, 4.0
2.01.5, 1.63.0, 4.0
1.21.4, 1.5, 1.63.0
1.11.43.0
1.01.43.0
20001.43.0

 

Supported Operating Systems

The Microsoft JDBC driver is designed to work on any operating system that supports the use of a Java Virtual Machine (JVM).  Some commonly used platforms include Windows 8.1, Windows 8, Windows 7, Windows Server 2008 R2, Windows Vista, Linux, Unix, AIX, MacOS, and others.

The JDBC product team tests our driver on Windows, Sun Solaris, SUSE Linux, and RedHat Linux.  Customer Support is available to customers on all platforms, however we may ask you to reproduce the issue on a platform such as Windows.

Application Server Support

The Microsoft JDBC Driver for SQL Server is tested with various application servers.  Consult your application server vendor for additional details on which driver version is compatible with their product.  Some links are provided below.

Blogs

JDBC Blog

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

Forums

SQL Server Data Access

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

Microsoft is conducting an online survey to understand your opinion of the MSDN Web site. If you choose to participate, the online survey will be presented to you when you leave the MSDN Web site.

Would you like to participate?