[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
DB2 and JAVA Developer Domain
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
댓글
댓글 쓰기