Meaningless Drivel is fun!*
The moose likes JDBC and the fly likes Connecting to Database without a DSN Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Connecting to Database without a DSN" Watch "Connecting to Database without a DSN" New topic
Author

Connecting to Database without a DSN

Mahua Dutta
Greenhorn

Joined: Sep 21, 2001
Posts: 1
How to connect to the database through a java application running in a client machine without a DSN. I mean can we access to a database in the server like we access through servlets.
I am using the following strings
String url = "jdbc racle:thin:@SERVER's IP ADDRESS:PORT:SERVICE_NAME";
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
con = DriverManager.getConnection(url, "mis", "mis");
But I am getting the following Exception
oracle.jdbc.driver.OracleDriver
I am using same Strings and driver to access the database through servlets and its working properly.
Its very urgent. If any one can help me, Please.
Regards Mahua
[This message has been edited by Mahua Dutta (edited September 22, 2001).]
Terence Doyle
Ranch Hand

Joined: May 30, 2001
Posts: 328
HI,
Try this instead of the ClassforName() technique:
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
its from the Oracle docs.
Hope that helps,
Terry


Raising Flares debut album 'Ignition' out now

http://www.raisingflares.com

Terry Doyle <br />SCPJ 1.4 , SCWCD , SCMAD(Beta)
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Connecting to Database without a DSN