java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver [duplicate]

Question

I wrote a Java Servlet program but when I run it, it was showing the Exception

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

My code is

package skypark;

import java.io.*;
import javax.servlet.*;
import java.text.*;
import javax.servlet.http.*;
import java.sql.*;
import java.sql.Date;

public class Registration extends HttpServlet {

    private static final long serialVersionUID = 1L;

    public static Connection prepareConnection() throws ClassNotFoundException, SQLException {
        String dcn = "oracle.jdbc.driver.OracleDriver";
        String url = "jdbc:oracle:thin:@JamesPJ-PC:1521:skypark";
        String usname = "system";
        String pass = "tiger";
        Class.forName(dcn);
        return DriverManager.getConnection(url, usname, pass);
    }

    public void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        resp.setContentType("text/html");
        PrintWriter out = resp.getWriter();

        try {
            String phone1, dofb, date1, month, year, uname, fname, lname, address, city, state, country;
            String pin, email, password, gender, lang, qual, relegion, privacy, hobbies, fav;

            uname = req.getParameter("uname");
            fname = req.getParameter("fname");
            lname = req.getParameter("lname");
            date1 = req.getParameter("date");
            month = req.getParameter("month");
            year = req.getParameter("year");
            address = req.getParameter("address");
            city = req.getParameter("city");
            state = req.getParameter("state");
            country = req.getParameter("country");
            pin = req.getParameter("pin");
            email = req.getParameter("email");
            password = req.getParameter("password");
            gender = req.getParameter("gender");
            phone1 = req.getParameter("phone");

            lang = "";
            qual = "";
            relegion = "";
            privacy = "";
            hobbies = "";
            fav = "";

            dofb = date1 + "-" + month + "-" + year;
            int phone = Integer.parseInt(phone1);
            DateFormat formatter;
            java.util.Date dob;
            formatter = new SimpleDateFormat("dd-MM-yy");
            dob = formatter.parse(dofb);

            Connection con = prepareConnection();
            String Query = "Insert into regdetails values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
            PreparedStatement ps = con.prepareStatement(Query);

            ps.setString(1, uname);
            ps.setString(2, fname);
            ps.setString(3, lname);
            ps.setDate(4, (Date) dob);
            ps.setString(5, address);
            ps.setString(6, city);
            ps.setString(7, state);
            ps.setString(8, country);
            ps.setString(9, pin);
            ps.setString(10, lang);
            ps.setString(11, qual);
            ps.setString(12, relegion);
            ps.setString(13, privacy);
            ps.setString(14, hobbies);
            ps.setString(15, fav);
            ps.setString(16, gender);

            int c = ps.executeUpdate();

            String query = "insert into passmanager values(?,?,?,?)";
            PreparedStatement ps1 = con.prepareStatement(query);

            ps1.setString(1, uname);
            ps1.setString(2, password);
            ps1.setString(3, email);
            ps1.setInt(4, phone);

            int i = ps1.executeUpdate();

            if (c == 1 || c == Statement.SUCCESS_NO_INFO && i == 1 || i == Statement.SUCCESS_NO_INFO) {
                out.println("<html><head><title>Login</title></head><body>");
                out.println("<center><h2>Skypark.com</h2>");
                out.println("<table border=0><tr>");
                out.println("<td>UserName/E-Mail</td>");
                out.println("<form action=login method=post");
                out.println("<td><input type=text name=uname></td>");
                out.println("</tr><tr><td>Password</td>");
                out.println("<td><input type=password name=pass></td></tr></table>");
                out.println("<input type=submit value=Login>");
                out.println("</form></body></html>");
            } else {
                out.println("<html><head><title>Error!</title></head><body>");
                out.println("<center><b>Given details are incorrect</b>");
                out.println(" Please try again</center></body></html>");
                RequestDispatcher rd = req.getRequestDispatcher("registration.html");
                rd.include(req, resp);
                return;
            }
        } catch (ClassNotFoundException cnfe) {
            out.println("<html><head><title>Error!</title><body>");
            out.println("<b><i>Class not found " + cnfe + "</i></b>");
            out.println("</body></html>");
        } catch (SQLException sqle) {
            out.println("<html><head><title>Error!</title><body>");
            out.println("<b><i>Unable to process try after some time Sql error</i></b>");
            out.println("</body></html>");
        } catch (ParseException e) {
            out.println("<html><head><title>Error!</title><body>");
            out.println("<b><i>Unable to process Parseint exc " + e + "</i></b>");
            out.println("</body></html>");
        }

        out.flush();
        out.close();
    }
}

My class path is :

C: \Windows\ system32 > echo % classpath %
  E: \app\ JamesPJ\ product\ 11.2.0\ dbhome_1\ oui\ jlib\ classes12.jar;
E: \app\ JamesPJ\ product 11.2.0\ dbhome_1\ jlib\ orai18n.jar;
E: \app\ JamesPJ\ product\ 11.2.0\ dbhome_1\ jdbc\ lib\ ojdc6_g.jar;
E: \app\ JamesPJ\ product\ 11.2.0\ dbhome_1\ BIN;
C: \Program Files\ Java\ jdk1.7.0_09\ bin;
C: \Users\ JamesPJ\ Documents;
E: \app\ JamesPJ\ product\ 11.2.0\ dbhome_1\ jdbc\ lib;
E: \app\ JamesPJ\ product\ 11.2.0\ dbhome_1\ jlib;
E: \app\ JamesPJ\ product\ 11.2.0\ dbhome_1\ jdbc\ lib\ ojdbc6.jar;
E: \app\ JamesPJ\ product\ 11.2.0\ dbhome_1\ oc4j\ jdbc\ lib\ orai18n.jar;
E: \app\ JamesPJ\ product\ 11.2.0\ dbhome_1\ oc4j\ jdbc\ lib\ ocrs12.jar;
E: \app\ JamesPJ\ product\ 11.2.0\ dbhome_1\ owb\ wf\ lib\ ojdbc14.jar;
C: \Program Files\ Apache Software Foundation\ Tomcat 7.0\ lib\ servlet - api.jar

When I give the

 java oracle.jdbc.driver.OracleDriver

command in command prompt, it was showing following lines

Error: Main method not found in class oracle.jdbc.driver.OracleDriver, please define the main method as:
       public static void main(String[] args)

OracleDriver does not contain a main method. You cannot start a servlet without a corresponding container (like tomcat)... calling java oracle.jdbc.driver.OracleDriver does not make any sense. — home
– home, Commented Dec 16, 2012 at 19:22

Ajay S · Accepted Answer · 2012-12-17 05:17:13Z

30

Have you copied classes12.jar in lib folder of your web application and set the classpath in eclipse.

Right-click project in Package explorer Build path -> Add external archives...

Select your ojdbc6.jar archive

Press OK

Or

Go through this link and read and do carefully.

The library should be now referenced in the "Referenced Librairies" under the Package explorer. Now try to run your program again.

edited Dec 17, 2012 at 5:17

answered Dec 16, 2012 at 18:14

Ajay S

48.7k28 gold badges97 silver badges118 bronze badges

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

15 Comments

user1854535 Over a year ago

yes i copied classes12.jar ad ojdbc14.jar

Ajay S Over a year ago

which oracle version you are using either 8i or 10g

user1854535 Over a year ago

i am using oracle 11g R2

Ajay S Over a year ago

Then use ojdbc6.jar and delete classes12.jar and ojdbc14.jar and Class.forName ("oracle.jdbc.OracleDriver"); and see this stackoverflow.com/questions/8007174/…

user1854535 Over a year ago

i changed jar files in lib folder to ojdbc6 and class.forName to oracle.jdbc.OracleDriver now also it was showing java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver

|

Manuel · Accepted Answer · 2013-11-20 08:19:19Z

24

Go through C:\apache-tomcat-7.0.47\lib path (this path may be differ based on where you installed the Tomcat server) then past ojdbc14.jar if its not contain.

Then restart the server in eclipse then run your app on server

edited Nov 20, 2013 at 8:19

Manuel

4,4536 gold badges38 silver badges52 bronze badges

answered Nov 20, 2013 at 7:58

Ravikumar D G

2492 silver badges2 bronze badges

2 Comments

Farhan stands with Palestine Over a year ago

@Ravikumar D G: +1 also solved the problem for me.

java.nazif Over a year ago

Infact that is brilliant..my problem is solved

Mikro Koder · Accepted Answer · 2015-03-13 10:27:59Z

9

team! For execute SQL-query from your Servlet you should add JDBC jar library in folder

WEB-INF/lib

After this you could call driver, example :

Class.forName("oracle.jdbc.OracleDriver");

Now Y can use connection to DB-server

==> 73!

answered Mar 13, 2015 at 10:27

Mikro Koder

1,09610 silver badges13 bronze badges

1 Comment

maximusg Over a year ago

This worked for me. I am even referencing the ojdbc6.jar file from a different location in classpath, but this lib file must also have a copy of it. No need to restart.

zedtimi · Accepted Answer · 2015-07-16 11:17:44Z

4

try to add ojdbc6.jar through the server lib "C:\apache-tomcat-7.0.47\lib",

Then restart the server in eclipse.

answered Jul 16, 2015 at 11:17

zedtimi

3061 silver badge6 bronze badges

Comments

user3683160 · Accepted Answer · 2014-05-28 10:18:40Z

0

I was getting same kinda error but after copying the ojdbc14.jar into lib folder, no more exception.(copy ojdbc14.jar from somewhere and paste it into lib folder inside WebContent.)

answered May 28, 2014 at 10:18

user3683160

11

Comments

Anthony Grist · Accepted Answer · 2014-07-14 18:46:58Z

0

I had the same problem but was able to fix it by doing the following:

Right-click on the project -> Properties, then add the JAR (odjbc6 or 14) file in the deployment assembly.

edited Jul 14, 2014 at 18:46

Anthony Grist

38.4k8 gold badges64 silver badges76 bronze badges

answered Jul 14, 2014 at 17:53

raghu

11

1 Comment

Dave Morrissey Over a year ago

Your answer refers to a specific IDE and setup but I think the OP's is different. They also seem to have added this jar to their classpath.

Collectives™ on Stack Overflow

java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver [duplicate]

6 Answers 6

15 Comments

2 Comments

1 Comment

Comments

Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

15 Comments

2 Comments

1 Comment

Comments

Comments

1 Comment

Linked

Related