I've tried looking at every answer related to this question and it still gives me the same error. I've tried including jar files to my project and it still doesn't work. Please help me. This is my servlet file.
package com.test.testdb;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
* Servlet implementation class TestDbServlet
*/
@WebServlet("/TestDbServlet")
public class TestDbServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#doGet(HttpServletRequest request,
HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse
response) throws ServletException, IOException {
String user = "test";
String pass = "test";
String jdbcUrl = "jdbc:mysql://localhost:3306/test?
useSSL=false";
String driver = "com.mysql.jdbc.Driver";
try {
PrintWriter out = response.getWriter();
out.println("Connecting to database: " + jdbcUrl);
Class.forName(driver);
Connection myConn = DriverManager.getConnection(jdbcUrl, user, pass);
out.println("yay");
myConn.close();
}
catch (Exception exc) {
exc.printStackTrace();
throw new ServletException(exc);
}
}
}
I've already added mysql-connector-java-5.1.47-bin.jar to my WEB-INF>lib folder. I'm new to this so I'm still trying to figure things out. Please help me. This is what I get when I run the file.
Connecting to database: jdbc:mysql:localhost:3306/test java.sql.SQLException: No suitable driver found for >jdbc:mysql:localhost:3306/test at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at com.hibernate_tutorial.jdbc.Driver.main(Driver.java:16)
