Exception in thread "main" java.lang.ClassNotFoundException: jdbc.odbc.driver.Oracle

[jkjmomadad]

I am using Netbeans 7.1.2. I have been having a terrible time trying to connect to a remote Oracle database. I was given the appropriate url from my professor, and told to install ojdbc.6 from Oracle which I did by adding it to the class path, but I'm still having no luck at all actually getting the data from the database. I can go in manually and connect. I am using the simple code below (from my text) to try to start troubleshooting the issue - see below. Any help that can be given would be super appreciated.

package javaapplication6;

import java.sql.*;

public class JavaApplication6 {
         
         public static void main(String[] args)
                 throws SQLException, ClassNotFoundException {
             Class.forName("jdbc.odbc.driver.OracleDriver");
             System.out.println("Driver loaded");
             
             Connection connection = DriverManager.getConnection
                     ("jdbc:oracle:thin:@XXXXX:port:xxxx","username","password");
             System.out.println("Database connected");
             
             Statement statement = connection.createStatement();
             
             ResultSet resultSet = statement.executeQuery("SELECT * FROM POWER");
             
             while (resultSet.next())
                 System.out.println(resultSet.getString(2));
             
             connection.close();
             
                     
         }
    
}

Exception info is below:

run:
Exception in thread "main" java.lang.ClassNotFoundException: jdbc.odbc.driver.OracleDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java: 202)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.j ava:190)
at java.lang.ClassLoader.loadClass(ClassLoader.java:3 06)
at sun.misc.Launcher$AppClassLoader.loadClass(Launche r.java:301)
at java.lang.ClassLoader.loadClass(ClassLoader.java:2 47)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at javaapplication6.JavaApplication6.main(JavaApplica tion6.java:11)
Java Result: 1
BUILD SUCCESSFUL (total time: 1 second)

[doWhile]

I did by adding it to the class path

The exception says otherwise. How are you adding the database driver to the classpath?

[jkjmomadad]

Perhaps I've done it wrong; I right-clicked the project, selected properties, selected Libraries, selected Compile tab, Add Jar/Folder. I then browsed to the copy of ojdbc6.jar that was provided and added it; I see the odjdbc6 driver there which was given to us to install. I'm new to this so any insight you can give would be helpful.

[Tolls]

You don't need the jar file to compile.
You need it at runtime.
I haven't got Netbeans in front of me, but there should be somewhere to tell it that this jar file is a runtime dependency.

[jkjmomadad]

Many thanks - it's working now.