• 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Paul Clapham
  • Ron McLeod
Sheriffs:
  • Jeanne Boyarsky
  • Liutauras Vilda
Saloon Keepers:
  • Tim Holloway
  • Carey Brown
  • Roland Mueller
  • Piet Souris
Bartenders:

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

 
Ranch Hand
Posts: 782
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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: 782
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
maybe this link will help you along. I just posted it for someone else.
 
reply
    Bookmark Topic Watch Topic
  • New Topic