This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes Invalid URL, and I'm not sure why. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Invalid URL, and I Watch "Invalid URL, and I New topic
Author

Invalid URL, and I'm not sure why.

Mike Curwen
Ranch Hand

Joined: Feb 20, 2001
Posts: 3695

Hello,
I'm getting an error I haven't run across before, and I'm a bit stumped. The drivers and URL I'm using work in another 'part' of my application, but they don't seem to work in this newer part. If you think it's relevant, the application is a WAR application running under iPlanet6sp3. Some helper classes files (for Data Access) are able to use the following information:
Here is some code that attempts to use these settings, in a new iPlanet Startup Class.
And finally, here is what I get:
Any help is much appreciated. Sorry for the long code post.
[This message has been edited by Mike Curwen (edited October 02, 2001).]
shilpa kulkarni
Ranch Hand

Joined: Jun 07, 2000
Posts: 87
Originally posted by Mike Curwen:
[B]

[/B]

Could it be the space between the words jdbc and oracle??
try - dbUrl="jdbc racle:thin:@boxName:1521:dbName";
shilpa kulkarni
Ranch Hand

Joined: Jun 07, 2000
Posts: 87
Sorry for the smiley, i meant
dbUrl= "jdbcracle:thin:@boxName:1521:dbName";
Mike Curwen
Ranch Hand

Joined: Feb 20, 2001
Posts: 3695

Sorry about that shilpa,
I double checked my source, and there are no 'invisible' characters in my original string. I think when I copy and pasted into JavaRanch, and I initially had smilies turned on, and then turned them off, it added those spaces.

There are no spaces in my URL.
Mike Curwen
Ranch Hand

Joined: Feb 20, 2001
Posts: 3695

I have solved the problem with the help of a colleague.

We discovered that 'boxName' could not be resolved, and when we replaced that with the actual IP address of the server, everything worked fine.

Neither of us is quite sure why this fails, but because I'm deploying this application to my localhost version of iAS on my NT box, and the app I know works is deployed to a box elsewhere that runs Solaris (which is outside the firewall), perhaps this has something to do with it.

Now all I need to do is fix up my SQL so I don't get any ORA: errors.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Invalid URL, and I'm not sure why.
 
Similar Threads
java.sql.SQLException: No suitable driver in DB2 7.01
JDBC - How to find Oracle Driver Version
what is super?
Creating user in Oracle through JDBC
Connection to a db