Java Program compile and run in command prompt successfully but not in myeclips?

Question

I'm learning jdbc and working with Oracle database by writing this simple code. The IDE i'm using is MyEclips. But the problem is when I compile and run this program in command prompt it works properly but when I try to compile and run this program in my IDE i.e. MyEclips it through an error message:

java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver

import java.sql.*;  
class OracleCon{  
public static void main(String args[])
{  
        try
        {
        Class.forName("oracle.jdbc.driver.OracleDriver");
        Connection con = null;

        String URL = "jdbc:oracle:thin:@localhost:1521:xe";
        String UN = "HR";
        String PASS = "12345";

        con = DriverManager.getConnection(URL,UN,PASS);

        Statement stmt = con.createStatement();

        String sql = "SELECT * FROM EMPLOYEES";

        ResultSet rs = stmt.executeQuery(sql);

        while (rs.next())
        {
        System.out.println(rs.getString(1)+"   "+rs.getString(2)+"   "+rs.getString(3));
        }

        }

        catch (Exception e)
        {
        System.out.println(e);
        }  
    }
}

I also set the class path in Environment variable.Environment variable snippet

Please don't add images for anything that can simply be text. — ChiefTwoPencils
– ChiefTwoPencils, Commented Sep 22, 2016 at 7:18

Dsenese1 · Accepted Answer · 2016-09-22 07:20:40Z

1

Verify that the name of the requested class is correct and that the appropriate .jar file exists in your classpath. If not, you must explicitly add it to your application’s classpath.
In case the specified .jar file exists in your classpath then, your application’s classpath is getting overriden and you must find the exact classpath used by your application.
In case the exception is caused by a third party class, you must identify the class that throws the exception and then, add the missing .jar files in your classpath.

answered Sep 22, 2016 at 7:20

Dsenese1

1,17610 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Java Program compile and run in command prompt successfully but not in myeclips?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related