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
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.
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.