?
Solved

Invalid Oracle URL specified connecting to 8.1.7

Posted on 2003-11-26
11
Medium Priority
?
1,171 Views
Last Modified: 2012-06-22
I get an Invalid Oracle URL specified error connecting to an Oracle 8.1.7 database. I am Java 1.4.2 and the Oracle Database driver is 'j2sdk1.4.2'. I got on Oracle OTN to attempt to get another driver and the latest I find is for Java 1.2(class12.zip). Does this mean there is no driver available for Oracle 8.1.7 and Java 1.4.2? Bellow is by Oracle error.
----------------------------------------------------------

Connect String:jdbc:oracle:thin@1xx.xx.xxx.xxx:port:sid
Error Connecting to Database:xxxx
Connect String:jdbc:oracle:thin@999.99.999.999:5555:2222
SqlException:Invalid Oracle URL specified
SqlState    :null
Vendor Error:17067
------------------------------------------------
java.sql.SQLException: Invalid Oracle URL specified
0
Comment
Question by:rayskelton
[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
  • 5
  • 4
11 Comments
 
LVL 86

Expert Comment

by:CEHJ
ID: 9826563
You must use a valid IP and port number
0
 

Author Comment

by:rayskelton
ID: 9826598
I have a valid Id and Port. I blanked them out to prevent from public view.
0
 
LVL 86

Expert Comment

by:CEHJ
ID: 9826827
I don't think you need to blank the port ;-) Please post again with it looking at bit more realistic
0
Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

 
LVL 86

Expert Comment

by:CEHJ
ID: 9826908
You should be able to use the machine name too. Let's say the Oracle server machine is called 'ray' and you can do

ping ray

Then you should be able to use

jdbc:oracle:thin@ray:nnnn

where 'nnnn' is the right port number
0
 

Author Comment

by:rayskelton
ID: 9826997
Below is the exception thrown. I have 2 drivers I have tried this with.-- classes12_g.zip and ojdbc14.jar --
My classpath is:/i2k/rxs/java/j2sdk1.4.2/lib:/i2k/rxs/java/j2sdk1.4.2/drivers/classes12_g.zip:.
------------------------------------------------------------

Connect String:jdbc:oracle:thin@172.25.248.215:1531:i2d2
Error Connecting to Database:i2d2
Connect String:jdbc:oracle:thin@172.25.248.215:1531:i2d2
SqlException:Invalid Oracle URL specified
SqlState    :null
Vendor Error:17067
------------------------------------------------
java.sql.SQLException: Invalid Oracle URL specified
0
 
LVL 86

Expert Comment

by:CEHJ
ID: 9827433
Please post your connect code
0
 

Author Comment

by:rayskelton
ID: 9827516
public int getDbConnect()
{
   // set class members with configuration
   // information read from the properties file
   host = System.getProperty("host");
   userName = System.getProperty("user");
   url = System.getProperty("url");
   passWord = System.getProperty("password");
   port = System.getProperty("port");
   sid = System.getProperty("sid");
   databaseName = System.getProperty("databaseName");
   maxSelectRows = System.getProperty("maxSelectRows");

   // Determine which system we are on
   // the MySql driver is for Linux *
   // Oracle this is for Oracle Driver
   String connectString = null;  
   if(url.compareTo("jdbc:mysql//") == 0)
     {// MySql Database
     connectString = url + host + ":"
                                + port + "/" + sid
                                + "?user=" + userName
                                + "&password=" + passWord;
     }
   else
     if(url.compareTo("jdbc:oracle:thin@") == 0)
       {// Oracle Database
       connectString =  url + host + ":" + port + ":" + sid ;
       }
   else
     System.out.println("Unsupported URL for this application:" + url);                                

   try
     {
     System.out.println("Connecting to Database:" + databaseName
                         + sid + " at port:"+ port);
     System.out.println("Connect String:" + connectString);

     connection = DriverManager.getConnection(connectString);
     System.out.println("Connection established for:" + databaseName);
     connection.setAutoCommit(false);
     }

   catch(SQLException ex)
     {
      System.out.println("Error Connecting to Database:" + sid);
      System.out.println("Connect String:" + connectString);

      System.out.println("SqlException:" + ex.getMessage());
      System.out.println("SqlState    :" + ex.getSQLState());
      System.out.println("Vendor Error:" + ex.getErrorCode());
     
      System.out.println("------------------------------------------------");
      sqlEx.printStackTrace();

     }
     
return(0);
}
0
 

Author Comment

by:rayskelton
ID: 9828142
I resolved this issue by adding a ':' between the thin and @.  
jdbc:oracle:thin:@")

Thanks for youe help
0
 
LVL 86

Expert Comment

by:CEHJ
ID: 9828150
OK :-)
0
 
LVL 2

Accepted Solution

by:
Lunchy earned 0 total points
ID: 10197170
PAQed, with points refunded (250)

Lunchy
Friendly Neighbourhood Community Support Admin
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

This was posted to the Netbeans forum a Feb, 2010 and I also sent it to Verisign. Who didn't help much in my struggles to get my application signed. ------------------------- Start The idea here is to target your cell phones with the correct…
Introduction This article is the second of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers the basic installation and configuration of the test automation tools used by…
Viewers will learn about the different types of variables in Java and how to declare them. Decide the type of variable desired: Put the keyword corresponding to the type of variable in front of the variable name: Use the equal sign to assign a v…
Viewers will learn about arithmetic and Boolean expressions in Java and the logical operators used to create Boolean expressions. We will cover the symbols used for arithmetic expressions and define each logical operator and how to use them in Boole…
Suggested Courses
Course of the Month15 days, 2 hours left to enroll

771 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