[DB2] DB2에서 JDBC 연결하기

v8 이전의 JDBC driver을 DB2 JDBC drvier라고 하고,

v8 이후에 새롭게 추가된 JDBC driver를 Universal JDBC driver라고 명명하고 설명합니다.

v8 이상에서는 Universal JDBC Driver를 사용할 것을 권장합니다.

Class files

- db2java.zip : DB2 JDBC Type 2 and Type 3 Driver

- db2jcc.jar   : Universal Type 2 and Type 4 Driver

License jar files (Universal JDBC driver를 사용할 때 필요)

- db2jcc_license_cu.jar : for connecting DB2 v8 for LUW

- db2jcc_license_cisuz.jar : for connecting DB2 for iSeries and z/OS

JDBC Drvier class name

- DB2 JDBC Type 2 Driver : COM.ibm.db2.jdbc.app.DB2Driver

- DB2 JDBC Type 3 Driver : COM.ibm.db2.jdbc.net.DB2Driver

- Universal JDBC Type 2 Driver : com.ibm.db2.jcc.DB2Driver

- Universal JDBC Type 4 Driver : com.ibm.db2.jcc.DB2Driver

JDBC url name

- DB2 JDBC Type 2 Driver : jdbc:db2:db_name

- DB2 JDBC Type 3 Driver : jdbc:db2://host_name:port_name/db_name

- Universal JDBC Type 2 Driver : jdbc:db2:sample

- Universal JDBC Type 4 Driver : jdbc:db2://host_name:port_name/db_name

Windows DB2 사용시 주의점.

JDBC Type4를 사용했을경우 SUN JDK 사용시, IBM CodeSet으로 자동변환이 안되기

때문에 DATABASE생성시 UTF-8코드로 생성해주어야 함.

p.s. IBM에서 DB2 사용시 JDBC Type2를 권장한다고 함.

JDBC Type4 SAMPLE :

import java.sql.*;

public class DbProcess {
public static void main(String[] args) throws Exception{
  Connection con = null;
     Statement stmt = null;
     ResultSet rs = null;
     String url = "jdbc:db2://localhost:50000/sample";
     String user = "admin";
     String password = "1111";
  try {
            Class.forName("com.ibm.db2.jcc.DB2Driver").newInstance();
            System.out.println("Driver Loading");
        } catch (ClassNotFoundException ex) {
            ex.printStackTrace();
        } catch (IllegalAccessException ex) {
            ex.printStackTrace();
        } catch (InstantiationException ex) {
            ex.printStackTrace();
        }
        try {
            con = DriverManager.getConnection(url, user, password);
            System.out.println("get Connection Object");
        } catch (SQLException ex) {
            ex.printStackTrace();
        }

        stmt = con.createStatement();
        System.out.println("get Statment Object");
        rs = stmt.executeQuery("select EMPNO from EMPLOYEE");
        System.out.println("get ResultSet Object");
        while(rs.next()){
         System.out.println(rs.getString(1));
        }
     rs.close();
     stmt.close();
     con.close();
}
}

Tistory 태그: DB2 JDBC,db2 jdbc