반응형

DB2 타입별 URL 및 Driver Class 입니다.


IBM DB2 Universal Driver Type 4 


DRIVER CLASS: com.ibm.db2.jcc.DB2Driver 

JDBC URL FORMAT: jdbc:db2://<host>[:<port>]/<database_name> 

JDBC URL Examples: jdbc:db2://127.0.0.1:50000/SAMPLE 



IBM DB2 Universal Driver Type 2 


DRIVER CLASS: com.ibm.db2.jcc.DB2Driver 

JDBC URL FORMAT: jdbc:db2:<database_name> 

JDBC URL Examples:  jdbc:db2:sample 



App JDBC Driver 


DRIVER CLASS: COM.ibm.db2.jdbc.app.DB2Driver 

JDBC URL FORMAT: jdbc:db2:<database_name> 

JDBC URL Examples: jdbc:db2:test 



Net JDBC Driver 


DRIVER CLASS: COM.ibm.db2.jdbc.net.DB2Driver 

JDBC URL FORMAT: jdbc:db2://<host>:<port>/<database_name> 

JDBC URL Examples:  

jdbc:db2://neptune.acme.com:6789/test 

jdbc:db2://127.0.0.1:6789/test 

반응형

'Database' 카테고리의 다른 글

DB2 오류 메시지  (0) 2018.01.07
DB2 SQLSTATE  (0) 2018.01.07
DB2 SQLCODE  (0) 2018.01.07
db2 create sequence  (0) 2018.01.01
db2 from dual  (0) 2017.12.31
db2 jdbc download  (0) 2017.12.31
db2 버전 확인 쿼리  (0) 2017.12.31
db2 설치 centos6.7 삽질기  (0) 2017.12.28

+ Recent posts