JDBC URL

1 개요

JDBC URL

DB종류	JDBC URL 형식
DB2	jdbc:db2://호스트:포트/데이터베이스명
MySQL	jdbc:mysql://호스트:포트/데이터베이스명
PostgreSQL	jdbc:postgresql://호스트:포트/데이터베이스명
Oracle (thin)	jdbc:oracle:thin@호스트:포트:데이터베이스명
Oracle (OCI)	jdbc:oracle:oci:@데이터베이스명
MS SQL Server	jdbc:microsoft:sqlserver://호스트:포트;databaseName=데이터베이스명;SelectMethod=셀렉트모드

2 예시

PostgreSQL

• jdbc:postgresql:mydatabase
• jdbc:postgresql://135.79.246.80/mydatabase
• jdbc:postgresql://135.79.246.80:5432/mydatabase

MySQL

• jdbc:mysql://localhost:3306/sakila?profileSQL=true
• jdbc:mysql:loadbalance://localhost:3306,localhost:3310/sakila
• jdbc:mysql:replication://master,slave1,slave2,slave3/test

3 같이 보기

• JDBC
• URL

4 참고

• https://www.ibm.com/support/knowledgecenter/SSEP7J_10.2.0/com.ibm.swg.ba.cognos.vvm_ag_guide.10.2.0.doc/c_ag_samjdcurlform.html
• https://dev.mysql.com/doc/connector-j/5.1/en/connector-j-reference-configuration-properties.html