Galera, estou com esse mesmo problema, tenho o jar do mysql na pasta lib e talz. qdo rodo no java mesmo, funfa de boa, mas na jsp não!
JSP
[code]<%@page import=“test.dao.Funcionario”%>
<%@page import=“java.util.*” %>
<%@page import=“test.dao.FuncionarioDAO”%>
<%@taglib uri=“http://java.sun.com/jsp/jstl/core” prefix=“c” %>
<%@ page language=“java” contentType=“text/html; charset=UTF-8”
pageEncoding=“UTF-8”%>
Insert title here
<table>
<c:forEach var="func" items="${funcdao.lista}">
<tr>
<td>${func.nome}</td>
<td>${func.endereco}</td>
<td>${func.email}</td>
<td>${func.dataNasc.time}</td>
</tr>
</c:forEach>
</table>
[/code]
Browser
[code]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: An exception occurred processing JSP page /lista-func.jsp at line 14
11: Insert title here
12:
13:
14: <jsp:useBean id=“funcdao” class=“test.dao.FuncionarioDAO”/>
15: <c:import url=“cabecalho.jsp”/>
16:
17:
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:567)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:471)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:389)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:333)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
root cause
java.lang.RuntimeException: java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost/teste
test.connection.ConnectionFactory.getConnection(ConnectionFactory.java:13)
test.dao.FuncionarioDAO.(FuncionarioDAO.java:20)
org.apache.jsp.lista_002dfunc_jsp._jspService(lista_002dfunc_jsp.java:87)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:433)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:389)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:333)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
root cause
java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost/teste
java.sql.DriverManager.getConnection(DriverManager.java:602)
java.sql.DriverManager.getConnection(DriverManager.java:185)
test.connection.ConnectionFactory.getConnection(ConnectionFactory.java:11)
test.dao.FuncionarioDAO.(FuncionarioDAO.java:20)
org.apache.jsp.lista_002dfunc_jsp._jspService(lista_002dfunc_jsp.java:87)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:433)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:389)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:333)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
[/code]
Class FuncionarioDao
[code]package test.dao;
import java.sql.Connection;
import java.sql.Date;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.List;
import javax.management.RuntimeErrorException;
import test.connection.ConnectionFactory;
public class FuncionarioDAO {
protected Connection connection;
public FuncionarioDAO(){
this.connection = new ConnectionFactory().getConnection();
}
public List<Funcionario> getLista(){
try{
List<Funcionario> funcs = new ArrayList<Funcionario>();
PreparedStatement stmt = this.connection.prepareStatement("select * from funcionario");
ResultSet rs= stmt.executeQuery();
while(rs.next()){
Funcionario func = new Funcionario();
func.setId(rs.getInt("id"));
func.setNome(rs.getString("nome"));
func.setEndereco(rs.getString("endereco"));
func.setEmail(rs.getString("email"));
Calendar data = Calendar.getInstance();
data.setTime(rs.getDate("dataNasc"));
func.setDataNasc(data);
funcs.add(func);
}
rs.close();
stmt.close();
return funcs;
}catch (SQLException e){
throw new RuntimeException(e);
}
}
}
[/code]