DB2 JDBC Driver

- DB2 Express-C(아마 일반적인 경우겠지)

• com.ibm.db2.jcc.DB2Driver
• jdbc:db2://ADDRESS/DB_NAME
• db2jcc.jar (라이센스 jar 도 있어야 한다고는 하는데 이것만 있어도 됨)
• C:\Program Files\ibm\SQLLIB\java\ 에 있음.
  

• DB2 Express-C (in Windows)
  

  driver : com.ibm.db2.jcc.DB2Driver getURL : jdbc:db2://127.0.0.1:50000/DB_NAME
  getDatabaseProductName : DB2/NT
  getDatabaseProductVersion : SQL09070
  getDriverName : IBM DB2 JDBC Universal Driver Architecture
  getDriverVersion : 3.57.82
  getDriverVersion(int) : 3.57
  getJDBCVersion : 3.0
  con : com.ibm.db2.jcc.t4.b@114629
  jar:file:/D:/apps/WEB-INF/lib/db2jcc.jar!/com/ibm/db2/jcc/DB2Driver.class

- DB2 UDB for AS/400

• http://jt400.sourceforge.net/
• com.ibm.as400.access.AS400JDBCDriver
• jdbc:as400://ADDRESS/DB_NAME
• jt400.jar
• DB2_INSTALL/jt400/lib/jt400.jar
• 참고 : Toolbox for Java and JTOpen,  IBM Toolbox for Java 구성

• getURL : jdbc:as400://1.2.3.4/test
  getDatabaseProductName : DB2 UDB for AS/400
  getDatabaseProductVersion : 05.03.0000 V5R3m0
  getDriverName : AS/400 Toolbox for Java JDBC Driver
  getDriverVersion : 5.0
  getDriverVersion(int) : 5.0
  getJDBCVersion : 3.0
  con : org.apache.commons.dbcp.PoolableConnection@3f1224
  com.ibm.as400.access.AS400JDBCDriver.class : jar:file:/D:/test.war/WEB-INF/lib/jt400.jar!/com/ibm/as400/access/AS400JDBCDriver.class