[JSP & Servlet] Kết nối tới CSDL MySQL với Tomcat 10 IntelliJ

Để tạo kết nối tới CSDL MySQL với Tomcat và IntelliJ IDEA 

Mời bạn xem hướng dẫn trong video 

HTTP Status 500 – Internal Server Error

---

Type Exception Report

Message An exception occurred processing [/test.jsp] at line [12]

Description The server encountered an unexpected condition that prevented it from fulfilling the request.

Exception

org.apache.jasper.JasperException: An exception occurred processing [/test.jsp] at line [12]

HTTP Status 500 – Internal Server Error
Type Exception Report
Message An exception occurred processing [/test.jsp] at line [12]
Description The server encountered an unexpected condition that prevented it from fulfilling the request.
Exception

9: <%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql" %>
10: <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
11: 
12: <sql:query var="rs" dataSource="jdbc/TestDB">
13:     select id, foo, bar from testdata
14: </sql:query>
15: 


Stacktrace:
	org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:611)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:490)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:379)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:327)
	jakarta.servlet.http.HttpServlet.service(HttpServlet.java:770)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)

jakarta.servlet.jsp.JspException: Unable to get connection, DataSource invalid: "java.sql.SQLException: Cannot create PoolableConnectionFactory

jakarta.servlet.ServletException: jakarta.servlet.jsp.JspException: Unable to get connection, DataSource invalid: "java.sql.SQLException: Cannot create PoolableConnectionFactory (Access denied for user 'javauser'@'192.168.64.1' (using password: YES))"