I have download classes12.zip(1.84M),and I extract it into e:\ , Then I got a directory oracle folder,I
found OracleDriver.class is at E:\oracle\jdbc\driverOracleDriver.class . Then I set environment as follows:

F:\>set CLASSPATH=E:\classes12.zip;%CLASSPATH%

Then I compile my class "IdentityDAO.java",like follows:

F:\login>javac IdentityDAO.java
F:\login>java IdentityDAO

I got a error,like follows:
  Exception in thread "main" java.lang.NoClassDefFoundError: IdentityDAO

Then I try it again,like follows:
F:\login>javac -classpath .; IdentityDAO.java
F:\login>java -classpath .;IdentityDAO

But it still raise errors,like follows:
  java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
        at java.net.URLClassLoader$1.run(Unknown Source)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(Unknown Source)
        at java.lang.ClassLoader.loadClass(Unknown Source)
        at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
        at java.lang.ClassLoader.loadClass(Unknown Source)
        at java.lang.ClassLoader.loadClassInternal(Unknown Source)
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Unknown Source)
        at IdentityDAO.main(IdentityDAO.java:16)

Why ?  How to do to correct it???
Any idea will be appreciated!
Thanks!!!
Edward


----- Original Message ----- 
From: Nagaraju Venkata 
To: Professional Java 
Sent: Tuesday, May 28, 2002 12:12 PM
Subject: [pro_java] Re: How to use JDBC to connect to Oracle8i database?


this works when you are using oracle thin dirver 
Hope this will help you.
good luck
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ORCL", text, system);
_Nagaraju




Sign up to watch the FIFA World Cup video highlights from your desk!

http://fifaworldcup.yahoo.com/fc/en --- Change your mail options at http://p2p.wrox.com/manager.asp or to unsubscribe send a blank
email to