This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
The URL looks wrong, compare it to one of ours, url = jdbc racle:thin:@ibms1:xxxx:dev3 where @ibms1 is the host server xxxx is the port number dev3 is the service name or sid We do not include username and password since that is validated elsewhere but the form would be url - user - password. Hope this helps
[This message has been edited by Cindy Glass (edited May 09, 2001).]
I'd also try a couple of extra catch statements. One around the Class.forName and one around the getConnection. This way you'll see if the problem is occuring because the driver is not loading properly (i.e. the Oracle dirvers are not in the class path or similar) or if the connection string is invalid. I suspect that it's the former. Sean
Joined: Dec 10, 2000
Bill I tried the url that you have specified but now also I am getting this error while running it. modified connection(con)where assetdb is the host server,1521 port id & assetdb is SID. con = DriverManager.getConnection("jdbc racle:thin:@assetdb:1521:assetdb","asset","tiger"); Now I am getting this error SQL Exception caughtjava.sql.SQLException: assetdb
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com