Home » Developer & Programmer » JDeveloper, Java & XML » JDBC_oracle error
JDBC_oracle error [message #91374] Wed, 31 July 2002 13:30 Go to next message
Abhijeet
Messages: 5
Registered: July 2002
Junior Member
im trying to connect to an Oracle database...using the OCI method

my java code is on my machine and the database (and table )instance is on the host Im trying to establish a connection to

The statement

Connection conn=DriverManager.getConnection("jdbc:oracle:oci8:@VIS", "abi", "abi");

where VIS is the Instance for the ORASID and abi, abi are the username and passowords respectively ....

gives me the following error.

package oracle.jdbc.driver does not exist

do i have to install some driver info on the host which has the database instance where I am trying to connect ?

and do I have to make changes in the classpath ?

Infact...even the import statement...
import oracle.jdbc.driver.*;
seems to throw an error...

someone please advice me ...especially with regard to the driver info and classpath ..

Thank you very much..

Regards
Abhijeet
Re: JDBC_oracle error [message #91378 is a reply to message #91374] Thu, 01 August 2002 09:22 Go to previous message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You need to add the JDBC classesxxx.zip to your CLASSPATH. This file will be in $ORACLE_HOME/jdbc/lib.
Previous Topic: Re: how to insert a file into oracle blob object
Next Topic: Re: Connection Pooling
Goto Forum:
  


Current Time: Sat Jul 24 15:27:28 CDT 2021