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 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:
- Use the IBM Toolbox JDBC driver when the Java program is on one system and the database
files are on another system, as in a client/server environment
- Use the native JDBC driver when both the Java program
and database files are on the same server
Different versions of JDBC
Different versions
of the JDBC API exist, and the IBM Toolbox
for Java JDBC driver supports the following versions:
- JDBC 1.2 API (the java.sql package) is included in the Java Platform 1.1 core API and JDK 1.1.
- JDBC 2.1 core API (the java.sql package) is included in both the Java 2 Platform, Standard Edition (J2SE) and
the Java 2 Platform Enterprise Edition (J2EE).
- JDBC 2.0 Optional Package API (the javax.sql package) is included
in J2EE and is available as a separate
download from Sun. These extensions were formerly named the
JDBC 2.0 Standard Extension API.
- JDBC 3.0 API (the java.sql and javax.sql packages) is included
in J2SE, Version 1.4 and 5.0.
- JDBC 4.0 API is included in Java SE
Version 6.