Oracle database connection

[anu rani]

I want in detail how to connect to oracle databse.

Regarding classpath,what to install.

I have j2sdk1.4.2,oracle8i,tomcat6.0

Class.forName("Oracle.jdbc.driver.OracleDriver").newInstance();
con = DriverManager.getConnection("jdbcracle:thin:@192.168.10.5:1521:bits", "buildnova", "nova");
error:
java.lang.ClassNotFoundException: Oracle.jdbc.driver.OracleDriver
please let me know how to resolve this error

[Scott Selikoff]

Put the Oracle JDBC in the classpath of your application. JDBC drivers do not come with java.

[arun nohwar]

You need the driver. The driver is something that takes your makes your jdbc java calls, understandable to database.
You will find the oracle driver in folder "jdbc" of oracle isntallation directory.
The name of driver is "ojdbc14.jar".
Put this driver(jar file), in your classpath, and the above application will run smoothly.

[Paul Sturrock]

The name of driver is "ojdbc14.jar"

For Oracle 8i it is classes12.zip.

[Avi Abrami]

Paul,
For your information, the java/JDBC/database interoperability information is available in the Oracle JDBC FAQ:

http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.html

Good Luck,
Avi.

[Paul Sturrock]

Originally posted by Avi Abrami:
Paul,
For your information, the java/JDBC/database interoperability information is available in the Oracle JDBC FAQ:

http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.html

Good Luck,
Avi.

Thank you Avi, I'm very aware of that. My intention was to correct agun nohwar's post, Oracle 8i does not ship with ojdbc14.jar, it ships with classes12.jar, so anu rani will not be able to find that jar file.

They could (and probably should) of course download a much more recent driver directly from Oracle.