Microsoft SQL Server JDBC driver Support matrix

Source: Internet
Author: User
Tags microsoft sql server microsoft sql server 2005 sql server books mssql

This page contains support matrices and support lifecycle policies for the Microsoft SQL Server JDBC driver.

Microsoft JDBC driver supports life cycle matrices and policies

The Microsoft Support life cycle (MSL) policy provides predictable, transparent information about the support life cycle of Microsoft products. The JDBC driver version 3.0, 4.x, 6.x, and 7.x have five years of mainstream support since the date the driver was released. Mainstream support is defined on the Microsoft support life cycle site.

The Microsoft JDBC driver does not provide extended and custom support options.

The following Microsoft JDBC drivers are supported until the specified support end date.

driver name Driver package Version applicable JAR (s) Mainstream Support ends
Microsoft JDBC Driver 7.0 for SQL Server 7.0 Mssql-jdbc-7.0.0.jre10.jar
Mssql-jdbc-7.0.0.jre8.jar
July 31, 2023
Microsoft JDBC Driver 6.4 for SQL Server 6.4 Mssql-jdbc-6.4.0.jre9.jar
Mssql-jdbc-6.4.0.jre8.jar
Mssql-jdbc-6.4.0.jre7.jar
February 27, 2023
Microsoft JDBC Driver 6.2 for SQL Server 6.2 MSSQL JDBC 6.2.2.jre8.jar
Mssql-6.2.2.jre7.jar
June 30, 2022
Microsoft JDBC Driver 6.0 for SQL Server 6.0 Sqljdbc42.jar
Sqljdbc41.jar
July 14, 2021
Microsoft SQL Server JDBC driver 4.2 4.2 Sqljdbc42.jar
Sqljdbc41.jar
August 24, 2020
Microsoft SQL Server JDBC driver 4.1 4.1 Sqljdbc41.jar December 12, 2019

The following Microsoft JDBC drivers are no longer supported.

driver name Driver package Version Mainstream Support ends
Microsoft JDBC Driver 4.0 for SQL Server 4.0 March 6, 2017
Microsoft SQL Server JDBC Driver 3.0 3.0 April 23, 2015
Microsoft SQL Server JDBC Driver 2.0 2.0 December 31, 2012
Microsoft SQL Server 2005 JDBC Driver 1.2 1.2 June 25, 2011
Microsoft SQL Server 2005 JDBC driver 1.1 1.1 June 25, 2011
Microsoft SQL Server 2005 JDBC Driver 1.0 1.0 June 25, 2011
Microsoft SQL Server # JDBC Driver 2000 July 9, 2010
SQL version Compatibility
driver version sql Server 2008 sql Server 2008R2 sql Server azure SQL Database PDW 2008R2 AU34 sql Server sql server sql Server Span data-ttu-id= "de00e-179" >azure SQL Managed instance (extended personal preview)
6.4 no Yes is Yes Yes Yes Yes
6.2 Yes Yes is Yes Yes Yes Yes no
6.1 Yes Yes is Yes Yes Yes no no
6.0 Yes Yes is Yes Yes Yes no no
4.2 Yes Yes is Yes Yes Yes no no
4.1 Yes Yes is Yes Yes Yes no no
4.0 Yes Yes is Yes Yes Yes no no
3.0 Yes Yes 1 is 2 no Yes 5 no no no
2.0 Yes 3 is 3 no no no No no no no
1.2 Yes 3 no no no no No no no no
1.1 no no no no no No no no no
1.0 no no no no no No no no no
2000 Whether Whether Whether Whether Whether Whether Whether Whether Whether

The 1Microsoft SQL Server JDBC Driver version 3.0 can be used as a subordinate client to connect to SQL Server 2012.

23.0 support for Azure SQL Database was introduced as a patch in the driver. It is recommended that Azure SQL Database customers use the latest driver version.

The 3Microsoft SQL Server JDBC Driver version 2.0 and Microsoft SQL Server 2005 JDBC Driver version 1.2 can be connected to SQL Server 2008 as a subordinate client. When subordinate conversions are allowed, applications can perform queries and updates on 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 date/time data Types using JDBC Driver (using the JDBC driver to process S  QL Server 2008 Date/Time data type) and working with SQL Server FileStream using JDBC Driver (using the JDBC driver to process SQL Server 2008 file streams). For more information about the subordinate compatibility of these new data types, see the Using date and time data in SQL Server Books Online (using date-and-times information) and the FILESTREAM support (file stream supported) topic.

4Microsoft SQL Server JDBC Driver 4.0 and Microsoft SQL Server R2 parallel Data Warehouse Device Update 3 first introduced the connection support between the Microsoft JDBC driver and the parallel Data Warehouse.

The 5Microsoft SQL Server JDBC Driver version 3.0 can be used as a subordinate client to connect to SQL Server 2014.

Java and JDBC specification support
JDBC driver Version JRE version JDBC API Version
7.0 1.8, 10 4.2, 4.3 (part)
6.4 1.7, 1.8, 9 4.1, 4.2, 4.3 (part)
6.2 1.7, 1.8 4.1, 4.2
6.1 1.7, 1.8 4.1, 4.2
6.0 1.7, 1.8 4.1, 4.2
4.2 1.7, 1.8 4.1, 4.2
4.1 1.7 4.0
4.0 1.5, 1.6, 1.7 3.0, 4.0
3.0 1.5, 1.6, 3.0, 4.0
2.0 1.5, 1.6 3.0, 4.0
1.2 1.4, 1.5, 1.6 3.0
1.1 1.4 3.0
1.0 1.4 3.0
2000 1.4 3.0
Supported operating Systems

The Microsoft JDBC driver can work on any operating system that supports the use of a Java virtual machine (JVM). Some common platforms include Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server R2, Windows Vista, Linux, Unix, AIX, MacOS, and more.

The JDBC product team tested the drivers on Windows, Sun Solaris, SUSE Linux, and RedHat Linux. customer support is available on all platforms, but we may ask you to reproduce the problem on a platform such as Windows.

Application Server Support

The Microsoft SQL Server JDBC driver was tested against various application servers. check with the application server vendor for additional details about the version of the driver that is compatible with its product.

Microsoft SQL Server JDBC driver Support matrix

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.