File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes jdbc oracle 8i connectivity Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "jdbc oracle 8i connectivity" Watch "jdbc oracle 8i connectivity" New topic

jdbc oracle 8i connectivity

Anup Bhattacharjee

Joined: Apr 30, 2008
Posts: 1
I have SERVER 2000 server machine with oracle 8i enterpise version
and client machine having xp and oracle 8i client
server name "server"
from sql it is working fine
server ip address
client ip address
user id scott
password tiger
now i want to connect oracle database at server through jdbc
java have been installed in client
jdbc downloaded to this machine
when i am running simple java file is working fine but
i can not connect oracle through jdbc
i wnat to ser classpath
i am a beginer so kindly give me a very simple java file for oracle database connectivity
with jdbc

thanking you
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3753

Upgrade your database No really.

Oracle is one of the few DBMS where older versions of the database are often not accepted by newer clients. I can recall using a 10.* client to connect to a 7 (it might have been 8) version of the database only to get the message implying I needed to upgrade the database to connect with that client. It lead to a frantic search for a virtually non-existent version of the older client. In that regard you may consider a version of the JDBC driver for that version of Oracle.
[ April 30, 2008: Message edited by: Scott Selikoff ]

[OCA 8 Book] [Blog]
I agree. Here's the link:
subject: jdbc oracle 8i connectivity
It's not a secret anymore!