tha code is given below
import java.sql.*;
class Employee
{
public static void main (String args [])throws SQLException
{
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection conn = DriverManager.getConnection ("jdbc:oracle:oci8:@", "scott", "tiger");
Statement stmt = conn.createStatement ();
ResultSet rset = stmt.executeQuery ("select ENAME from EMP");
while (rset.next ())
System.out.println (rset.getString (1));
rset.close();
stmt.close();
conn.close();
}
}
CLASSPATH set is Read ".;G:\Oracle8i\jdbc\lib\ojdbc14.jar;G:\Oracle8i\jdbc\lib\classes12.zip;C:\Tomcat 5.0\common\lib\servlet-api.jar;E:\workspace\BruceEckal"
and PATH is "%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\system32\WBEM;G:\Oracle8i\bin;D:\Program Files\Oracle\jre\1.1.7\bin;D:\Program Files\MySQL\MySQL Server 5.0\bin;G:\Oracle8i\jdbc\lib\classes12.zip;%JAVA_HOME%\bin"
i am using java1.5 and oracle8i
i have started oracle internal and startup myDb
but it always give error
E:\workspace\faltu>javac Employee.java
Employee.java:12: package oracle.jdbc.driver does not exist
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
^
1 error
Please guide me