JDBC

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. Begin changeYou 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.End change

Different versions of JDBC

Different versions of the JDBC API exist, and the IBM Toolbox for Java JDBC driver supports the following versions:

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
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
Begin changeConnectionPool represents a pool of Connection objects. JDBC 2.0 Optional PackageEnd change

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
Begin changeParameterMetaData provides the ability to get information about the types and properties of the parameters in a PreparedStatement object JDBC 3.0 APIEnd change
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
Begin changeSavepoint provides finer grained control within transactions JDBC 3.0 APIEnd change
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.

Examples

The following examples illustrate ways to use the IBM Toolbox for Java JDBC driver.