JDBC access DB2

Sample program using JDBC access DB2 database.

Prerequisite: installing DB2 JDBC driver and license JARs

The DB2 Universal JDBC Driver.

1. db2jcc.jar : includes functions in the JDBC 3.0 and earlier specifications, or
2. db2jcc4.jar : includes functions in JDBC 4.0 and later, as well as JDBC 3.0 and earlier specifications.

The DB2 JDBC License JARs

1. db2jcc_license_cisuz.jar: contains licenses for Linux, Unix, Windows®, IBM System i®, and IBM System z.
2. db2jcc_license_cu.jar. This alternate license is not sufficient to connect to DB2 running on z/OS.

Sample Java Code

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.SQLException;

public class DB2Test {
    public static void main(String[] argv) {
        try {
            Class.forName(&