Microsoft JDBC Driver for SQL Server

In its continued commitment to interoperability, Microsoft provides a Java Database Connectivity (JDBC) driver for use with SQL Server. The Microsoft JDBC Driver for SQL Server is available to all SQL Server users at no additional charge, and provides access to SQL Server 2008 R2, SQL Server 2008, SQL Server 2005 and SQL Server 2000 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) available in Java Platform Standard Edition 5 (Java SE 5) and Java Platform Standard Edition 6 (Java SE 6).

The Microsoft JDBC Driver for SQL Server is JDBC 4.0 compliant and runs on the Java Runtime Environment (JRE) 5.0 and 6.0. It has been tested against major application servers such as IBM WebSphere, and SAP NetWeaver.

	Download Microsoft SQL Server JDBC Driver 3.0 This version of the JDBC Driver provides support for features introduced in SQL Server 2008, which includes date and time data types, sparse columns, MERGE statements and large user-defined types (UDTs) The support for the new date and time data types includes new setter, getter, and updater methods for SQL Server time, date, datetime2 and datetimeoffeset data types. Support for large UDTs includes handling CLR UDTs that are larger than 8000 bytes as binary data. Also, this release adds unwrap and isWrapper methods of the Wrapper interface. In addition, this release enhances metadata support by adding sparse column metadata and new date and time metadata.
	Register to Redistribute the SQL Server JDBC Driver The SQL Server JDBC driver is freely redistributable under a separate Redistribution License that requires registration.
	Frequently Asked Questions for the Microsoft JDBC Driver for SQL Server This article provides answers to the top 20 most frequently asked questions about the Microsoft SQL Server JDBC 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 The Microsoft SQL Server JDBC Driver 3.0 is a Java Database Connectivity (JDBC) 4.0 compliant driver that provides robust data access to SQL Server 2008 R2, SQL Server 2008, SQL Server 2005 and SQL Server 2000 databases.
	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.
	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.
	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.
	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.
	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.
	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

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.

JDBC Blog

Discussions related to the Microsoft JDBC Driver for SQL Server. Topics include JDBC API and SQL connectivity.

Protocols Blog

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

Forums

SQL Server Data Access
Answers to SQL Server Data Programmability product questions, including JDBC driver issues.

Support Policy

For more information about support for this driver, read the JDBC Driver support lifecycle policy.

CTP Download!

Download Microsoft JDBC Driver 4.0 for SQL Server CTP!

Thank you for your feedback on our first two community technical previews (CTPs). We are pleased to announce the third CTP of the JDBC driver for SQL Server 2012. This CTP expands on our support for SQL Server AlwaysOn in SQL Server 2012 by adding read only routing functionality to the JDBC driver.