How to add the JDBC mysql driver to an Eclipse project

Question

I have downloaded the mysql-connector-java-5 1 24-bin jar I have created a lib folder in my project and put the jar in there  properties of project- build path- add JAR and selected the JAR above  I still get java sql SQLException  No suitable driver found for jdbc mysql  localhost 3306 mysql   I am using mysql 5 5 The code   package DBTest   import java io IOException  import java io PrintWriter   import javax servlet ServletException  import javax servlet annotation WebServlet  import javax servlet http HttpServlet  import javax servlet http HttpServletRequest  import javax servlet http HttpServletResponse  import java sql    import java util            Servlet implementation class TenUsers      WebServlet   TenUsers   public class TenUsers extends HttpServlet                   see HttpServlet doGet HttpServletRequest request  HttpServletResponse response              protected void doGet HttpServletRequest request  HttpServletResponse response  throws ServletException  IOException            PrintWriter out   response getWriter            String mySqlUrl    jdbc mysql   localhost 3306 mysql            Properties userInfo   new Properties            userInfo put  user    root            userInfo put  password    SabababArba            try              Connection connection   DriverManager getConnection mySqlUrl  userInfo            catch Exception e                out println e                             If I add Class forName  com mysql jdbc Driver    before Connection connection   DriverManager getConnection mySqlUrl  userInfo   I get java lang ClassNotFoundException  com mysql jdbc Driver

User · Answer

copy mysql-connector-java-5 1 24-bin jar  Paste it into   Apache Software Foundation Tomcat 6 0 lib  lt --here--  Restart Your Server from Eclipes  Done

User · Answer

Try to insert this   DriverManager registerDriver new com mysql jdbc Driver       before getting the JDBC Connection

User · Answer

1  I have downloaded the mysql-connector-java-5 1 24-bin jar   Okay        2  I have created a lib folder in my project and put the jar in there    Wrong  You need to drop JAR in  WEB-INF lib folder  You don t need to create any additional folders        3  properties of project- build path- add JAR and selected the JAR above    Unnecessary  Undo it all to avoid possible conflicts        4  I still get java sql SQLException  No suitable driver found for jdbc mysql  localhost 3306 mysql   This exception can have 2 causes    JDBC driver is not in runtime classpath  This is to be solved by doing 2  the right way  JDBC URL is not recognized by any of the loaded JDBC drivers  Indeed  the JDBC URL is wrong  there should as per the MySQL JDBC driver documentation be another colon between the scheme and the host   jdbc mysql   localhost 3306 mysql

User · Answer

you haven t loaded driver into memory   use this following in init     Class forName  com mysql jdbc Driver      Also  you missed a colon     in url  use this  String mySqlUrl    jdbc mysql   localhost 3306 mysql

User · Answer

Try this tutorial it has the explanation and it will be helpful http   www ccs neu edu home kathleen classes cs3200 JDBCtutorial pdf

User · Answer

if you are getting this exception again and again then download my-sql connector and paste in tomcat WEB-INF lib folder   note that some times WEB-INF folder does not contains lib folder  at that time manually create lib folder and paste mysql connector in that folder  definitely this will work if still you got problem then check that your jdk must match your system  i e if your system is 64 bit then jdk must be 64 bit

User · Answer

You can paste the  jar file of the driver in the Java setup instead of adding it to each project that you create  Paste it in C  Program Files Java jre7 lib ext or wherever you have installed java    After this you will find that the  jar driver is enlisted in the library folder of your created project JRE system library  in the IDE  No need to add it repetitively

[java] How to add the JDBC mysql driver to an Eclipse project?

Examples related to java

Examples related to mysql

Examples related to servlets

Examples related to jdbc

Examples related to driver