Org.apache.jasper.JasperException: No suitable driver RESOLVIDO

Front-end
#1

Oi Pessoal

Comecei a estudar JSP, e estou com um problema para carregar o Driver no meu projeto. Dei uma pesquisada no Google e vi que mt dizem que é necessário colocar o driver na minha pasta WEB-INF/lib, daí tentei colocar o driver lá mas não consigo, estou usando o eclipse:

Seguem os código e erros que ocorrem:

Classe que faz a conexão

package br.teste;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;


public class ConnectionFactory {
	
	private static String url;
    private static String driver;
    private static String usuario;
    private static String senha;
    public static Connection conn;
	
	public static Connection getConnection() throws SQLException{
		System.out.println("Chegou no ConnectionFactory");
		driver = "com.mysql.jdbc.Driver";
        url = "jdbc:mysql://localhost:3306/contato";
        usuario = "root"; // usuário do banco
        senha = "123456";//senha do usuário de banco.
        try {
			Class.forName(driver);
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} // carrega o driver
                    
		conn = DriverManager.getConnection(url, usuario, senha);
		return conn;
	}

}

ContatoDAO, que chama a conexão:

package br.teste;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.PreparedStatement;
import java.util.ArrayList;
import java.util.List;

public class ContatoDAO {

	private Connection conectar;
	
	public ContatoDAO() throws SQLException, ClassNotFoundException {
		System.out.println("Chegou aqui");
		this.conectar = ConnectionFactory.getConnection();
	}
}

Meu JSP que chama a ContatoDAO

<%@page pageEncoding="Cp1252" contentType="text/html; charset=Cp1252" %>
<%@ page import="java.util.*, br.teste.Contato, br.teste.ConnectionFactory, br.teste.ContatoDAO" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Cp1252"/>
<title></title>
</head>
<body>

<% 
	ContatoDAO dao = new ContatoDAO();
	List<Contato> contatos = dao.getLista();
		for(Contato c:contatos){
%>
	<li><%=c.getNome()%>, <%= c.getEmail() %></li>
<% } %>

</body>
</html>

Erros que ocorrem:

HTTP Status 500 -

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: No suitable driver
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:460)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:355)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)

root cause

javax.servlet.ServletException: No suitable driver
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:841)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:774)
org.apache.jsp.bemvindo_jsp._jspService(bemvindo_jsp.java:80)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)

root cause

java.sql.SQLException: No suitable driver
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
br.teste.ConnectionFactory.getConnection(ConnectionFactory.java:28)
br.teste.ContatoDAO.(ContatoDAO.java:15)
org.apache.jsp.bemvindo_jsp._jspService(bemvindo_jsp.java:56)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)

note The full stack trace of the root cause is available in the Apache Tomcat/5.5.27 logs.
Apache Tomcat/5.5.27

Se alguém tiver alguma idéia, obrigada!! :slight_smile:

#2

Pessoal já resolvi,

tinha colocado o driver do mysql na pasta errada :oops: , agora coloqui na certa common/lib.

Valeu T++

#3