DB별 JDBC URL, Driver

 각 DATABASE의 Dirver, JDBC URL 입니다.

 

 

MSSQL

com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbc:sqlserver://HOST:PORT;DatabaseName=DBNAME

 

ORACLE

oracle.jdbc.driver.OracleDriver

jdbc:oracle:thin:@//HOST:PORT:SID

jdbc:oracle:thin:@//HOST:PORT/SERVICENAME

 

MYSQL

com.mysql.jdbc.Driver

jdbc:mysql://HOST:PORT/DBNAME

 

DB2

com.ibm.db2.jcc.DB2Driver

jdbc:db2://HOST:PORT/DBNAME

 

POSTGRESQL

org.postgresql.Driver

jdbc:postgresql://HOST/DBNAME

 

AURORA

com.mysql.jdbc.Driver

jdbc:mysql://HOST:PORT/DBNAME

 

MARIADB

org.mariadb.jdbc.Driver

jdbc:mariadb://HOST:PORT/DBNAME

 

- MySQL JDBC 드라이버 사용 시

com.mysql.jdbc.Driver

jdbc:mysql://HOST:PORT/DBNAME

 

CUBRID

cubrid.jdbc.driver.CUBRIDDriver

jdbc:cubrid:HOST:PORT:DBNAME:USERID:PASSWORD:[?<property> [& <property>] ... ]

jdbc:cubrid:HOST:DBNAME:::?charset=UTF-8

 

TIBERO

com.tmax.tibero.jdbc.TbDriver

jdbc:tibero:thin:@HOST:PORT:DBNAME

 

UCANACCESS

net.ucanaccess.jdbc.UcanaccessDriver

jdbc:ucanaccess://HOST