I am currently testing my database connection:
import java.io.IOException;
import java.io.PrintWriter;
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;
import java.sql.*;
@WebServlet("/servlet/casillano.testdb.TestDbServlet")
public class TestDbServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String user="";
String pass="";
String url="jdbc:mysql://localhost:3306/birthday-wishlist-db?useSSL=false&serverTimezone=UTC";
String driver = "com.mysql.cj.jdbc.Driver";
try {
PrintWriter out = response.getWriter();
out.println("Connection to databse: " + url);
Class.forName(driver);
Connection conn = DriverManager.getConnection(url, user, pass);
out.println("Connection successful");
conn.close();
} catch (Exception e) {
e.printStackTrace();
throw new ServletException(e);
}
}
}
It was successful at first, but after a while, a red x popped up on my project and nowhere else. When I tried running this code again, I got a ClassNotFoundException.
My pom.xml contains the mysql dependency:
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.18</version>
</dependency>
So I'm not sure what's wrong. I tried cleaning and doing a Maven update on the project, but nothing worked.