This week's book giveaway is in the OCMJEA forum.
We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line!
See this thread for details.
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


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
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.
 
Don't get me started about those stupid light bulbs.
 
subject: jdbc with oracle database