*
The moose likes JDBC and the fly likes Connecting Oracle 8x Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Connecting Oracle 8x" Watch "Connecting Oracle 8x" New topic
Author

Connecting Oracle 8x

Uday Kumar
Greenhorn

Joined: Jan 22, 2002
Posts: 24
I need some help in connecting to my Oracle database. This db server is on a machine in my network and my java class runs on my laptop(WinNT) using JDK1.3 and latest JDBC drivers.
I have set my classpath to include classes111.zip and classes12.zip and imported oracle.jdbc.driver.* in my class code. The code compiles fine but when executed thru DOS prompt I get the following error:-

Exception in thread "main" java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at Test.main(Test.java:15)
<code snippet>
String url = "jdbc.oracle.thin:@1.1.1.11:1521:aaaa";
String driver = "oracle.jdbc.driver.OracleDriver";
Class.forName(driver);
Connection conn= DriverManager.getConnection(url, "uid", "password");
</code snippet>

Any help would be highly appreciated.
Uday
PS: Keep in mind, I am brand new to Java.
[ March 28, 2002: Message edited by: Uday Kumar ]
Julio Carlos
Greenhorn

Joined: Mar 26, 2002
Posts: 9
Hi, i have this code to connect to the Oracle 8.1.7 Database, i'm using JDK 1.2.2, and in my classpath i only have the classes12.zip, this is my code

This work fine, i hope that this help you
JcSO
[ Edited by Dave to format code and fix ]
[ April 01, 2002: Message edited by: David O'Meara ]
Uday Kumar
Greenhorn

Joined: Jan 22, 2002
Posts: 24
Thanks for your help Julio Carlos :-). Since, I was out of town, I could not reply sooner.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Connecting Oracle 8x
 
Similar Threads
WAMP/Java/MysqlConnector Issue
Unknown Source error when trying to use jdbc to connect to Oracle 8.1.6.0.0 database
somebody come in and help me check this error
WLS7 connect Oralce9.2 ok;Jb8 import schema from database wrong
applet can't start error!!