Exception in thread "main" java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver In netbeans

Question

I'm trying to connect the database with Netbeans with the help of oracle 10g. I have downloaded odjbc7.jar file and added it in the ORACLE THIN driver in db services. Still, I'm getting this class not found exception. (I am using Apache netbeans).

enter code here

       import java.sql.*;

        public class jdbclass {
        public static void main(String args[]) throws ClassNotFoundException, SQLException
       {
             String url="jdbc:oracle:thin:@localhost:1521:orcl";
             String uname="sh";
             String passwd="ara";
             String query="select pizza_type from pizza";
             Class.forName("oracle.jdbc.driver.OracleDriver");
             Connection con=DriverManager.getConnection(url,uname, passed);
             Statement st=con.createStatement();
             ResultSet rs=st.executeQuery(query);
             String name=rs.getString("pizza_type");
             rs.next();
            System.out.print(name);
            st.close();
            con.close();

          }

        }

Please explain how you manage the dependencies of your project. Usually, we do not download the .jar; we include the dependency and the project management tool (Maven, Gradle, etc.) download it and include it on the path. — Chocksmith, Apr 19 '20 at 11:44
You probably already know this, but Oracle 10g has been [unsupported since 2013](https://www.orafaq.com/wiki/Oracle_10g)! Can you move to Oracle 12c? — skomisa, Apr 19 '20 at 19:31
Yes It works fine now .I have moved from apache netbeans to netbeans ide 8.2.With that I could easily add the jar file in the libraries.Thanks — Aravind P, Apr 21 '20 at 08:32

score 0 · Accepted Answer · answered Apr 19 '20 at 06:37

0

You should use ojdbc14.jar as mentioned at https://docs.oracle.com/cd/E19830-01/819-4721/beanh/index.html
Make sure you have added the jar in the classpath as mentioned at How do I set the classpath in NetBeans?

answered Apr 19 '20 at 06:37

Arvind Kumar Avinash

71,965
6
74
110

Yes..Thanks a lot.Now I've added the jar file in the classpath and it works fine now – Aravind P Apr 21 '20 at 08:33

Exception in thread "main" java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver In netbeans

1 Answers1