Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Oracle database connection

 
anu rani
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
author
Saloon Keeper
Posts: 4020
18
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Put the Oracle JDBC in the classpath of your application. JDBC drivers do not come with java.
 
arun nohwar
Greenhorn
Posts: 16
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

The name of driver is "ojdbc14.jar"

For Oracle 8i it is classes12.zip.
 
Avi Abrami
Ranch Hand
Posts: 1141
1
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic