Hello, I have a simple java application that will retrieve data from a Oracle table via JDBC. The code is shown below. The program can be compiled successfully. But when running it (java TEST), it throws ClassNotFoundException error. If I run with classpath supplied (java -classpath /u01/xxx/xxx/classes12.jar TEST), it has NoClassDefFoundError error. Do you think what's wrong with what I did? I use jdk 1.2.2 to compile. Thanks for your advice!
---------------------------
import java.io.*;
import java.net.URL;
import java.sql.*;
public class TEST {
public static void main (String[] args) throws Exception {
// ********** insert data to database (start) **************
System.out.println("Start connecting..."
;
Class.forName("oracle.jdbc.driver.OracleDriver"
Connection conn = DriverManager.getConnection("jdbcracle:thinHOSTB", "XXXX", "YYYY"
Statement sql = conn.createStatement();
ResultSet result = sql.executeQuery("select * from TABLE"
String abc = null;
abc = result.getString("abc"
// ********** insert data to database (end) **************
System.out.println("abc = " + abc);
conn.close();
}
}
---------------------------
import java.io.*;
import java.net.URL;
import java.sql.*;
public class TEST {
public static void main (String[] args) throws Exception {
// ********** insert data to database (start) **************
System.out.println("Start connecting..."
;Class.forName("oracle.jdbc.driver.OracleDriver"
;Connection conn = DriverManager.getConnection("jdbc
racle:thinHOSTB", "XXXX", "YYYY"Statement sql = conn.createStatement();
ResultSet result = sql.executeQuery("select * from TABLE"
;String abc = null;
abc = result.getString("abc"
; // ********** insert data to database (end) **************
System.out.println("abc = " + abc);
conn.close();
}
}