반응형
각종 db별 jdbc url 및 jdbc driverClass 정리된 내용을 공유합니다.
cubrid 큐브리드
cubrid jdbc url
cubrid jdbc driverClass
|
cubrid.jdbc.driver.CUBRIDDriver
jdbc:cubrid:IP:33000:DBNAME:::
|
Mysql
Mysql jdbc url
Mysql jdbc driverClass
|
com.mysql.jdbc.Driver
jdbc:mysql://IP:3306/DBNAME?characterEncoding=utf8&autoReconnect=true
|
mysql-connector-java 버전 6.xx
|
com.mysql.cj.jdbc.Driver
jdbc:mysql://IP:3306/DBNAME?characterEncoding=utf8&autoReconnect=true&serverTimezone=KST
|
Mssql
Mssql jdbc url
Mssql jdbc driverClass
|
com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbc:sqlserver://IP:1433;DatabaseName=DBNAME
|
Oracle 오라클
Oracle jdbc url
Oracle jdbc driverClass
|
oracle.jdbc.driver.OracleDriver
jdbc:oracle:thin:@IP:1521:DBNAME
|
Maria 마리아
Maria jdbc url
Maria jdbc driverClass
|
org.mariadb.jdbc.Driver
jdbc:mariadb://IP:3306/DBNAME?characterEncoding=utf8&autoReconnect=true
|
DB2
DB2 jdbc url
DB2 jdbc driverClass
|
com.ibm.db2.jcc.DB2Driver
jdbc:db2://IP:50000/DBNAME
|
Tibero
Tibero jdbc url
Tibero driverClass
|
com.tmax.tibero.jdbc.TbDriver
jdbc:tibero:thin:@IP:8629:DBNAME
|
PostgreSQL
Postgre jdbc url
Postgre driverClass
|
org.postgresql.Driver
jdbc:postgresql://IP:5432/DBNAME
|
반응형
'Database' 카테고리의 다른 글
| oracle merge -> mysql replace or on duplicate key update (0) | 2018.07.25 |
|---|---|
| 오라클 임시 테이블 (0) | 2018.07.17 |
| 오라클 전체 테이블의 데이터 건수 조회하는 쿼리 만들기. (0) | 2018.06.28 |
| 마리아 db 시작 (0) | 2018.03.12 |
| mysql create database (0) | 2018.03.09 |
| db2 character set 확인 (0) | 2018.02.13 |
| db2 - SQL1025N The database manager was not stopped because databases are still active. (0) | 2018.02.13 |
| db2 drop database (0) | 2018.02.13 |