JDBC is an application programming interface (API) included in the Java™ platform that enables Java programs to connect to a wide range of databases.
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 |
SQLXML represents an SQL XML value. ![]() |
JDBC 4.0 ![]() |
| 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 |