Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1367
  • Last Modified:

//host:port/service_name connection string format

Hello,
I am trying to figure out which version of Oracle (version, meaning not only 9 or 10, but down at least to the minor, e.g. 9.0.2.0), requires the following connection string format:

jdbc:oracle:thin:@//host:port/service_name

and from which versions is the "//" part only optional (so jdbc:oracle:thin:@host:port/service_name is allowed)?

Thanks!
0
PapaparaTudu
Asked:
PapaparaTudu
1 Solution
 
schwertnerCommented:
JDBC URL Format
jdbc:oracle:thin://<host>:<port>/<service><br> jdbc:oracle:thin:<host>:<port>:<SID><br> jdbc:oracle:thin:<TNSName> (from 10.2.0.1.0)

In 9.2 // is optional:
http://download-west.oracle.com/docs/cd/B10501_01/java.920/a96654/basic.htm#1006238

Even in 8i:
http://www.boku.ac.at/oradoc/server/8.1.7/java.817/a83723/sampapp1.htm
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now