[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

Sample program
import java.sql.*;
Connection con;
Statement stmt;
ResultSet rs;
Class.forName(“com.ibm.db2.jcc.DB2Driver”);
con = DriverManager.getConnection(“db2:jdbc://server1:50000/sample”);
stmt = con.createStatement();
rs = stmt.executeQuery(“select EMPNO from EMPLOYEE”);
while (rs.next()) {
s = rs.getString(1);
}
rs.close();
stmt.close();
con.close();

DB2 and JAVA Developer Domain

댓글

이 블로그의 인기 게시물

db2 user 생성 및 권한 설정

AIX tape 백업

db2 테이블스페이스 확인 및 확장