Oracle Database Discussions

Hi,

I am new to jdbc, database thing. I want to have jdbc connection in my system. I tried after reading some tutorials available in web. But its not working for me. Details are as follows.

I am running Debian Lenny in my system. With Sun-java-6 installed. I also have working Oracle 10 g XE in my laptop.

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Oct 30 10:58:03 2010

Java details are as follows.

java version "1.6.0_20"
Java(TM) SE Runtime Environment (build 1.6.0_20-b02)
Java HotSpot(TM) Server VM (build 16.3-b01, mixed mode)

I downloaded two drivers from Oracle site( I dont know which one to use exactly) ojdbc14.jar and classes12.jar and put in /usr/share/java. Then I executed the following code.

+import java.sql.*;

public class jdbc {

public static void main(String[] args) throws ClassNotFoundException, SQLException
{
Class.forName("oracle.jdbc.OracleDriver");
String url = "jdbc:oracle:thin:@loclahost:1521:xe";
Connection conn =
DriverManager.getConnection(url,"jestin","jj");

conn.setAutoCommit(false);
Statement stmt = conn.createStatement();
ResultSet rset =
stmt.executeQuery("select BANNER from SYS.V_$VERSION");
while (rset.next()) {
System.out.println (rset.getString(1));
}
stmt.close();
System.out.println ("Ok.");
}
}+

*jestinjoy@debian:~/java$ javac jdbc.java
jestinjoy@debian:~/java$ java jdbc
jdbc jdbcoperations
jestinjoy@debian:~/java$ java jdbc*

+Exception in thread "main" java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
at java.lang.ClassLoader.loadClass(ClassLoader.java:248)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at jdbc.main(jdbc.java:7)+

Please help. I couldnt find much help while googling