jdbc driver question?

[weiliu lili]

i use win2k &oracle 8.1.5.00 enterprise edition.
This is my script:

import java.sql.*;
class Test
{
  public static void main (String args [])
       throws SQLException
  {
    // Load the Oracle JDBC driver
    DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
        Connection conn =
      DriverManager.getConnection ("jdbc:o racle:thin:@localhost:1521:global",
   "scott", "tiger");
   System.out.println("connection");
   conn.close();
   }
 }

This is my error message:
D:\>javac Test.java
Employee.java:10: package oracle.jdbc.driver does not exist
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
This is my path,which is set via control panel->system->system enviorment variable:
h:\Oracle\Ora81\jdbc\lib\classes111.zip;h:\Oracle\Ora81\jdbc\lib\nls_chaset11.zip;h:\Oracle\Ora81\bin;C:\Program Files\Oracle\jre\1.1.7\bin;%SYSTEMROOT%;%SYSTEMROOT%\system32;%SYSTEMROOT%\system32\WBEM;C:\j2sdk1.4.0\bin;
what is wrong with it?

[ April 22, 2002: Message edited by: weiliu lili ]
[ Edited by Dave to format code and fix ]
[ April 22, 2002: Message edited by: David O'Meara ]

[tormod eriksen]

Hi,
by saying path, do you mean classpath?
I don't know the correct Oracle path to set, but the way to set up the classpath, is to set it to the directory containing the oracle catalog (oracle/jdbc/driver/OracleDriver.class) or the packagefile containg the above filestructure.
Hope it helps