SOLVED :- java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

Exception :- 

Please provide me a solution to following error when i try to run Java file which has connections to MYSQL database. 

[javax.servlet.ServletException: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver] with root cause

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1676)

at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1521)

at org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:126)

at org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:63)

at java.lang.Class.forName0(Native Method)

at java.lang.Class.forName(Unknown Source)

at org.apache.jsp.login_jsp._jspService(login_jsp.java:62)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:417)

at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:391)

at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:306)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:240)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)

at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:383)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:243)

at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:188)

at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:166)

at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:288)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)




Comments

  1. Anonymous12 January 2013 at 22:25

    Hi,just add mysql-connector-java-5.1.20-bin.jar to your build path. It works for me.

    ReplyDelete
  2. Piyush Mundada12 January 2013 at 22:28

    Thanks for response. But it is not working for me.

    ReplyDelete
  3. Piyush Mundada12 January 2013 at 22:29

    I found a solution to same. That rather than adding mysql-connector-java-5.1.20-bin (jar) file to java build path. I have explicitly added mysql-connector-java-5.1.20-bin.jar to WEB-INF\lib folder. It is working fine now.

    ReplyDelete
  4. Anonymous22 June 2013 at 00:49

    Piyush Mundada Thank you . your solution is very much correct. It worked for me.

    ReplyDelete
  5. Unknown20 January 2014 at 23:07

    This comment has been removed by the author.

    ReplyDelete
  6. Anonymous10 April 2014 at 23:45

    bt it's nt working for me still shoes class nt found

    ReplyDelete
  7. Anonymous10 April 2014 at 23:47

    i hav added jar file to both places still gives error clas not found

    ReplyDelete
  8. Unknown12 June 2014 at 02:07

    Hi,
    I tried everything - from adding JAR file to WEB-INF/lib to adding it to Window>Preferences>Java>Classpath Variables. Still im getting java.lang.ClassNotFoundException and that huge list of error:
    at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1676)
    at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1521)
    at org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:126)
    at org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:63)
    at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Class.java:169)
    at org.apache.jsp.NewFile_jsp._jspService(NewFile_jsp.java:65)....


    My piece of scriplet is:

    <%@ page import="java.sql.*" %>
    <%@ page import="java.io.*" %>

    <%
    System.out.println("-------- MySQL JDBC Connection Testing ------------");

    try
    {
    Class.forName("com.mysql.jdbc.driver");
    }
    catch (ClassNotFoundException e)
    {
    //System.out.println("Where is your MySQL JDBC Driver?");
    PrintWriter pw = new PrintWriter(System.out, true);
    pw.println("Driver Connection Failed, yahoo!");
    e.printStackTrace();

    }
    System.out.println("MySQL JDBC Driver Registered!");
    Connection connection = null;
    %>

    ReplyDelete
    Replies
    1. Unknown12 June 2014 at 02:31

      Sorry, i got it running now.
      I used:
      Class.forName("com.mysql.jdbc.driver");
      instead of
      Class.forName("com.mysql.jdbc.Driver");// Capital D

      Thanks

      Delete
    2. Piyush Mundada13 June 2014 at 07:56

      Happy to hear that...☺

      Delete
  9. Anonymous5 March 2015 at 22:48

    I tried all the solutions..it still shows " java.lang.ClassNotFoundException: com.mysql.jdbc.Driver" can u please help?

    ReplyDelete
    Replies
    1. Piyush Mundada6 March 2015 at 08:20

      Can you please post your class and exact issue log.

      Delete
  10. Anonymous12 January 2016 at 00:42

    By keeping WEB-INF/lib/mysql-connector-java-5.1.20-bin.jar like this it works...

    ReplyDelete
  11. Anonymous15 February 2016 at 09:41

    Thank you.My Problem is also solved because of your huge discussion on ClassNotFoundException.
    Really Thank u again..

    ReplyDelete
  12. Unknown22 February 2016 at 04:17

    hi
    i am tried to running the program but is same isuess above mention...javax.servlet.ServletException: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver this type error showing in my program....

    ReplyDelete
  13. Unknown22 February 2016 at 04:23

    i am also add the mysql-connector-java-5.1.5-bin but it is not working

    ReplyDelete
    Replies
    1. Piyush Mundada8 March 2016 at 11:00

      Can you please post your class and exact issue log.

      Delete
  14. Unknown8 March 2016 at 08:05

    ya i also have same problem.
    i add connector file in that direcotry,but yet it not working....
    can u give me solution on this pls

    ReplyDelete
    Replies
    1. Piyush Mundada8 March 2016 at 11:00

      Can you please post your class and exact issue log so that I can provide exact solution on same

      Delete
  15. Unknown26 May 2016 at 23:29

    i also have same problem.i do all steps that u tell above, but yet it not working....
    can u give me solution on this pls

    ReplyDelete
    Replies
    1. Unknown26 May 2016 at 23:30

      my script is
      <%@ page import ="java.sql.*" %>
      <%@ page import="java.io.*" %>

      <%
      String userid = request.getParameter("uname");
      String pwd = request.getParameter("pass");
      Class.forName("com.mysql.jdbc.Driver");
      Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/db", "root", "123");
      Statement st = con.createStatement();
      ResultSet rs;
      rs = st.executeQuery("select * from members where uname='" + userid + "' and pass='" + pwd + "'");
      if (rs.next()) {
      session.setAttribute("userid", userid);
      out.println("welcome " + userid);
      out.println("Log out");
      response.sendRedirect("success.jsp");
      } else {
      out.println("Invalid password try again");
      }
      %>

      Delete
    2. Piyush Mundada26 May 2016 at 23:46

      did you add mysql-connector-java-5.1.20-bin (jar) file to java build path ? Rather add explicitly mysql-connector-java-5.1.20-bin.jar to WEB-INF\lib folder. If still issue persist, then please revert back.

      Delete
  16. Anonymous31 December 2017 at 00:28

    I have done all the steps,but it still shows ' java.lang.ClassNotFoundException: com.mysql.jdbc.Driver' exception.

    ReplyDelete
  17. Unknown29 July 2018 at 10:21

    This comment has been removed by the author.

    ReplyDelete

Post a Comment

Popular posts from this blog

Bresenham line drawing algorithm in java

   My friend Sandip is doing M.Tech from one of the reputed college. His lecturer asked him to do Java code for line drawing using Bresenham s , DDA algorithm. So I am posting this blog for  Bresenham line drawing algorithm in java and you can find line drawing using DDA algorithm  here . Read more about Bresenham's line algorithm  . Java code :-  package applet; import java.awt.Color; import java.awt.Dimension; import java.awt.Graphics; import java.awt.event.MouseEvent; import java.awt.event.MouseListener; import java.awt.event.MouseMotionListener; public class bresenhamLine extends java.applet.Applet implements MouseListener, MouseMotionListener { private static final long serialVersionUID = 1L; int width, height; int x1 = 0, y1 = 0, x2 = 0, y2 = 0, pixelsize = 2; public void init() {      width = getSize().width;      height = getSize().height;      this.addMous...
Read more

dda line drawing algorithm in java

Read about DDA (Digital differential analyzer) algorithm . You can find line drawing using bresenham's line algorithm here . Java Code for DDA line drawing algorithm. :- package applet; import java.applet.Applet; import java.awt.Button; import java.awt.Color; import java.awt.Dimension; import java.awt.Graphics; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.awt.event.MouseEvent; import java.awt.event.MouseListener; import java.awt.event.MouseMotionListener; public class dda extends Applet implements MouseListener, MouseMotionListener, ActionListener {     int x1 = -1, y1 = -1, x2 = -1, y2 = -1,     //coordinates of start and end points             pixelsize = 12,                     //size of pixel in raster             xa = 0, xfin = 0, yfin = 0,         //increment and end po...
Read more