OraFAQ Forum: JDeveloper, Java & XML » ClassNotFoundException: oracle.jdbc.driver.OracleDriver

Home » Developer & Programmer » JDeveloper, Java & XML » ClassNotFoundException: oracle.jdbc.driver.OracleDriver

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ClassNotFoundException: oracle.jdbc.driver.OracleDriver [message #92061]

Mon, 23 February 2004 10:13

JavaNewBee
Messages: 1
Registered: February 2004

Junior Member

�

Hi All, I was wondering if you could possibly help me out with my dilemma.� I have been trying to connect to an Oracle database using java code, but am having problems, I have searched the Internet high and low for a remedy, but cannot seem to get my connection working.�

Also all the literature regarding my problem as stated below, seems to mention JDK and not SDK, is this maybe a problem that I have overlooked?� Do I need JDK and not SDK?

Problem:� The problem seems to be that for some reason the Java compiler cannot find my Oracle driver.� The error code I am getting is the following:

�

ClassNotFoundException: oracle.jdbc.driver.OracleDriver

�

I have tried many options to rectify this error.� I have downloaded the classes12.zip from the Oracle website and set the classpath to lead to the classes12.zip files.� I have renamed the classes12.zip files to classes12.jar as suggested on the web.� I have put the classes12.jar files into jrelibext subdirectories as also suggested on the web.� I have unzipped the classes12.jar files.

�

I have downloaded the ojdbc14_g.jar files and set the classpath to lead to these files.

�

The version of Java I am using is sdk1.4.2_03

The OS I am using is Windows XP Professional

The Oralce DB is 9.2.0.1�

�

I am compiling the Java code using command prompt.

javac JDBCTest.java (This compiles without generating message)

java JDBCTest (This generates the error as stated above)

�

My most recent attempt of setting the classpath to find the Oracle driver is displayed below.� The C:j2sdk1.4.2_03bin;C:j2sdk1.4.2_03jrelibextclasses12.jaroraclejdbcOracleDriver.class; is the path I set to try and access the OracleDriver.class

�

This is the code I using to connect to the database.

import java.sql.*;

import java.io.*;

//import oracle.jdbc.driver.*;

public class JDBCTest

{

�� public static void main(String args[[]]) throws SQLException, IOException

�� {

�

�

�� Connection conn = null;

�� try

�� {

��

�� Class.forName("oracle.jdbc.driver.OracleDriver");

�� //DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());

��

�

�� conn = DriverManager.getConnection(

�� "jdbc:oracle:thin:@localhost:1521:orcl",

�� "scott",

�� "tiger");

�

�� Statement stmt = conn.createStatement();

�� ResultSet rs = stmt.executeQuery("SELECT * FROM TestStaff");

�

�� //Print start of table and column headers

�� System.out.println("
");

�� System.out.println("
- ID - - NAME -
");

�

�� //Loop through results of query.

�� while(rs.next())

�� {

�� System.out.println("
");

�� //out.println(" - " + rs.getString("EmpID") + " - ");

�� System.out.println(" - " + rs.getString("Name") + " - ");

�� System.out.println("
");

�� }

�

�� System.out.println("
");

�� }

�� catch(SQLException e)

�� {

�� System.out.println("SQLException: " + e.getMessage() + "
");

�� while((e = e.getNextException()) != null)

�� System.out.println(e.getMessage() + "
");

�� }

�� catch(ClassNotFoundException e)

�� {

�� System.out.println("ClassNotFoundException: " + e.getMessage() + "
");

�� }

�� finally

�� {

�� //Clean up resources, close the connection.

�� if(conn != null)

�� {

�� try

�� {

�� conn.close();

�� }

�� catch (Exception ignored) {}

�� }

�� }

� }

}

�

�

�

JavaNewbee

�

�

�

�

�

�