각각의 DBMS 마다 JDBC Connection URL 형식이 달라서 정리를 하였습니다.



Host : localhost

Port Number : 8080

Database Name : connectionTest


- Oracle

ClassName : oracle.jdbc.driver.OracleDriver

URL : jdbc:oracle:thin:@localhost:8080:connectionTest


- MySQL

ClassName : com.mysql.jdbc.Driver

URL : jdbc:mysql://localhost:8080/connectionTest


- SQL_Server (2005, 2008, 2012)

ClassName : com.microsoft.sqlserver.jdbc.SQLServerDriver

URL : jdbc:sqlserver:localhost:8080;databaseName=connectionTest


- SQL_Server 2000

ClassName : com.microsoft.jdbc.sqlserver.SQLServerDriver

URL : jdbc:microsoft.sqlserver:localhost:8080;databaseName=connectionTest


- Tibero

ClassName : com.tmax.tibero.jdbc.TbDriver

URL : jdbc:tibero:thin:@localhost:8080:connectionTest


- Sybase

ClassName : com.sybase.jdbc2.jdbc.SybDriver

URL : jdbc:Sybase:Tds:localhost:8080/connectionTest

'JAVA Platform > JAVA' 카테고리의 다른 글

[JAVA] - File 실행하기  (0) 2015.03.22
[JAVA] - JNDI Database Connection  (0) 2015.03.19
[JAVA] - Properties File 읽기  (0) 2015.01.25
[JAVA] - Swing JScrollPane 스크롤  (0) 2015.01.21
[JAVA] - File 최종 수정일 알기  (0) 2014.11.15
블로그 이미지

행복그리고..

,