Improve company productivity with a Business Account.Sign Up

x
?
Solved

//host:port/service_name connection string format

Posted on 2008-06-26
1
Medium Priority
?
1,379 Views
Last Modified: 2013-12-19
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
Comment
Question by:PapaparaTudu
1 Comment
 
LVL 48

Accepted Solution

by:
schwertner earned 2000 total points
ID: 21881733
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

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This article will show a step by step guide on how to mask column values in Oracle 12c using DBMS_REDACT full redaction option. This option is available on licensed Oracle Enterprise edition as part of Oracle's Advanced Security.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

579 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question