sun.jdbc is not available

[Ram Kas]

I am trying to execute a SQL query using JDBC. The code is as follows:

import java.sql.*;
class Jdbc1
{
public static void main(String[] args)
{
try{
Class.forName(sun.jdbc.odbc.JdbcOdbcDriver);
}
catch(ClassNotFoundException cnfe)
{}
try{
Connection con = DriverManager.getConnection("jdbc:odbc:myDataSource");
}
catch(SQLException se)
{}
Statement st = con.createStatement();
ResultSet rs = st.executeQuery("select * from emp");
 
while(rs.hasNext())
{
String empName = rs.getString(1);
String empid = rs.getString(2);
System.out.println(empName+":"+empid);
}
 
}
 

}

I think the code is fine. I get the error saying package sun.jdbc is not available. Can anybody help me with this?

Thanks in advance.

[David O'Meara]

You'll get this if you are not using Sun's compiler, for example if you are using IBM's.

[Ram Kas]

But, I use sun's compiler. Any more inputs?

[Mr. C Lamont Gilbert]

Class.forName(sun.jdbc.odbc.JdbcOdbcDriver);

Shouldn't that be in quotations? Also can we try printing the exceptions instead of ignoring them :shocked:
[ August 07, 2006: Message edited by: Mr. C Lamont Gilbert ]

[Lucky Chawla]

You will the classes12 or classes111.jar and you have to unzip this fie and place it in the java directory,This file is in the oracle's directory. After unzipping it you will find the package you are searching for