I have problems configuring mysql-connector jar for my project.
I have put it in the following route: jsp-jdbc-mysql-example/src/main/webapp/WEB-INF/lib/mysql-connector-java-8.0.22.jar And configured the build path Build path shows it is under Web App Libraries
The error code message is jakarta.servlet.ServletException: java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/employee_database
I've also tried to change the project type to Maven but it didn't solve the issue.
I've checked if i could connect to the database in a regular Java project by adding the jar file and it allowed me.
Also I would like to whereas to stick to the Dynamic Web Project or change it to a Maven project.
