Java Answers Forum - JAva Application and JDBC Oracle 10g connection problem

Articles |
News |
Weblogs |
Books |
Forums

Artima Forums | Articles | Weblogs | Java Answers | News

Sponsored Link •

Java Answers Forum
JAva Application and JDBC Oracle 10g connection problem

1 reply on 1 page. Most recent reply: Oct 23, 2005 10:43 PM by Kondwani Mkandawire

Welcome Guest
Sign In

Back to Topic List

Reply to this Topic

Search Forum

Threaded View


Previous Topic		Next Topic

Flat View: This topic has 1 reply on 1 page

orod sem

Posts: 1
Nickname: orodsem
Registered: Oct, 2005

JAva Application and JDBC Oracle 10g connection problem

Posted: Oct 23, 2005 4:14 AM

dear sir/madam,

it is my code:

public class MyMain {
public static void main(String[] args) throws SQLException, ClassNotFoundException{
String dbUrl = "jdbc:oracle:thin:@server.tafahom.org:1521:db";
String userName = "orod";
String password = "orod";
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection c =
DriverManager.getConnection(dbUrl,userName,password);
...

and it is my exception:
Exception in thread "main" java.lang.ClassNotFoundException:oracle.jdbc.driver.OracleDriver
...

please help me.
regards,
orodsem

Kondwani Mkandawire

Posts: 530
Nickname: spike
Registered: Aug, 2004

Re: JAva Application and JDBC Oracle 10g connection problem

Posted: Oct 23, 2005 10:43 PM

>
> DriverManager.getConnection(dbUrl,userName,password);
> ...
>
> and it is my exception:
> Exception in thread "main"
> java.lang.ClassNotFoundException:oracle.jdbc.driver.OracleD
> river
> ...

Means exactly that. The JVM was unable to locate the class
OracleDriver. What you want to do is ensure that you have
the appropriate Jar File containing this Driver. There should
be a Jar File with a Name to the effect of SomeName-oracle-SomeOtherString.jar

Its obviously not called SomeName-etc... but it most likely
has "oracle" within the String name terminated with a Jar.

Do the following:

jar -tvf SomeName-oracle-SomeOtherString.jar

And is should list if the OracleDriver is contained.

Then if you are using a *nix system. set the classpath
as follows:

export CLASSPATH=$CLASSPATH:./:/locationOfOracleJarDirectory/SomeName-oracle-SomeOther String.jar

In Windows:

set CLASSPATH=%CLASSPATH%;C:\locationOfOracleJarDirectory/SomeName-oracle-SomeOther String.jar

with your class path set you can now run your program.

Good luck,
Kondwani

Flat View: This topic has 1 reply on 1 page

Previous Topic

Next Topic


	Web Artima.com