How to add the JDBC mysql driver to an Eclipse project?

driver, java, jdbc, mysql, servlets

Solution

Try to insert this:

DriverManager.registerDriver(new com.mysql.jdbc.Driver());

before getting the JDBC Connection.

Problem

- 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`

Original source

Related problems