package oracle does not exist

i tried to do the following but got the below error

C:\Sun\AppServer\jdk\bin>java -classpath C:/Program Files/Oracle/ora92/jdbc/lib/

ojdbc14.jar

Exception in thread "main" java.lang.NoClassDefFoundError: Files/Oracle/ora92/jd

bc/lib/ojdbc14/jar

anaik100a at 2007-7-13 11:01:57 >

Here is my code where i am getting this error..i am not sure if this error is because of soemthign is wrong in this code..

If that is the case it should have atleast first recognized that my import oracle library exists..

import java.io.*;

import java.sql.*;

import oracle.jdbc.driver.*;

public class TestDB

{

public Connection opendb()

{

Connection conn;

// Load the Oracle JDBC driver

try

{

DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());

conn = DriverManager.getConnection(

"jdbc:oracle:mat:@clrs.mmmm.dt.com:1527:oooooo",

"test",

"test");

}

catch (SQLException ex)

{

return null;

}

return conn;

}

public boolean closedb(Connection connobj)

{

try

{

connobj.close();

}

catch (SQLException ex)

{

return true;

}

return true;

}

public static void main(String[] args)

{

TestDB TestDBObj = new TestDB();

Connection conn;

if ((conn = TestDBObj.opendb()) == null)

{

System.out.println("open db error\n");

return;

}

// Create a statement

Statement stmt = conn.createStatement();

String output,intable;

String sqlstr = "select distinct optvolumename_nm, doctype_id from clradmin;";

//System.out.println(sqlstr);

ResultSet rset = stmt.executeQuery(sqlstr);

while (rset.next())

{

output = rset.getString(1);

}

System.out.println(output);

rset.close();

stmt.close();

TestDBObj.closedb(conn);

}

}

anaik100a at 2007-7-13 11:01:57 >

This code is wrong. Where did you get that URL to connect to the database? That's not right.

You return null if an exception is caught? You don't print out the stack trace? Bad idea.

What is the name of the JAR you got from Oracle? Is it ojdbc14.jar? (It should be.) Whatever it is, put that JAR in the same directory where you have TestDB.java. Don't think about "installing" it anywhere.

Compile your class like this:

javac TestDB.java

If you don't have compile errors, this will write a TestDB.class file in the same directory where TestDB.java lives.

If ojdbc14.jar is in the same directory as TestDB.class, run it like this:

java -classpath .;ojdbc14.jar TestDB

Note the "dot" as the first entry after -classpath. That tells the class loader to look in the current directory and ojdbc14.jar to find the classes it needs.

The URL should look like this:

jdbc:oracle:thin:@hostname:1521:database

Change the hostname and database to match your situation.

%

duffymoa at 2007-7-13 11:01:57 >

> Thank you very much for the help duffymo..

>

> 1. Can i not set the ojdbc14.jar fiel permanently

You can, but you've already learned that Java ignores it. Why do you persist?

> ly in the CLASS path

>2. jdbc:oracle:thin:@hostname:1521:database

>this gives me OpenDB error..

Then you don't have the thin JDBC driver. Which one do you have?

> but if i use

> jdbc:oracle:thin:@hostname:1527:database

> my query is getting executed

OK, this tells me that someone installed your Oracle listener to use port 1527, which is not the default port. 1521 is the default. You did the right thing by using the one that you were given.

Since you're getting your query executed now, all is well.

%

duffymoa at 2007-7-13 11:01:57 >