Link to home
Start Free TrialLog in
Avatar of rayskelton
rayskelton

asked on

Invalid Oracle URL specified connecting to 8.1.7

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
Avatar of CEHJ
CEHJ
Flag of United Kingdom of Great Britain and Northern Ireland image

You must use a valid IP and port number
Avatar of rayskelton
rayskelton

ASKER

I have a valid Id and Port. I blanked them out to prevent from public view.
I don't think you need to blank the port ;-) Please post again with it looking at bit more realistic
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
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
Please post your connect code
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);
}
I resolved this issue by adding a ':' between the thin and @.  
jdbc:oracle:thin:@")

Thanks for youe help
OK :-)
ASKER CERTIFIED SOLUTION
Avatar of Lunchy
Lunchy
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial