JDBC

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.