Oracle JDBC Connection Strings¶
The Oracle JDBC Thin driver supports distinct connection string formats depending on whether the database target is identified by a SID (System Identifier) or a Service Name^[600-developer-database-oracle-oracle-record.md].
Syntax Formats¶
When configuring the connection URL, the separator following the port number determines the identifier type:
- SID Format: Use a colon (
:) after the port number^[600-developer-database-oracle-oracle-record.md].- Example:
jdbc:oracle:thin:@DB.PF2DEV1-OOB.COM:1521:sid
- Example:
- Service Name Format: Use a forward slash (
/) after the port number^[600-developer-database-oracle-oracle-record.md].- Example:
jdbc:oracle:thin:@DB.PF2DEV1-OOB.COM:1521/serviceName
- Example:
Related Concepts¶
- [[Oracle Database]]
- [[JDBC]]
Sources¶
^[600-developer-database-oracle-oracle-record.md]