• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Bear Bibeault
  • Junilu Lacar
Sheriffs:
  • Jeanne Boyarsky
  • Tim Cooke
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • salvin francis
  • Frits Walraven
Bartenders:
  • Scott Selikoff
  • Piet Souris
  • Carey Brown

JDBC Driver For Oracle 7 or 8 ??-URGENT!

 
Ranch Hand
Posts: 765
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Ranchers,
I am trying to connect my servlet with Oracle 7 via JDBC.But i failed to do so.However i've succeeded in connecting with MS Access.I think the problem is in Oracle 7 Driver.I have downloaded a sample code from JDBC Tutorial which shows connection with Oracle.But it is not working.Here it is...

I think java.sql included driver for MS Access But not for Oracle 7.What i shall do now?.Does i search for Oracl7 driver? or installed Oracle 8i Enterprise on WIN NT i hope Oracle 8i have Builtin driver.
Please solve my problem!.
Bye.
Viki.
NOTE:
My Enviroment is:
WIN 98
JDK1.3
TOMCAT 4.0
[ April 30, 2002: Message edited by: Vikrama Sanjeeva ]
[ April 30, 2002: Message edited by: Vikrama Sanjeeva ]
 
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
download your drivers here. ( accept the terms and conditions ). Download the drivers for "JDBC-Thin, 100% Java ( 1.9MB)" for Oracle 8.1.7 ( they are backward compatible to Oracle 7 ) then use this information to connect to the database via jdbc. Let me know how it goes.
Jamie
 
Vikrama Sanjeeva
Ranch Hand
Posts: 765
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ok Jamie.I've downloaded JDBC-Thin, 100% Java ( 1.9MB)" for Oracle 8.1.7.It is a zipped file named "classes12.zip".Now does i've to set this file by set classpath at the prompt from where i am running tomcat4 ?.And secondly which packages of sun & oracle i've to import.?
Bye.
Viki.
[ April 30, 2002: Message edited by: Vikrama Sanjeeva ]
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
maybe this link will help you along. I just posted it for someone else.
 
What a stench! Central nervous system shutting down. Save yourself tiny ad!
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
    Bookmark Topic Watch Topic
  • New Topic