oracle problems?

[Divya Sanjeev]

Hi All,

Please help me with the following code::

package learn;

import java.sql.*;  
import javax.sql.*;

public class JDBCEx{

	public static void main(String[] args) throws ClassNotFoundException{
		try{
		 Class.forName("oracle.jdbc.driver.OracleDriver");
		 Connection con = DriverManager.getConnection("jdbc:oracle:thin:@202.60.223.181:1521:MyDB","user","pwd");
		 Statement st = con.createStatement();
		 ResultSet rs = st.executeQuery("Select * from Emp");
		 while(rs.next())
		 {
			 String names = rs.getString(2);
			 System.out.println(names);
			 
		 }
		 rs.close();
		 st.close();
		 con.close();
		}catch(SQLException ex){
			ex.printStackTrace();
		}
	}
}

When I compile the above piece of code, I get java.lang.NoClassDefFoundError ...Please help.

Regards,
Divya

[Wendy Gibbons]

Divya you haven't told us what the problem is, so it makes it a little hard to help you fix it.
which class can't it find? and i added code tags for you (they are in the toolbar above where you type).

And i gave your thread a title, when we have more information i will pick a better title.

[Rob Spoor]

If the Oracle driver JAR file was not on your class path, I would expect a ClassNotFoundException - not a NoClassDefFoundError. That means that a class that was resolved during compile time (so not using Class.forName) is now missing. It could be that the Oracle driver JAR file is missing a dependency. We need the stack trace to help you further.