File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes jdbc with oracle database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "jdbc with oracle database" Watch "jdbc with oracle database" New topic
Author

jdbc with oracle database

Michelle Lee
Ranch Hand

Joined: Jan 23, 2002
Posts: 42
I tried to use jdbc in my servlet without luck.
I installed oracle 8i
and set my classpath to c:\Oracle\Ora81\jdbc\lib;c:\Oracle\Ora81\jdbc\lib\classes21.zip;
My programm I tested successed when using access database and odbc diver.
when I used used driver: oracle.jdbc.driver.OracleDriver
with url: jdbc racle:thin:@homeking:1521 ra8",
"scott","tiger";(homeking is my machine's name);
the program compiled well, but gave exception:
Exception! java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver at ... when running.
Any help very appreciated!


Michelle
Col Bell
Greenhorn

Joined: Mar 21, 2002
Posts: 12
The jar file containing the Oracle JDBC driver is normally classes12.zip, not classes21.zip. Probably a typo.
Col


Col<br /><a href="http://www.squirrelsql.org" target="_blank" rel="nofollow">http://www.squirrelsql.org</a>
Graham Thorpe
Ranch Hand

Joined: Mar 25, 2002
Posts: 265
Absolutely its a classes12.zip but not
classes21.zip.
You may probably find another classes like
classes111.zip etc , and they must be choosen
according to ur jdk versions.
if urs is jdk1.1.x then use classes111.zip;
if urs is jdk1.2.x or higher then use classes12.zip;
venugopal
ersin eser
Ranch Hand

Joined: Feb 22, 2001
Posts: 1072
glkrrr ! ( 2nd reminder)
Please read the Javaranch Naming Policy and change your publicly displayed name to comply with our unique rule. Thank you for your cooperation.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: jdbc with oracle database