Problema em trazer uma lista usando persistência

Criei um metodo no DAO para fazer a persistência na tabela presenca, e um Bean que faz uma verificação e validação trazendo a lista.
Contudo ao chamar o xhtml para popular a minha tabela, da um erro! Que não consegui corrigir.

Esse é o DAO.

public List&lt;Object[]&gt; BuscarTodos() {
		EntityManager em = new JPAUtil().getEntityManager();
		Query query = em.createNativeQuery("SELECT * FROM presenca p");
		List&lt;Object[]&gt; lista = query.getResultList();
		em.close();
		return lista;
	}

Esse é o;

@SessionScoped
@ManagedBean
public class PresencaBean {

	private Presenca presenca = new Presenca();

	private List&lt;Object[]&gt; lista;

	private List&lt;Presenca&gt; periodos;

	private List&lt;Presenca&gt; ufs;
	
	public List&lt;Object[]&gt; getLista() {
		
		if (lista == null) {
			System.out.println("Carregando as presenças...");
			lista = new PresencaDAO&lt;Presenca&gt;(Presenca.class).BuscarTodos();
		}
		
		return lista;
	}

&lt;?xml version="1.0" encoding="ISO-8859-1" ?&gt;
&lt;!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"&gt;
&lt;html xmlns="http://www.w3.org/1999/xhtml"
	xmlns:ui="http://java.sun.com/jsf/facelets"
	xmlns:f="http://java.sun.com/jsf/core"
	xmlns:h="http://java.sun.com/jsf/html"
	xmlns:p="http://primefaces.org/ui"&gt;

&lt;ui:composition template="/_template.xhtml"&gt;
	&lt;ui:define name="corpo"&gt;
		&lt;h:form&gt;
			&lt;p:toolbar&gt;
				&lt;p:toolbarGroup align="left"&gt;

					&lt;p:selectOneMenu effect="fold" var="p" value="#{presencaBean.ufs}"&gt;
						&lt;f:selectItems value="#{presencaBean.ufs}" /&gt;
					&lt;/p:selectOneMenu&gt;

					&lt;samp&gt;&lt;/samp&gt;

					&lt;p:selectOneMenu value="#{presencaBean.periodos}" effect="fold"&gt;
						&lt;f:selectItems value="#{presencaBean.periodos}" /&gt;
					&lt;/p:selectOneMenu&gt;

					&lt;samp&gt;&lt;/samp&gt;

					&lt;p:selectOneMenu label="Periodo" effect="fold"&gt;
						&lt;f:selectItems itemLabel="Periodo" /&gt;
					&lt;/p:selectOneMenu&gt;

				&lt;/p:toolbarGroup&gt;
			&lt;/p:toolbar&gt;
		&lt;/h:form&gt;

		&lt;h:form&gt;
			&lt;h3 align="center"&gt;Presenca dos Bancos nos Municípios&lt;/h3&gt;

			&lt;p:dataTable id="basic" var="listas"
				value="{presencaBean.lista}" rows="5"&gt;
				&lt;p:column headerText="Instituição"&gt;
						#{listas[2]}					
				&lt;/p:column&gt;

				&lt;p:column headerText="Assisitidas"&gt;
							#{listas[3]}			
				&lt;/p:column&gt;

				&lt;p:column headerText="Desassistidas"&gt;
							#{listas[4]}	
				&lt;/p:column&gt;

			&lt;/p:dataTable&gt;

		&lt;/h:form&gt;

	&lt;/ui:define&gt;
&lt;/ui:composition&gt;
&lt;/html&gt;

Esse é o erro!

SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
Hibernate: 
    /* dynamic native SQL query */ SELECT
        DISTINCT presenca.UF 
    FROM
        presenca 
    WHERE
        presenca.UF &lt;&gt; 'BR' 
        AND  presenca.UF &lt;&gt; 'CO' 
        AND presenca.UF &lt;&gt; 'N' 
        AND presenca.UF &lt;&gt; 'NE' 
        AND presenca.UF &lt;&gt; 'S' 
        AND presenca.UF &lt;&gt; ' SD'
AC
Carregando as periodos...
Hibernate: 
    /* dynamic native SQL query */ SELECT
        periodo 
    FROM
        presenca 
    GROUP BY
        periodo 
    ORDER BY
        periodo desc
201204
Mai 31, 2012 3:27:25 PM org.apache.catalina.core.StandardWrapperValve invoke
Grave: Servlet.service() for servlet [Faces Servlet] in context with path [/canais] threw exception [javax/servlet/jsp/jstl/sql/Result] with root cause
java.lang.ClassNotFoundException: javax.servlet.jsp.jstl.sql.Result
	at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1688)
	at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1533)
	at javax.faces.component.UIData.getDataModel(UIData.java:1308)
	at javax.faces.component.UIData.getRowCount(UIData.java:342)
	at org.primefaces.component.datatable.DataTableRenderer.encodeTbody(DataTableRenderer.java:602)
	at org.primefaces.component.datatable.DataTableRenderer.encodeRegularTable(DataTableRenderer.java:248)

1 Resposta

Topicos relacionados