Oracle JDBC URL

Owned by 정광섭
Last updated: 2020-Oct-15
1 min read

Oracle Thin Driver 기준

Maven

Oracle Database 11g Release 2 (11.2.0.4) JDBC Drivers

<dependency>
    <groupId>com.oracle</groupId>
    <artifactId>ojdbc6</artifactId>
    <version>11.2.0.4</version>
</dependency>


Oracle Database 12.2.0.1 JDBC Driver & UCP Downloads

<dependency>
    <groupId>com.oracle</groupId>
    <artifactId>ojdbc8</artifactId>
    <version>12.2.0.1</version>
</dependency>

JDBC Driver class

oracle.jdbc.driver.OracleDriver




JDBC URL format

New

jdbc:oracle:thin:@//[HOST][:PORT]/SERVICE

Old

jdbc:oracle:thin:@[HOST][:PORT]:SID

Ex

jdbc:oracle:thin:@//localhost:1521/orcl


Ref