Microsoft SQL Server 2005 JDBC Driver
In its continued commitment to interoperability, Microsoft provides a Java Database Connectivity (JDBC) driver for use with SQL Server 2005. The SQL Server 2005 JDBC Driver is available to all SQL Server users at no additional charge, and provides access to SQL Server 2000 and SQL Server 2005 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 J2EE (Java2 Enterprise Edition).
The SQL Server 2005 JDBC Driver is JDBC 3.0 compliant and runs on the Java Runtime Environment (JRE) 1.4 and later versions. It has been tested against all major application servers, including BEA WebLogic, IBM WebSphere, JBoss, and Sun.
SQL Server JDBC Driver DocumentationOverview of the JDBC Driver
The Microsoft SQL Server 2005 JDBC Driver is a Java Database Connectivity (JDBC) 3.0 compliant driver that provides robust data access to SQL Server 2000 and SQL Server 2005 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. |
| Previous VersionsDownload SQL Server 2005 JDBC Driver 1.1
This version of the JDBC driver includes support for integrated authentication and database mirroring and a number of performance enhancements. In addition, this release includes an expanded help system that has sample applications to help you learn how to use the driver with a SQL Server 2005 database. | Download the SQL Server 2005 JDBC Driver 1.0
This earlier version of the JDBC driver can be used to connect to SQL Server 2000 or SQL Server 2005 databases. This version of the JDBC driver is available in Simplified Chinese, Traditional Chinese, German, English, Spanish, French, Italian, Japanese, Korean, and Swedish. |
BlogsData Team Blog
Discussions from the Data Programmability product team on data access components — ODBC, OLE DB, JDBC, ADO, ADO.NET, protocols, etc. | JDBC Blog
Discussions related to the Microsoft SQL Server JDBC Driver. Topics include JDBC API and SQL connectivity. | Protocols Blog
Discussions related to Microsoft's SQL Server Protocols V Netlibs, TDS, and (new for SQL 2005) SOAP. Topics include connections and SQL connectivity. |
ForumsSQL Server Data Access
Answers to SQL Server Data Programmability product questions, including JDBC driver issues. |
Newsgroups |