여러 DB를 연동하면서 JDBC driver 명과 URL형식이 매번 필요해

자주 쓰는 JDBC driver를 정리해둔다

 

- Oracle

   Ddriver [oracle.jdbc.driver.OracleDriver]

   URL [jdbc:oracle:thin:@localhost:1521:DBNAME]

 

- MS-SQL

   Driver [com.microsoft.sqlserver.jdbc.SQLServerDriver]

   URL [jdbc:sqlserver://localhost:1433;DatabaseName=DBNAME]

 

- MySQL

   Driver [com.mysql.jdbc.Driver]

   URL [jdbc:mysql://localhost:3306/DBNAME]

 

- MariaDB

Driver [org.mariadb.jdbc.Driver]

URL [jdbc:mariadb://localhost:3306/DBNAME]

+ Recent posts