develog

[jdbc] jdbc, driver, connection url 본문

DB/DB common

[jdbc] jdbc, driver, connection url

냐옴 2016. 6. 2. 14:10

 Oracle

 Driver

 oracle.jdbc.driver.OracleDriver

 conn url

 jdbc:oracle:thin:@{HOST}:{PORT}:{DB_SCHEMA}
 ※ default port : 1521

 MS-SQL

 Driver

 com.microsoft.sqlserver.jdbc.SQLServerDriver

 conn url

 jdbc:sqlserver://{HOST}:{PORT}; databasename={DB_SCHEMA};
 ※ default port : 1433

 MySQL

 Driver

 com.mysql.jdbc.Driver

 conn url

 jdbc:mysql://{HOST}:{PORT}/{DB_SCHEMA}
 ※ default port : 3306


'DB > DB common' 카테고리의 다른 글

[DB] DB version  (0) 2017.04.25
[DB] DDL, DML, DCL  (0) 2017.03.27
ROWNUM, TOP, LIMIT  (0) 2015.10.22
Configuring Connection Pooling in Tomcat  (0) 2013.03.07
rownum, top, limit  (0) 2013.03.06
Comments