오늘도 행복하다.

• 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

  접기

• 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

  접기

• jdbc:derby:testDerbyDB;create=true
• create=true 옵션은 데이터베이스가 없는 경우 생성하도록 한다.
• 데이터베이스명만 있는 경우 사용자 디렉토리에 데이터베이스가 생긴다.(이 경우 C:\Documents and Settings\USER\testDerbyDB)
• /testDerbyDB 이면 C드라이브에 생성됨, 절대경로로 지정할 수도 있음.
  
• org.apache.derby.jdbc.EmbeddedDriver
• derby.jar: contains the Derby engine and the Derby Embedded JDBC driver

• jdbc:derby://localhost:1527/testDerbyDB;create=true
• DERBY/bin/startNetworkServer 로 서버를 시작할 수 있다.
• 데이터베이스는 서버를 실행시킨 디렉토리에 생성된다. Eclipse에서 Ant로 실행시키면 프로젝트 루트에 생긴다.
  
• org.apache.derby.jdbc.ClientDriver
• 클라이언트 : derbyclient.jar
• 서버 : derbyrun.jar, derbynet.jar, derby.jar

• Oracle Database 11g Release 1 (11.1.0.7.0) JDBC Drivers
  ojdbc5.jar (1,890,499 bytes) - Classes for use with JDK 1.5.
  ojdbc6.jar (1,988,051 bytes) - Classes for use with JDK 1.6.
• Oracle Database 11g Release 1 (11.1.0.6.0) JDBC Drivers
  ojdbc5.jar (1,879,860 bytes)
  ojdbc6.jar (1,977,267 bytes)
• Oracle Database 10g Release 2 (10.2.0.4) JDBC Drivers
  classes12.jar (1,609,607 bytes) - for use with JDK 1.2 and JDK 1.3
  ojdbc14.jar (1,555,682 bytes) - classes for use with JDK 1.4 and 1.5
• Oracle Database 10g Release 2 (10.2.0.3) JDBC Drivers
  classes12.jar (1,600,090 bytes) - for use with JDK 1.2 and JDK 1.3
  ojdbc14.jar (1,545,954 bytes) - classes for use with JDK 1.4 and 1.5
• Oracle Database 10g Release 2 (10.2.0.2) JDBC Drivers
  classes12.jar (1,594,191 bytes) - for use with JDK 1.2 and JDK 1.3
  ojdbc14.jar (1,540,457 bytes) - classes for use with JDK 1.4 and 1.5
• Oracle Database 10g Release 2 (10.2.0.1.0) JDBC Drivers
  classes12.jar (1,590,491 bytes) - for use with JDK 1.2 and JDK 1.3
  ojdbc14.jar (1,536,979 bytes) - classes for use with JDK 1.4 and 1.5
• Oracle Database 10g 10.1.0.5 JDBC Drivers
  classes12.jar (1,442,469 bytes) - for use with JDK 1.2 and JDK 1.3
  ojdbc14.jar (1,378,346 bytes) - classes for use with JDK 1.4
• Oracle Database 10g 10.1.0.2 JDBC Drivers
  classes12.jar (1,417,089 bytes) - for use with JDK 1.2 and JDK 1.3
  ojdbc14.jar (1,352,918 bytes) - classes for use with JDK 1.4
• Oracle9i 9.2.0.8 JDBC Drivers
  ojdbc14.jar - JDBC classes (1,212,964 bytes) - For use with JDK 1.4
  classes12.jar - JDBC classes (1,234,433bytes) - For use with JDK 1.2 and JDK 1.3
  classes111.jar - JDBC classes (1,063,074 bytes) - For use with JDK 1.1
• Oracle9i 9.2.0.5 JDBC Drivers
  ojdbc14.jar - JDBC classes (1,200,046 bytes) - For use with JDK 1.4
  classes12.zip - JDBC classes (1,232,604 bytes) - For use with JDK 1.2 and JDK 1.3
  classes111.zip - JDBC classes (1,063,479bytes) - For use with JDK 1.1
• Oracle9i 9.2.0.4 JDBC Drivers
  ojdbc14.jar - JDBC classes (1,187,584 bytes) - For use with JDK 1.4
  classes12.zip - JDBC classes (1,219,950 bytes) - For use with JDK 1.2 and JDK 1.3
  classes111.zip - JDBC classes (1,052,833 bytes) - For use with JDK 1.1
• Oracle9i 9.2.0.3 JDBC Drivers
  ojdbc14.jar - JDBC classes (1,181,679 bytes) - For use with JDK 1.4
  classes12.zip - JDBC classes (1,213,897 bytes) - For use with JDK 1.2 and JDK 1.3
  classes111.zip - JDBC classes (1,048,261 bytes) - For use with JDK 1.1
• Oracle9i 9.2.0.1 JDBC Drivers
  ojdbc14.jar - JDBC classes ( 1,174,976 bytes) - For use with JDK 1.4
  classes12.zip - JDBC classes ( 1,207,068 bytes) - For use with JDK 1.2 and JDK 1.3
  classes111.zip - JDBC classes ( 1,043,528 Bytes) - For use with JDK 1.1
• Oracle9i 9.0.1.4 JDBC Drivers
  classes12.zip - JDBC classes (1,143,559 bytes) - For use with JDK 1.2 and JDK 1.3
  classes111.zip - JDBC classes (988,625 bytes) - For use with JDK 1.1
• Oracle9i 9.0.1 JDBC Drivers
  classes12.zip - JDBC classes( 1,081 kb) - For use with JDK 1.2 and JDK 1.3
  classes111.zip - JDBC classes ( 936 kB) - For use with JDK 1.1
• Oracle8i 8.1.7.1JDBC Drivers
  classes12.zip - JDBC classes ( 1,892 kB) - For use with JDK 1.2
  classes111.zip - JDBC classes ( 1,741 kB)

• 2008 지원 드라이버 : http://msdn.microsoft.com/ko-kr/library/dd903047%28SQL.10%29.aspx
• sqljdbc4.jar

• http://www.microsoft.com/downloads/results.aspx?pocId=&freetext=JDBC&DisplayLang=ko
• com.microsoft.sqlserver.jdbc.SQLServerDriver
• jdbc:sqlserver://ADDRESS:1433;databaseName=DB_NAME;
• sqljdbc.jar(1.2.2828.100 - 570KB, 1.1.1501.101 - 248KB, 1.0.809.102 - 227KB)
• 참고 http://msdn.microsoft.com/ko-kr/library/bb418445(SQL.10).aspx

• 이 드라이버는 아마도 SQL Server 2000 드라이버.
  
• com.microsoft.jdbc.sqlserver.SQLServerDriver
• jdbc:microsoft:sqlserver://ADDRESS:1433
• mssqlserver.jar 와 com/microsoft/jdbc/base/BaseDriver 을 필요로 한다.

• http://jtds.sourceforge.net
• net.sourceforge.jtds.jdbc.Driver
• jdbc:jtds:sqlserver://ADDRESS:1433/DB_NAME
• jtds-1.2.2.jar
• TEXT 컬럼 처리 가능
  

=-=> ms 드라이버는 text 컬럼처리 안되는게 있을거야.

- Windows 통합인증을 사용할 때는 sqljdbc_auth.dll이 필요 ==???

• MySQL Connectors
• com.mysql.jdbc.Driver
• jdbc:mysql://ADDRESS/DB_NAME?Unicode=true&characterEncoding=EUC_KR
• mysql-connector-java-5.1.0-bin.jar(554KB)