Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
JDBC Driver API Reference
Collapse the table of content
Expand the table of content

JDBC Driver API Reference

 

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 Microsoft SQL Server database.

System_CAPS_noteNote

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

System_CAPS_importantImportant

For JDBC 4.1 and 4.2 compliance support, use Microsoft JDBC Driver 4.2 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 the Bulk Copy Feature, available in Microsoft JDBC Drivers 4.2 for SQL Server, are not found in this section. See Using Bulk Copy with the JDBC Driver.

Microsoft JDBC Driver 4.2 supports 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 Name

Description

ISQLServerCallableStatement Interface

Lets you specify the stored procedure name to call along with input and output parameters.

ISQLServerConnection Interface

Represents a JDBC connection to a SQL Server database.

SQLServerDataSource Class

Represents a list of properties specific to connecting to a SQL Server database by using a ISQLServerConnection object.

ISQLServerPreparedStatement

Represents the basic implementation of JDBC prepared statement functionality.

ISQLServerResultSet

Represents a JDBC result set.

ISQLServerStatement

Represents the basic implementation of JDBC statement functionality.

Class Name

Description

DateTimeOffset

Represents an object of type microsoft.sql.DateTimeOffset.

SQLServerBlob

Represents a binary large object (BLOB).

SQLServerCallableStatement

Implements ISQLServerCallableStatement.

SQLServerClob

Represents a character large binary object (CLOB).

SQLServerConnection

Implements ISQLServerConnectopn.

SQLServerConnectionPoolDataSource

Represents physical database connections for connection pool managers.

SQLServerDatabaseMetaData

Represents the metadata for the database.

SQLServerDataSource

Represents a list of properties specific to connecting to a SQL Server database by using a SQLServerConnection object.

SQLServerDataSourceObjectFactory

Represents an object factory to materialize data sources from the Java Naming and Directory Interface (JNDI).

SQLServerDriver

Represents the JDBC driver. This class includes methods for connecting to a SQL Server database, and for obtaining information about the JDBC driver.

SQLServerException

Represents an unsuccessful or incomplete running of an SQL statement.

SQLServerNClob Class

Represents a character large binary object using the National Character Set.

SQLServerParameterMetaData

Represents the metadata for prepared statement parameters.

SQLServerPooledConnection

Represents a physical database connection in a connection pool.

SQLServerPreparedStatement

Implements ISQLServerPreparedStatement.

SQLServerResource

Represents a localized error string resource. This class is intended for internal use only.

SQLServerResultSet

Implements ISQLServerResultSet.

SQLServerResultSetMetaData

Represents the metadata of the columns that are contained within a result set.

SQLServerSavepoint

Represents the checkpoint to which a transaction can be rolled back.

SQLServerStatement

Implements ISQLServerStatement.

SQLServerXAConnection

Represents JDBC connections that can participate in distributed (XA) transactions.

SQLServerXADataSource

Represents a factory for SQLServerXAConnection objects that is used internally.

SQLServerXAResource

Represents an XAResource for XA distributed transaction management.

Show:
© 2015 Microsoft