Connection to oracle using jdbc 1

[somdat]

Hi, I am trying to connect to oracle database server from java using thin driver of Oracle via jdbc.I hv got jdk1.3.1_06 installed in my m/c and client version of oracle(Oracle 8.0.3.0.2).Since classes12.zip was not installed in my m/c i created a directory jdbc under oracle and installed the classes12.zip file there. I also changed the classpath variable in my m/c(Windows 2000 Server ) to reflect the presence classpath variable.but in spite of all that whenever I try to compile my java file it gives following error.

D:\JAVA_SOM\myConnection1.java:31: cannot resolve symbol
symbol : class OracleDriver
location: package driver
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
and this is the code that i wrote
--------------------------------------------------------

import java.sql.*;
import java.util.*;
import java.io.*;

public class myConnection1
{



public static void main(String args[])

{
Statement st;
Connection con;
ResultSet rs;



try
{

DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
System.out.println("before"
con = DriverManager.getConnection("jdbcracle:thin204.170.59.3:1521:dossier","userwtc","dossier&quot ; st=con.createStatement();
System.out.println("Connected"


}
catch(Exception e){
System.out.println(e);
}


}





}
--------------------------------------------------

pls can somebody help me here

 

[ksolos]

does your classpath include the actual classes12.zip file and not just the directory that it's in?

good:
classpath = '.....;...;C:/Oracle/jdbc/classes12.zip'

bad:
classpath = '.....;...;C:/Oracle/jdbc'

if this doesn't address your question...provide more info such as your path settings etc

Also...for a little redundancy..place this line of code before your DriverManager

Class.forName("oracle.jdbc.driver.OracleDriver&quot.newInstance();

ksolos