JDBC classes

JDBC is an application programming interface (API) included in the Java™ platform that enables Java programs to connect to a wide range of databases.

Supported interfaces

The following table lists the supported JDBC interfaces and the API required to use them:

Supported JDBC interface API required
Blob provides access to binary large objects (BLOBs). JDBC 2.1 core, enhanced support in JDBC 4.0
CallableStatement runs SQL stored procedures. JDK 1.1, enhanced support in JDBC 4.0
Clob provides access to character large objects (CLOBs). JDBC 2.1 core, enhanced support in JDBC 4.0
Connection represents a connection to a specific database. JDK 1.1, enhanced support in JDBC 4.0
ConnectionPool represents a pool of Connection objects. JDBC 2.0 Optional Package
ConnectionPoolDataSource represents a factory for pooled AS400JDBCPooledConnection objects. JDBC 2.0 Optional Package
DatabaseMetaData provides information about the database as a whole. JDK 1.1, enhanced support in JDBC 4.0
DataSource represents a factory for database connections. JDBC 2.0 Optional Package, enhanced support in JDBC 4.0
Driver creates the connection and returns information about the driver version. JDK 1.1
ParameterMetaData provides the ability to get information about the types and properties of the parameters in a PreparedStatement object. JDBC 3.0 API, enhanced support in JDBC 4.0
PooledConnection provides hooks for connection pool management. JDBC 2.0 Optional Package, enhanced support in JDBC 4.0
PreparedStatement runs compiled SQL statements. JDK 1.1, enhanced support in JDBC 4.0
ResultSet provides access to a table of data that is generated by running a SQL query or DatabaseMetaData catalog method. JDK 1.1, enhanced support in JDBC 4.0
ResultSetMetaData provides information about a specific ResultSet. JDK 1.1, enhanced support in JDBC 4.0
RowId represents an SQL ROWID value. JDBC 4.0
RowSet is a connected row set that encapsulates a ResultSet. JDBC 2.0 Optional Package
Savepoint provides finer grained control within transactions JDBC 3.0 API
Start of changeSQLXML represents an SQL XML value. End of change Start of changeJDBC 4.0 End of change
Statement runs SQL statements and obtains the results. JDK 1.1, enhanced support in JDBC 4.0
StatementEvent is sent to all StatementEventListeners which were registered with a PooledConnection. This occurs when the driver determines that a PreparedStatement that is associated with the PooledConnection has been closed or is determined by the driver to be invalid.  
StatementEventListener registers to be notified of events that occur on PreparedStatements that are in the Statement pool. JDBC 4.0
XAConnection is a database connection which participates in global XA transactions. JDBC 2.0 Optional Package
XAResource is resource manager for use in XA transactions. JDBC 2.0 Optional Package