Oracle Database Discussions

Hello everyone,

i want to connect oracle 11g with java.
i had installed ojdbc6.jar.

my machine is :
linux 64 bit ,redhat.


And my code is:

import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import oracle.jdbc.pool.OracleDataSource;

public class show {


public static final String DBURL = "jdbc:oracle:thin:@localhost:1521:SA";
public static final String DBUSER = "myuser";
public static final String DBPASS = "xyz";


public static void main(String[] args) throws SQLException {

DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection con = DriverManager.getConnection(DBURL, DBUSER, DBPASS);

Statement statement = con.createStatement();

ResultSet rs = statement.executeQuery("select count(*) from tablename where rownum<=2");


if (rs.next()) {
String data = rs.getDate(1); // get first column returned
System.out.println("data : "+data);

}
rs.close();

statement.close();
con.close();
}

}





when i complied i am getting following error


show.java:19: package oracle.jdbc.driver does not exist
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());


please can any one tell me where i am going wrong.

thank you.