JDBC(TM) is an application programming interface (API) included in the Java platform that enables Java programs to connect to a wide range of databases.
The IBM Toolbox for Java JDBC driver allows you to use JDBC API interfaces
to issue structured query language (SQL) statements to and process results from
databases on the server. You
can also use IBM Developer Kit for Java JDBC driver,
called the 'native' JDBC driver:
For information about ongoing improvements, see What's
new for Modification 5 and Enhancements to Toolbox for Java
JDBC support.
Different versions of the JDBC API exist, and the IBM Toolbox for Java JDBC driver supports the following versions:
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 |
CallableStatement runs SQL stored procedures | JDK 1.1 |
Clob provides access to character large objects (CLOBs) | JDBC 2.1 core |
Connection represents a connection to a specific database | JDK 1.1 |
![]() |
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 |
DataSource represents a factory for database connections. |
JDBC 2.0 Optional Package |
Driver creates the connection and returns information about the driver version. | JDK 1.1 |
![]() |
JDBC 3.0 API![]() |
PreparedStatement runs compiled SQL statements | JDK 1.1 |
ResultSet provides access to a table of data that is generated by running a SQL query or DatabaseMetaData catalog method | JDK 1.1 |
ResultSetMetaData provides information about a specific ResultSet |
JDK 1.1 |
RowSet is a connected row set that encapsulates a ResultSet |
JDBC 2.0 Optional Package |
![]() |
JDBC 3.0 API![]() |
Statement runs SQL statements and obtains the results | JDK 1.1 |
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 |
We have included a table that lists JDBC properties for easy reference.
The following examples illustrate ways to use the IBM Toolbox for Java JDBC driver.