Solved

//host:port/service_name connection string format

Posted on 2008-06-26
1
1,347 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 48

Accepted Solution

by:
schwertner earned 500 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines

690 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