JDBC Driver API Reference

 

DownloadDownload JDBC Driver

The Microsoft JDBC Driver for SQL Server provides an API that can be used within Java programming code to connect to and interact with a MicrosoftSQL Server database.

System_CAPS_ICON_note.jpg Note


For conceptual information about using the JDBC driver, see Overview of the JDBC Driver.

System_CAPS_ICON_important.jpg Important


For JDBC 4.1 and 4.2 compliance support, use Microsoft JDBC Driver 4.2 (or higher) for SQL Server. The previous Microsoft JDBC Drivers 4.1 and 4.0 releases do not support new methods introduced with JDBC 4.1 or 4.2.

API details for JDBC 4.1 compliance are not in this section. See JDBC 4.1 Compliance for the JDBC Driver.

API details for JDBC 4.2 compliance are not found in this section. See JDBC 4.2 Compliance for the JDBC Driver.

API details for Bulk Copy, available starting with Microsoft JDBC Driver 4.2 for SQL Server, are not found in this section. See Using Bulk Copy with the JDBC Driver.

API details for Always Encrypted, available starting with Microsoft JDBC Driver 6.0 for SQL Server, are not found in this section. See Always Encrypted API Reference for the JDBC Driver

API details for Using Table-Valued Parameters, available starting with Microsoft JDBC Driver 6.0 for SQL Server, are not found in this section. See Using Table-Valued Parameters

Microsoft JDBC Drivers 6.0 and 4.2 support compilation with JDK 5.0, 6.0, 7.0, and 8.0.

Microsoft JDBC Driver 4.1 supports compilation with JDK 5.0, 6.0, and 7.0.

Microsoft JDBC Driver 4.0 supports compilation with JDK 5.0 and 6.0.

Interface NameDescription
ISQLServerCallableStatement InterfaceLets you specify the stored procedure name to call along with input and output parameters.
ISQLServerConnection InterfaceRepresents a JDBC connection to a SQL Server database.
SQLServerDataSource ClassRepresents a list of properties specific to connecting to a SQL Server database by using a ISQLServerConnection object.
ISQLServerPreparedStatementRepresents the basic implementation of JDBC prepared statement functionality.
ISQLServerResultSetRepresents a JDBC result set.
ISQLServerStatementRepresents the basic implementation of JDBC statement functionality.
Class NameDescription
DateTimeOffsetRepresents an object of type microsoft.sql.DateTimeOffset.
SQLServerBlobRepresents a binary large object (BLOB).
SQLServerCallableStatementImplements ISQLServerCallableStatement.
SQLServerClobRepresents a character large binary object (CLOB).
SQLServerConnectionImplements ISQLServerConnectopn.
SQLServerConnectionPoolDataSourceRepresents physical database connections for connection pool managers.
SQLServerDatabaseMetaDataRepresents the metadata for the database.
SQLServerDataSourceRepresents a list of properties specific to connecting to a SQL Server database by using a SQLServerConnection object.
SQLServerDataSourceObjectFactoryRepresents an object factory to materialize data sources from the Java Naming and Directory Interface (JNDI).
SQLServerDriverRepresents the JDBC driver. This class includes methods for connecting to a SQL Server database, and for obtaining information about the JDBC driver.
SQLServerExceptionRepresents an unsuccessful or incomplete running of an SQL statement.
SQLServerNClob ClassRepresents a character large binary object using the National Character Set.
SQLServerParameterMetaDataRepresents the metadata for prepared statement parameters.
SQLServerPooledConnectionRepresents a physical database connection in a connection pool.
SQLServerPreparedStatementImplements ISQLServerPreparedStatement.
SQLServerResourceRepresents a localized error string resource. This class is intended for internal use only.
SQLServerResultSetImplements ISQLServerResultSet.
SQLServerResultSetMetaDataRepresents the metadata of the columns that are contained within a result set.
SQLServerSavepointRepresents the checkpoint to which a transaction can be rolled back.
SQLServerStatementImplements ISQLServerStatement.
SQLServerXAConnectionRepresents JDBC connections that can participate in distributed (XA) transactions.
SQLServerXADataSourceRepresents a factory for SQLServerXAConnection objects that is used internally.
SQLServerXAResourceRepresents an XAResource for XA distributed transaction management.

Overview of the JDBC Driver

Community Additions

ADD
Show: