install JDBC driver

[achen]

Hi, there,

The following is my system:
Database ==> Oracle 8.1.6 in Unix
my computer ==> NT, I want to install JDBC driver in this PC, so I can access Oracle DB using Java application. I have JDK 1.2 in this pc.

I downloaded classes12.zip from Oracle, and unziped it. According to Oracle's instructions, I should add [ORACLE_HOME]\jdbc\lib\classes12.zip to CLASSPATH. But I am confused here. Where is the physical location of theis [ORACLE_HOME]\jdbc\lib\classes12.zip? I could not find it?

My next question is that assume everything above is done, do I need to do anything else before I run Java program?

My 3rd question is that can I use this JDBC driver in J2EE?

Ashley

 

[frag]

Hi achen,

to your questions:

1. I guess [ORACLE_HOME] is the path in which your database was installed

2. Try this link for informations about JDBC:

http://java.sun.com/docs/books/tutorial/jdbc/basics/index.html

3. no idea!

Hope this was helpfull.

cya

frag patrick.metz@epost.de

 

[rams1978]

Hai achen,
1. For the first question as frag mentioned [ORACLE_HOME]with be there by default when u loaded Oracle.
Including the classpath u set please do set path this also.
set path=%path%; E:\oracle_home\ora81\bin;.;
2. Before U run the java program set the class path for java as set classpath="classpath%;E:/jdk1.3/lib;.;
and also set path=%path%;E:/jdk1.3/bin;.;
and then run the java program.
3. U can use the JDBC driver with no problem and i think it is must also.

Anil.