Pessoal,
Ja tentei de tudo para botar meu código para funcionar, mas eu não saio da página de HTTP ERRO 500.
Segue o código:
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<%@page import="br.com.caelum.modelo.Contato"%>
<%@page import="java.util.List"%>
<%@page import="br.com.caelum.jdbc.dao.ConsultaContatoDAO"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%@ taglib uri="http://displaytag.sf.net" prefix="display"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Consulta</title>
</head>
<body>
<c:import url="cabecalho.jsp" />
<%
ConsultaContatoDAO dao = new ConsultaContatoDAO();
List<Contato> lista = dao.getLista();
request.setAttribute("teste", lista);
%>
<display:table id ="data" name="teste">
<display:column property="id" title="ID" />
<display:column property="nome" title="Nome" />
<display:column property="email" title="Email" />
</display:table>
<c:import url="rodape.jsp" />
</body>
</html>package br.com.caelum.jdbc.dao;
import java.sql.Connection;
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 br.com.caelum.jdbc.ConnectionFactory;
import br.com.caelum.modelo.Contato;
public class ConsultaContatoDAO {
// a conexão com o banco de dados
private Connection connection;
private List<Contato> listaContato = new ArrayList<Contato>();
public ConsultaContatoDAO() {
this.connection = new ConnectionFactory().getConnection();
System.out.println("Conexão aberta!");
}
public List<Contato> getLista(){
String sql = ("select * from contatos");
try {
// cria um preparedStatement
PreparedStatement stmt = this.connection.prepareStatement(sql);
// executa um select
ResultSet retorno = stmt.executeQuery();
// inteno no ResultSet
while (retorno.next()) {
Contato contato = new Contato();
contato.setId(retorno.getLong("id"));
contato.setNome(retorno.getString("nome"));
contato.setEmail(retorno.getString("email"));
contato.setEndereco(retorno.getString("endereco"));
Calendar data = Calendar.getInstance();
data.setTime(retorno.getDate("dataNascimento"));
contato.setDataNascimento(data);
this.listaContato.add(contato);
}
// fecha ResultSet
retorno.close();
// fecha PreparedStatement
stmt.close();
// fecha conexao
this.connection.close();
System.out.println("\nPesquisa efetuada com sucesso!");
return this.listaContato;
} catch (SQLException e) {
throw new ExceptionDAO("Não foi possivel efetuar a consulta no banco de dados!!!", e);
}
}
public Contato index(int i){
return listaContato.get(i);
}
}Bom, eu importei o displaytag-1.2.jar, displaytag-export-poi-1.2.jar e displaytag-portlet-1.2.jar, tambem coloquei no classpath, ja fiz de tudo…
Ate mesmo nao sendo necessário, eu adicionei o taglibs no XML, tambem não deu em nada.
O eclipse reclama se eu mudo a uri do:
<%@ taglib uri=“http://displaytag.sf.net” prefix=“display”%>
Acho que isso prova que o caminho esta correto.
O log do meu console é:
Jan 30, 2012 10:20:24 PM org.apache.catalina.core.AprLifecycleListener init
Informações: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Program Files\Java\jre7\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\Program Files (x86)\AMD APP\bin\x86_64;C:\Program Files (x86)\AMD APP\bin\x86_64;C:\Program Files (x86)\AMD APP\bin\x86_64;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\ATI Technologies\ATI.ACE\Core-Static;C:\Program Files (x86)\Common Files\Roxio Shared\DLLShared\;C:\Program Files (x86)\Common Files\Roxio Shared\DLLShared\;C:\Program Files (x86)\Common Files\Roxio Shared\12.0\DLLShared\;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\;C:\xampp\ZendFramework-1.11.10\ZendFramework-1.11.10\bin;C:\xampp\php;C:\Program Files (x86)\QuickTime\QTSystem\;C:\Program Files\TortoiseSVN\bin;.
Jan 30, 2012 10:20:24 PM org.apache.tomcat.util.digester.SetPropertiesRule begin
Advertência: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.jee.server:fj21-agenda' did not find a matching property.
Jan 30, 2012 10:20:24 PM org.apache.coyote.http11.Http11Protocol init
Informações: Initializing Coyote HTTP/1.1 on http-8080
Jan 30, 2012 10:20:24 PM org.apache.catalina.startup.Catalina load
Informações: Initialization processed in 539 ms
Jan 30, 2012 10:20:24 PM org.apache.catalina.core.StandardService start
Informações: Starting service Catalina
Jan 30, 2012 10:20:24 PM org.apache.catalina.core.StandardEngine start
Informações: Starting Servlet Engine: Apache Tomcat/6.0.35
Jan 30, 2012 10:20:24 PM org.apache.catalina.startup.HostConfig deployDescriptor
Informações: Deploying configuration descriptor host-manager.xml
Jan 30, 2012 10:20:24 PM org.apache.catalina.startup.HostConfig deployDescriptor
Informações: Deploying configuration descriptor manager.xml
Jan 30, 2012 10:20:24 PM org.apache.catalina.startup.HostConfig deployDirectory
Informações: Deploying web application directory docs
Jan 30, 2012 10:20:24 PM org.apache.catalina.startup.HostConfig deployDirectory
Informações: Deploying web application directory examples
Jan 30, 2012 10:20:25 PM org.apache.catalina.core.ApplicationContext log
Informações: ContextListener: contextInitialized()
Jan 30, 2012 10:20:25 PM org.apache.catalina.core.ApplicationContext log
Informações: SessionListener: contextInitialized()
Jan 30, 2012 10:20:25 PM org.apache.catalina.startup.HostConfig deployDirectory
Informações: Deploying web application directory ROOT
Jan 30, 2012 10:20:25 PM org.apache.coyote.http11.Http11Protocol start
Informações: Starting Coyote HTTP/1.1 on http-8080
Jan 30, 2012 10:20:25 PM org.apache.jk.common.ChannelSocket init
Informações: JK: ajp13 listening on /0.0.0.0:8009
Jan 30, 2012 10:20:25 PM org.apache.jk.server.JkMain start
Informações: Jk running ID=0 time=0/20 config=null
Jan 30, 2012 10:20:25 PM org.apache.catalina.startup.Catalina start
Informações: Server startup in 606 ms
Jan 30, 2012 10:20:26 PM org.apache.catalina.core.StandardWrapperValve invoke
Grave: Servlet.service() for servlet jsp threw exception
java.lang.ClassNotFoundException: org.apache.commons.lang.UnhandledException
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1680)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1526)
at java.lang.Class.getDeclaredConstructors0(Native Method)
at java.lang.Class.privateGetDeclaredConstructors(Unknown Source)
at java.lang.Class.getConstructor0(Unknown Source)
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at com.sun.beans.finder.InstanceFinder.instantiate(Unknown Source)
at com.sun.beans.finder.InstanceFinder.find(Unknown Source)
at java.beans.Introspector.findExplicitBeanInfo(Unknown Source)
at java.beans.Introspector.<init>(Unknown Source)
at java.beans.Introspector.getBeanInfo(Unknown Source)
at org.apache.jasper.compiler.Generator$TagHandlerInfo.<init>(Generator.java:3909)
at org.apache.jasper.compiler.Generator$GenerateVisitor.getTagHandlerInfo(Generator.java:2174)
at org.apache.jasper.compiler.Generator$GenerateVisitor.visit(Generator.java:1632)
at org.apache.jasper.compiler.Node$CustomTag.accept(Node.java:1530)
at org.apache.jasper.compiler.Node$Nodes.visit(Node.java:2361)
at org.apache.jasper.compiler.Node$Visitor.visitBody(Node.java:2411)
at org.apache.jasper.compiler.Node$Visitor.visit(Node.java:2417)
at org.apache.jasper.compiler.Node$Root.accept(Node.java:495)
at org.apache.jasper.compiler.Node$Nodes.visit(Node.java:2361)
at org.apache.jasper.compiler.Generator.generate(Generator.java:3459)
at org.apache.jasper.compiler.Compiler.generateJava(Compiler.java:231)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:354)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:334)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:321)
at org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:592)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:328)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Unknown Source)
ja fui no google, digitei http 500 displaytag e fui em todas as procuras, nenhuma delas resolveu meu caso… alguem sabe o que posso estar fazendo de errado?
lembrando que os outros JSP estão funcionando perfeitamente.
muito grato desde ja.
