Problema IReport e JSF

475 views

Skip to first unread message

Murilo Misurini

unread,

Dec 12, 2013, 7:33:00 AM12/12/13

to jav...@googlegroups.com

Pessoal bom dia,

Estou postando esse tópico pq acho que no outro grupo relacionado acabou nao postando.

Estou tentando executar o Ireport no meu projeto JSF porém esta dando um erro cannot assign instance of net.sf.jasperreports.engine e já procurei em tudo mais nao consegui encontrar uma solução. Estou utilizando as bibliotecas:

jasperreports-4.0.1.jar,

itext-2.1.7.jar,

groovy-all-1.8.0.jar,

commons-logging-1.0.4.jar,

commons-digester-1.7.jar,

commons-collections-2.1.1.jar,

commons-beanutils-1.8.0.jar

O relatorio.jasper esta dentro da pasta Web-INF/relatorios/relatorio.jasper, gerei o relatorio no ireport dentro do eclipse e abrir o relatorio no Ireport instalado no pc e converti em .jasper.

Preciso da ajuda de voces. Agradeco desde ja.

Seguem os codigos:

BoxBean

package br.com.linkc.sistemaBaseJSF.bean;

import java.io.File;
import java.io.FileInputStream;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;

import javax.faces.application.FacesMessage;
import javax.faces.bean.ManagedBean;
import javax.faces.bean.ViewScoped;
import javax.faces.context.ExternalContext;
import javax.faces.context.FacesContext;
import javax.servlet.ServletContext;
import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServletResponse;

import net.sf.jasperreports.engine.JRDataSource;
import net.sf.jasperreports.engine.JasperRunManager;
import net.sf.jasperreports.engine.data.JRBeanCollectionDataSource;

import org.primefaces.context.RequestContext;

import br.com.linkc.sistemaBaseJSF.dao.DAO;
import br.com.linkc.sistemaBaseJSF.model.Box;

@ManagedBean
@ViewScoped
public class BoxBean 
{
	
	DAO<Box> dao = new DAO<Box>(Box.class);

	
	public void gerarRelatorio() 
	{
		 
		ExternalContext externalContext = FacesContext.getCurrentInstance().getExternalContext();
	    ServletContext context = (ServletContext) externalContext.getContext();
	    String arquivo = context.getRealPath("/WEB-INF/relatorios/RelatorioTicket.jasper");
	    JRDataSource jrds = new JRBeanCollectionDataSource(listarBox());
	 
	    gerarRelatorioWeb(jrds, null, arquivo);
	}
	 
	private void gerarRelatorioWeb(JRDataSource jrds, Map<Object, Object> parametros, String arquivo) 
	{
		ServletOutputStream servletOutputStream = null;
	    FacesContext context = FacesContext.getCurrentInstance();
	    HttpServletResponse response = (HttpServletResponse) context.getExternalContext().getResponse();
	 
	    try
	    {
	    	servletOutputStream = response.getOutputStream();
	        JasperRunManager.runReportToPdfStream((new FileInputStream(new File(arquivo))), 
	        		response.getOutputStream(), parametros, jrds);
	            	response.setContentType("application/pdf");
	            	servletOutputStream.flush();
	            	servletOutputStream.close();
	            	context.renderResponse();
	            	context.responseComplete();
	    } 
	        
	    catch (Exception e) 
	    {
	    	e.printStackTrace();
	    }
	    
	    }
	    
	
	
	public List<Box> listarBox() 
	{
		
		dao.buscarTicketeDocumento(Box.class);
		
		List<Box> boxes = new ArrayList<Box>();
		
		box.getTicket();
		box.getDocumento();
        boxes.add(box);

		return boxes;
    }

	public String getUsuario() {
		return usuario;
	}

	public void setUsuario(String usuario) {
		this.usuario = usuario;
	}

	public String getSenha() {
		return senha;
	}

	public void setSenha(String senha) {
		this.senha = senha;
	}

	private Box box = new Box();
	
	
	public Box getBox() {
		return box;
	}
	
}

DAO

package br.com.linkc.sistemaBaseJSF.dao;

import java.util.List;

import javax.faces.application.FacesMessage;
import javax.faces.context.FacesContext;
import javax.persistence.EntityManager;
import javax.persistence.criteria.CriteriaQuery;
import br.com.linkc.sistemaBaseJSF.model.Box;


public class DAO<T> {
	
	int ticket = 0000123242;

	private final Class<T> classe;

	public DAO(Class<T> classe) {
		this.classe = classe;
	}

	
	
	@SuppressWarnings({ "unchecked", "hiding" })
	public <T> List<Box> buscarTicket(Class<T> clazz, String ticket)
	{
		try
		{	
			
			EntityManager em = new JPAUtil().getEntityManager();
			try {
				StringBuffer hql = new StringBuffer();
				//hql.append("SELECT dataEntrada");
				hql.append("from " + clazz.getSimpleName());
				hql.append(" where ticket = " + ticket);
				return (List<Box>) em.createQuery(hql.toString()).getResultList();
			} finally {
				em.close();
			}
			
		}
		
		catch(Exception erro)
		{
			FacesContext.getCurrentInstance().addMessage("resultado",
					new FacesMessage("Não foi Encontrado Nenhum dado no Banco"));
			
		}
		
		return null;
		
		
	}
	
	@SuppressWarnings({ "unchecked", "hiding" })
	public <T> List<Box> buscarTicketeDocumento(Class<T> clazz)
	{
		try
		{	
			
			EntityManager em = new JPAUtil().getEntityManager();
			try {
				StringBuffer hql = new StringBuffer();
				//hql.append("SELECT dataEntrada");
				hql.append("from " + clazz.getSimpleName());
				hql.append(" where ticket = " + ticket );
				
				return (List<Box>) em.createQuery(hql.toString()).getResultList();
			} finally {
				em.close();
			}
			
		}
		
		catch(Exception erro)
		{
			FacesContext.getCurrentInstance().addMessage("resultado",
					new FacesMessage("Não foi Encontrado Nenhum dado no Banco"));
			
		}
		
		return null;
		
		
	}
	
	

}

JPAUtil

package br.com.linkc.sistemaBaseJSF.dao;

import javax.persistence.EntityManager;
import javax.persistence.EntityManagerFactory;
import javax.persistence.Persistence;

public class JPAUtil {

	private static EntityManagerFactory emf = Persistence
			.createEntityManagerFactory("SegJDataBase");

	public EntityManager getEntityManager() {
		return emf.createEntityManager();
	}

	public void close(EntityManager em) {
		em.close();
	}
}

Box

package br.com.linkc.sistemaBaseJSF.model;

import java.util.Date;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;



@Entity

public class Box {
	
	@Id
	@GeneratedValue
	private Integer id;
	@Column
	private Integer empresa;
	@Column
	private Integer patio;
	@Column
	private Integer vaga;
	@Column
	private Integer documento;
	@Column
	private String tipo;
	@Column
	private String ticket;
	@Column
	private Integer credenciado;
	@Column
	private String cartao;
	@Column
	private String placa;
	@Column
	private String modelo;
	@Column
	private Date dataEntrada;
	@Column
	private String terminalEntrada;
	@Column
	private String operadorEntrada;
	@Column
	private Date dataPagamento;
	@Column
	private Date quantidadePagamento;
	@Column
	private Date dataValidade;
	@Column
	private String conferencia;
	@Column
	private String prisma;
	@Column
	private Date dataValidadeCredenciado;
	@Column
	private String convenio;
	@Column
	private String ticketManobristaEntrada;
	@Column
	private String ticketManobristaSaida;
	
	public Box(){
		super();
	}

	public Box(Integer empresa, Integer patio, Integer vaga, Integer documento,
			String tipo, String ticket, Integer credenciado, String cartao,
			String placa, String modelo, Date dataEntrada,
			String terminalEntrada, String operadorEntrada, Date dataPagamento,
			Date quantidadePagamento, Date dataValidade, String conferencia,
			String prisma, Date dataValidadeCredenciado, String convenio,
			String ticketManobristaEntrada, String ticketManobristaSaida) {
		super();
		this.empresa = empresa;
		this.patio = patio;
		this.vaga = vaga;
		this.documento = documento;
		this.tipo = tipo;
		this.ticket = ticket;
		this.credenciado = credenciado;
		this.cartao = cartao;
		this.placa = placa;
		this.modelo = modelo;
		this.dataEntrada = dataEntrada;
		this.terminalEntrada = terminalEntrada;
		this.operadorEntrada = operadorEntrada;
		this.dataPagamento = dataPagamento;
		this.quantidadePagamento = quantidadePagamento;
		this.dataValidade = dataValidade;
		this.conferencia = conferencia;
		this.prisma = prisma;
		this.dataValidadeCredenciado = dataValidadeCredenciado;
		this.convenio = convenio;
		this.ticketManobristaEntrada = ticketManobristaEntrada;
		this.ticketManobristaSaida = ticketManobristaSaida;
	}

	public Integer getId() {
		return id;
	}

	public void setId(Integer id) {
		this.id = id;
	}

	public Integer getEmpresa() {
		return empresa;
	}

	public void setEmpresa(Integer empresa) {
		this.empresa = empresa;
	}

	public Integer getPatio() {
		return patio;
	}

	public void setPatio(Integer patio) {
		this.patio = patio;
	}

	public Integer getVaga() {
		return vaga;
	}

	public void setVaga(Integer vaga) {
		this.vaga = vaga;
	}

	public Integer getDocumento() {
		return documento;
	}

	public void setDocumento(Integer documento) {
		this.documento = documento;
	}

	public String getTipo() {
		return tipo;
	}

	public void setTipo(String tipo) {
		this.tipo = tipo;
	}

	public String getTicket() {
		return ticket;
	}

	public void setTicket(String ticket) {
		this.ticket = ticket;
	}

	public Integer getCredenciado() {
		return credenciado;
	}

	public void setCredenciado(Integer credenciado) {
		this.credenciado = credenciado;
	}

	public String getCartao() {
		return cartao;
	}

	public void setCartao(String cartao) {
		this.cartao = cartao;
	}

	public String getPlaca() {
		return placa;
	}

	public void setPlaca(String placa) {
		this.placa = placa;
	}

	public String getModelo() {
		return modelo;
	}

	public void setModelo(String modelo) {
		this.modelo = modelo;
	}

	public Date getDataEntrada() {
		return dataEntrada;
	}

	public void setDataEntrada(Date dataEntrada) {
		this.dataEntrada = dataEntrada;
	}

	public String getTerminalEntrada() {
		return terminalEntrada;
	}

	public void setTerminalEntrada(String terminalEntrada) {
		this.terminalEntrada = terminalEntrada;
	}

	public String getOperadorEntrada() {
		return operadorEntrada;
	}

	public void setOperadorEntrada(String operadorEntrada) {
		this.operadorEntrada = operadorEntrada;
	}

	public Date getDataPagamento() {
		return dataPagamento;
	}

	public void setDataPagamento(Date dataPagamento) {
		this.dataPagamento = dataPagamento;
	}

	public Date getQuantidadePagamento() {
		return quantidadePagamento;
	}

	public void setQuantidadePagamento(Date quantidadePagamento) {
		this.quantidadePagamento = quantidadePagamento;
	}

	public Date getDataValidade() {
		return dataValidade;
	}

	public void setDataValidade(Date dataValidade) {
		this.dataValidade = dataValidade;
	}

	public String getConferencia() {
		return conferencia;
	}

	public void setConferencia(String conferencia) {
		this.conferencia = conferencia;
	}

	public String getPrisma() {
		return prisma;
	}

	public void setPrisma(String prisma) {
		this.prisma = prisma;
	}

	public Date getDataValidadeCredenciado() {
		return dataValidadeCredenciado;
	}

	public void setDataValidadeCredenciado(Date dataValidadeCredenciado) {
		this.dataValidadeCredenciado = dataValidadeCredenciado;
	}

	public String getConvenio() {
		return convenio;
	}

	public void setConvenio(String convenio) {
		this.convenio = convenio;
	}

	public String getTicketManobristaEntrada() {
		return ticketManobristaEntrada;
	}

	public void setTicketManobristaEntrada(String ticketManobristaEntrada) {
		this.ticketManobristaEntrada = ticketManobristaEntrada;
	}

	public String getTicketManobristaSaida() {
		return ticketManobristaSaida;
	}

	public void setTicketManobristaSaida(String ticketManobristaSaida) {
		this.ticketManobristaSaida = ticketManobristaSaida;
	}
	
}

menu.xhtml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"
	xmlns:h="http://java.sun.com/jsf/html"
	xmlns:f="http://java.sun.com/jsf/core"
	xmlns:ui="http://java.sun.com/jsf/facelets"
	xmlns:p="http://primefaces.org/ui">

	<ui:composition template="_template.xhtml">

	<ui:define name="conteudo">
	<p:outputLabel id="olSaudacao" value="Seja Bem-Vindo" style="color:red; font-size:17px"/>
	<p:outputLabel value=" #{clienteBean.cliente.usuario}" style="color:black" for="olSaudacao"/>
	<br/>
	<br/>
	<br/>
		<p:commandButton value="Logoff" immediate="true" action="#{clienteBean.logoff()}"
			style="font-size: 10px; left: 1276px; color:white; background: #000000">
		</p:commandButton>
		<p:separator/>
	<br/>
		<!-- <p:growl autoUpdate="true"/> -->
		<p:panelMenu style="width:245px">  
			<p:submenu label="Menu Principal" style="font-size: 14px; text-align:left">    
    			<p:menuitem value="Buscar por Ticket" onclick="janela_BuscaporTicket.show()" url="#" 
    				icon="ui-icon-search"/>  
    			<p:menuitem value="Relatório PRESCON" onclick="janela_gerarRelatorios.show()" url="#" 
    				icon="ui-icon-document" />
    			<p:menuitem value="Item 3" url="/ui/tabMenuDocumentation.jsf" icon="ui-icon-document"/>  
    			<p:menuitem value="Item 4" url="/ui/tabMenuSupport.jsf" icon="ui-icon-wrench"/>  
    			<p:menuitem value="Item 5" url="/ui/tabMenuSocial.jsf" icon="ui-icon-person" />
    		</p:submenu>  
		</p:panelMenu>
		<h:form>
			<!-- <f:ajax event="blur"/> -->
			<p:dialog widgetVar="janela_BuscaporTicket" header="Busca por Ticket" modal="true" 
			          width="500" height="230">          
				<h:panelGrid columns="2">
					<p:outputLabel value="Número do Ticket: " for="num_ticket" style="font-size: 16px"/>
					<p:inputText id="num_ticket" value="#{boxBean.box.ticket}" required="true"
						style="font-size: 16px; height: 18px">
					<f:ajax event="blur"/>
					<p:clientValidator event="keyup"/>  	
					</p:inputText>
					<p:commandButton value="Buscar" action="#{boxBean.listarBoxes()}"
						style="height:35px; 
						font-size:16px" 
						type="button">
					<f:ajax execute="@form" render="@form :tabelaboxes"/>
					</p:commandButton>
				</h:panelGrid>
			</p:dialog>
		</h:form>
			<p:dialog widgetVar="janela_ResultadoBuscaTicket" update="messages" 
				header="Resultado da Busca" modal="true" 
		    	width="800" height="500">
		    	<p:messages id="messages" autoUpdate="true"  style="color:red"/>
				<p:dataTable value="#{boxBean.listarBoxes()}" var="boxes" id="tabelaboxes" 
					paginator="true" rows="4" emptyMessage="Nenhuma Informação Encontrada" 
					style="position:absolute; top:120px; right:300px">
					<p:column>
						<f:facet name="header">Ticket</f:facet>
						<h:outputText value="#{boxes.ticket}" />
					</p:column>
					<p:column>
						<f:facet name="header">Documento</f:facet>
						<h:outputText value="#{boxes.documento}" />
					</p:column>
				</p:dataTable>
			</p:dialog> 
			<p:dialog widgetVar="janela_gerarRelatorios" header="Relatório PRESCON" model="true" 
				widht="600px" height="100">
				<h:panelGrid columns="2">
					<p:commandButton value="Gerar Relatório" immediate="true" 
						action="#{boxBean.gerarRelatorio()}"
						style="height:35px; top:25px; left:25px; font-size:16px">
					</p:commandButton>
				</h:panelGrid>
			</p:dialog>
	</ui:define>
	</ui:composition>
</html>
			<!--  
				<p:dock position="top">  
    			<p:menuitem value="Busca por Ticket" icon="/resources/images/dock/busca1.png" 
    			                   url="document.getElementById(formMenu)"/>  
    			<p:menuitem value="Relatório Prescon" icon="/resources/images/dock/relatorio1.png" 
    			                   url="#"/>  
    			<p:menuitem value="Item 3" icon="/resources/images/dock/link.png" url="#"/>  
    			<p:menuitem value="Item 4" icon="/resources/images/dock/link.png" url="#"/>  
    			<p:menuitem value="Item 5" icon="/resources/images/dock/link.png" url="#"/>  
    			<p:menuitem value="Item 6" icon="/resources/images/dock/link.png" url="#"/>  
    			<p:menuitem value="Item 7" icon="/resources/images/dock/link.png" url="#"/>  
    			<p:menuitem value="Item 8" icon="/resources/images/dock/link.png" url="#"/>  
			</p:dock>
			-->

Erro:

Dez 12, 2013 10:16:27 AM 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/Java/jre7/bin/client;C:/Program Files/Java/jre7/bin;C:/Program Files/Java/jre7/lib/i386;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;c:\Program Files\Microsoft SQL Server\90\Tools\binn\;C:\Program Files\MySQL\MySQL Utilities 1.3.4\;C:\Users\murilo.misurini\Downloads\eclipse;;.
Dez 12, 2013 10:16:27 AM org.apache.tomcat.util.digester.SetPropertiesRule begin
Advertência: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.jee.server:SistemaBaseJSF' did not find a matching property.
Dez 12, 2013 10:16:27 AM org.apache.tomcat.util.digester.SetPropertiesRule begin
Advertência: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.jee.server:livraria' did not find a matching property.
Dez 12, 2013 10:16:27 AM org.apache.coyote.AbstractProtocol init
Informações: Initializing ProtocolHandler ["http-bio-8080"]
Dez 12, 2013 10:16:27 AM org.apache.coyote.AbstractProtocol init
Informações: Initializing ProtocolHandler ["ajp-bio-8009"]
Dez 12, 2013 10:16:27 AM org.apache.catalina.startup.Catalina load
Informações: Initialization processed in 354 ms
Dez 12, 2013 10:16:27 AM org.apache.catalina.core.StandardService startInternal
Informações: Starting service Catalina
Dez 12, 2013 10:16:27 AM org.apache.catalina.core.StandardEngine startInternal
Informações: Starting Servlet Engine: Apache Tomcat/7.0.42
Dez 12, 2013 10:16:30 AM com.sun.faces.config.ConfigureListener contextInitialized
Informações: Inicializando Mojarra 2.1.14 ( 20121023-1153) para o contexto '/SistemaBaseJSF'
Dez 12, 2013 10:16:30 AM com.sun.faces.spi.InjectionProviderFactory createInstance
Informações: JSF1048: Anotações PostConstruct/PreDestroy presentes.  Os métodos ManagedBeans marcados com essas anotações informarão as anotações processadas.
Dez 12, 2013 10:16:30 AM org.hibernate.validator.internal.util.Version <clinit>
INFO: HV000001: Hibernate Validator 4.3.0.Final
Dez 12, 2013 10:16:31 AM org.primefaces.webapp.PostConstructApplicationEventListener processEvent
Informações: Running on PrimeFaces 4.0
Dez 12, 2013 10:16:31 AM org.apache.coyote.AbstractProtocol start
Informações: Starting ProtocolHandler ["http-bio-8080"]
Dez 12, 2013 10:16:31 AM org.apache.coyote.AbstractProtocol start
Informações: Starting ProtocolHandler ["ajp-bio-8009"]
Dez 12, 2013 10:16:31 AM org.apache.catalina.startup.Catalina start
Informações: Server startup in 3474 ms
Dez 12, 2013 10:16:40 AM org.hibernate.annotations.common.Version <clinit>
INFO: HCANN000001: Hibernate Commons Annotations {4.0.1.Final}
Dez 12, 2013 10:16:40 AM org.hibernate.Version logVersion
INFO: HHH000412: Hibernate Core {4.1.8.Final}
Dez 12, 2013 10:16:40 AM org.hibernate.cfg.Environment <clinit>
INFO: HHH000206: hibernate.properties not found
Dez 12, 2013 10:16:40 AM org.hibernate.cfg.Environment buildBytecodeProvider
INFO: HHH000021: Bytecode provider name : javassist
Dez 12, 2013 10:16:40 AM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000402: Using Hibernate built-in connection pool (not for production use!)
Dez 12, 2013 10:16:40 AM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000115: Hibernate connection pool size: 20
Dez 12, 2013 10:16:40 AM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000006: Autocommit mode: true
Dez 12, 2013 10:16:40 AM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000401: using driver [net.sourceforge.jtds.jdbc.Driver] at URL [jdbc:jtds:sqlserver://localhost:1433/JPA;instance=SQLEXPRESS]
Dez 12, 2013 10:16:40 AM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000046: Connection properties: {user=Link, password=****, autocommit=true, release_mode=auto}
Dez 12, 2013 10:16:40 AM org.hibernate.dialect.Dialect <init>
INFO: HHH000400: Using dialect: org.hibernate.dialect.SQLServerDialect
Dez 12, 2013 10:16:40 AM org.hibernate.engine.jdbc.internal.LobCreatorBuilder useContextualLobCreation
INFO: HHH000423: Disabling contextual LOB creation as JDBC driver reported JDBC version [3] less than 4
Dez 12, 2013 10:16:40 AM org.hibernate.engine.transaction.internal.TransactionFactoryInitiator initiateService
INFO: HHH000268: Transaction strategy: org.hibernate.engine.transaction.internal.jdbc.JdbcTransactionFactory
Dez 12, 2013 10:16:40 AM org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory <init>
INFO: HHH000397: Using ASTQueryTranslatorFactory
Dez 12, 2013 10:16:40 AM org.hibernate.tool.hbm2ddl.SchemaUpdate execute
INFO: HHH000228: Running hbm2ddl schema update
Dez 12, 2013 10:16:40 AM org.hibernate.tool.hbm2ddl.SchemaUpdate execute
INFO: HHH000102: Fetching database metadata
Dez 12, 2013 10:16:40 AM org.hibernate.tool.hbm2ddl.SchemaUpdate execute
INFO: HHH000396: Updating schema
Dez 12, 2013 10:16:40 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO: HHH000261: Table found: JPA.dbo.Box
Dez 12, 2013 10:16:40 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO: HHH000037: Columns: [credenciado, terminalentrada, ticketmanobristaentrada, convenio, conferencia, datapagamento, cartao, patio, documento, dataentrada, id, quantidadepagamento, datavalidadecredenciado, vaga, datavalidade, ticketmanobristasaida, ticket, prisma, tipo, placa, empresa, operadorentrada, modelo]
Dez 12, 2013 10:16:40 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO: HHH000108: Foreign keys: []
Dez 12, 2013 10:16:40 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO: HHH000126: Indexes: [pk__box__09746778]
Dez 12, 2013 10:16:40 AM org.hibernate.tool.hbm2ddl.SchemaUpdate execute
INFO: HHH000232: Schema update complete
Hibernate: 
    select
        box0_.id as id0_,
        box0_.cartao as cartao0_,
        box0_.conferencia as conferen3_0_,
        box0_.convenio as convenio0_,
        box0_.credenciado as credenci5_0_,
        box0_.dataEntrada as dataEntr6_0_,
        box0_.dataPagamento as dataPaga7_0_,
        box0_.dataValidade as dataVali8_0_,
        box0_.dataValidadeCredenciado as dataVali9_0_,
        box0_.documento as documento0_,
        box0_.empresa as empresa0_,
        box0_.modelo as modelo0_,
        box0_.operadorEntrada as operado13_0_,
        box0_.patio as patio0_,
        box0_.placa as placa0_,
        box0_.prisma as prisma0_,
        box0_.quantidadePagamento as quantid17_0_,
        box0_.terminalEntrada as termina18_0_,
        box0_.ticket as ticket0_,
        box0_.ticketManobristaEntrada as ticketM20_0_,
        box0_.ticketManobristaSaida as ticketM21_0_,
        box0_.tipo as tipo0_,
        box0_.vaga as vaga0_ 
    from
        Box box0_ 
    where
        box0_.ticket=42658
java.lang.ClassCastException: cannot assign instance of net.sf.jasperreports.engine.base.JRBaseStyle to field net.sf.jasperreports.engine.base.JRBaseParagraph.paragraphContainer of type net.sf.jasperreports.engine.JRParagraphContainer in instance of net.sf.jasperreports.engine.base.JRBaseParagraph
	at java.io.ObjectStreamClass$FieldReflector.setObjFieldValues(Unknown Source)
	at java.io.ObjectStreamClass.setObjFieldValues(Unknown Source)
	at java.io.ObjectInputStream.defaultReadFields(Unknown Source)
	at java.io.ObjectInputStream.readSerialData(Unknown Source)
	at java.io.ObjectInputStream.readOrdinaryObject(Unknown Source)
	at java.io.ObjectInputStream.readObject0(Unknown Source)
	at java.io.ObjectInputStream.defaultReadFields(Unknown Source)
	at java.io.ObjectInputStream.defaultReadObject(Unknown Source)
	at net.sf.jasperreports.engine.base.JRBaseStyle.readObject(JRBaseStyle.java:1747)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at java.io.ObjectStreamClass.invokeReadObject(Unknown Source)
	at java.io.ObjectInputStream.readSerialData(Unknown Source)
	at java.io.ObjectInputStream.readOrdinaryObject(Unknown Source)
	at java.io.ObjectInputStream.readObject0(Unknown Source)
	at java.io.ObjectInputStream.readArray(Unknown Source)
	at java.io.ObjectInputStream.readObject0(Unknown Source)
	at java.io.ObjectInputStream.defaultReadFields(Unknown Source)
	at java.io.ObjectInputStream.defaultReadObject(Unknown Source)
	at net.sf.jasperreports.engine.base.JRBaseReport.readObject(JRBaseReport.java:823)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at java.io.ObjectStreamClass.invokeReadObject(Unknown Source)
	at java.io.ObjectInputStream.readSerialData(Unknown Source)
	at java.io.ObjectInputStream.readOrdinaryObject(Unknown Source)
	at java.io.ObjectInputStream.readObject0(Unknown Source)
	at java.io.ObjectInputStream.readObject(Unknown Source)
	at net.sf.jasperreports.engine.util.JRLoader.loadObject(JRLoader.java:201)
	at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:603)
	at net.sf.jasperreports.engine.JasperRunManager.runReportToPdfStream(JasperRunManager.java:370)
	at br.com.linkc.sistemaBaseJSF.bean.BoxBean.gerarRelatorioWeb(BoxBean.java:71)
	at br.com.linkc.sistemaBaseJSF.bean.BoxBean.gerarRelatorio(BoxBean.java:59)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.apache.el.parser.AstValue.invoke(AstValue.java:278)
	at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:274)
	at com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:105)
	at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:87)
	at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:101)
	at javax.faces.component.UICommand.broadcast(UICommand.java:315)
	at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:791)
	at javax.faces.component.UIViewRoot.processDecodes(UIViewRoot.java:932)
	at com.sun.faces.lifecycle.ApplyRequestValuesPhase.execute(ApplyRequestValuesPhase.java:78)
	at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
	at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
	at javax.faces.webapp.FacesServlet.service(FacesServlet.java:593)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)
Dez 12, 2013 10:16:41 AM com.sun.faces.application.view.FaceletViewHandlingStrategy handleRenderException
Grave: Error Rendering View[/menu.xhtml]
java.lang.IllegalStateException: getOutputStream() has already been called for this response
	at org.apache.catalina.connector.Response.getWriter(Response.java:638)
	at org.apache.catalina.connector.ResponseFacade.getWriter(ResponseFacade.java:214)
	at com.sun.faces.context.ExternalContextImpl.getResponseOutputWriter(ExternalContextImpl.java:765)
	at com.sun.faces.application.view.FaceletViewHandlingStrategy.createResponseWriter(FaceletViewHandlingStrategy.java:1053)
	at com.sun.faces.application.view.FaceletViewHandlingStrategy.renderView(FaceletViewHandlingStrategy.java:384)
	at com.sun.faces.application.view.MultiViewHandler.renderView(MultiViewHandler.java:124)
	at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:120)
	at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
	at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:139)
	at javax.faces.webapp.FacesServlet.service(FacesServlet.java:594)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)

Dez 12, 2013 10:16:41 AM org.apache.catalina.core.StandardWrapperValve invoke
Grave: Servlet.service() for servlet [Faces Servlet] in context with path [/SistemaBaseJSF] threw exception
java.lang.IllegalStateException: getOutputStream() has already been called for this response
	at org.apache.catalina.connector.Response.getWriter(Response.java:638)
	at org.apache.catalina.connector.ResponseFacade.getWriter(ResponseFacade.java:214)
	at com.sun.faces.context.ExternalContextImpl.getResponseOutputWriter(ExternalContextImpl.java:765)
	at com.sun.faces.context.PartialViewContextImpl.createPartialResponseWriter(PartialViewContextImpl.java:431)
	at com.sun.faces.context.PartialViewContextImpl.access$300(PartialViewContextImpl.java:71)
	at com.sun.faces.context.PartialViewContextImpl$DelayedInitPartialResponseWriter.getWrapped(PartialViewContextImpl.java:582)
	at javax.faces.context.PartialResponseWriter.startDocument(PartialResponseWriter.java:115)
	at org.primefaces.context.PrimePartialResponseWriter.startDocument(PrimePartialResponseWriter.java:134)
	at com.sun.faces.context.AjaxExceptionHandlerImpl.handlePartialResponseError(AjaxExceptionHandlerImpl.java:199)
	at com.sun.faces.context.AjaxExceptionHandlerImpl.handle(AjaxExceptionHandlerImpl.java:124)
	at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:119)
	at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:139)
	at javax.faces.webapp.FacesServlet.service(FacesServlet.java:594)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)

Gmail

unread,

Dec 12, 2013, 10:16:37 AM12/12/13

to jav...@googlegroups.com

Eu detectei uns problemas que no caso o seu .jasper teria que ficar no src, uma sugestão seria src/resources/relatorios/, porém você não precisa da biblioteca groovy, para não precisar dela basta mudar no ireports a linguagem do arquivo.jrxml, ai você muda para a linguagem java então você não vai mais precisar do groovy, testa se com essas mudanças se vai dar certo, pois não tem como o relatório ser visto no WEB-INF/relatorios/relatorio.jasper.

Att

Antonio Armando Filho Couto Bem

www.armandocouto.com.br

--
Você está recebendo esta mensagem porque se inscreveu no grupo "javasf: JavaServer Faces Group" dos Grupos do Google.
Para cancelar a inscrição neste grupo e parar de receber seus e-mails, envie um e-mail para javasf+un...@googlegroups.com.
Visite este grupo em http://groups.google.com/group/javasf.
Para ver esta discussão na web, acesse https://groups.google.com/d/msgid/javasf/e22df31b-82ec-4754-9986-33d11a2806eb%40googlegroups.com.
Para obter mais opções, acesse https://groups.google.com/groups/opt_out.

Murilo Misurini

unread,

Dec 12, 2013, 2:15:57 PM12/12/13

to jav...@googlegroups.com

Armando tentei mudar a localização do relatorio e acaba ocorrendo outro erro, de não conseguir localizar o relatorio.jasper, e quando coloco ele dentro de webcontent ele gera aquele mesmo erro, cannot assign, acredito que a localização do relatorio nao seja o problema e sim alguma conversao.

Levy Moreira

unread,

Dec 12, 2013, 2:25:52 PM12/12/13

to jav...@googlegroups.com

Use esse método para gerar o relatório: http://pastebin.com/GBYig0tF

Claro altere a suas necessidades.

E acredito que o motivo do erro é esse:

java.lang.IllegalStateException: getOutputStream() has already been called for this response

Veja: http://stackoverflow.com/questions/13682692/java-lang-illegalstateexception-getoutputstream-has-already-been-called-for-t

Murilo Misurini

unread,

Dec 13, 2013, 7:34:05 AM12/13/13

to jav...@googlegroups.com

Levy tentei desse jeito aconteceu o mesmo erro, segui outro tutorial e mudei o metodo, e ocorreu outro erro, acho que esta na classe,

public void gerarRelatorio(String localRelatorio, Map<String, Object> parametros , Collection<Box> lista) throws MalformedURLException{
             
             ExternalContext externalContext = FacesContext.getCurrentInstance().getExternalContext();
             ServletContext contextS = (ServletContext) externalContext.getContext();


             
             ServletOutputStream servletOutputStream = null;
             FacesContext context = FacesContext.getCurrentInstance();
             HttpServletResponse response = (HttpServletResponse) context.getExternalContext().getResponse();


             String arquivo = contextS.getRealPath("/resources/" + localRelatorio);
             
             try {
             
             servletOutputStream = response.getOutputStream();
             
             JasperRunManager.runReportToPdfStream(new FileInputStream(new File(arquivo)), response.getOutputStream(), parametros, new JRBeanCollectionDataSource(lista));


             
             response.setContentType("application/pdf");
             servletOutputStream.flush();
             servletOutputStream.close();
             context.renderResponse();
             context.responseComplete();


             
             } catch (JRException e) {
             e.printStackTrace();
             } catch (IOException e) {
             e.printStackTrace();
             }
             }
        
        public void gerarRelatorioParamentros() throws MalformedURLException{
            try{
                 
            Map<String, Object> parametros = new HashMap<String, Object>();
            parametros.put("REPORT_LOCALE", new Locale("pt", "BR"));
            //String nomeArquivoSaida = "Formulário";
            Collection<Box> lista= new ArrayList<Box>();
            dao.buscarTicketeDocumento(Box.class);
            box.getTicket();
            box.getDocumento();
            lista.add(box);
            gerarRelatorio("/relatorios/RelatorioTicket.jasper", parametros, lista);
            }catch(Exception e){
            
            }
            
            }

Erro:

Digite o código aqui...Dez 13, 2013 10:26:18 AM 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/Java/jre7/bin/client;C:/Program Files/Java/jre7/bin;C:/Program Files/Java/jre7/lib/i386;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;c:\Program Files\Microsoft SQL Server\90\Tools\binn\;C:\Program Files\MySQL\MySQL Utilities 1.3.4\;C:\Users\murilo.misurini\Downloads\eclipse;;.

Dez 13, 2013 10:26:18 AM org.apache.tomcat.util.digester.SetPropertiesRule begin


Advertência: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.jee.server:SistemaBaseJSF' did not find a matching property.

Dez 13, 2013 10:26:18 AM org.apache.tomcat.util.digester.SetPropertiesRule begin


Advertência: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.jee.server:livraria' did not find a matching property.

Dez 13, 2013 10:26:18 AM org.apache.coyote.AbstractProtocol init
Informações: Initializing ProtocolHandler ["http-bio-8080"]
Dez 13, 2013 10:26:18 AM org.apache.coyote.AbstractProtocol init
Informações: Initializing ProtocolHandler ["ajp-bio-8009"]
Dez 13, 2013 10:26:18 AM org.apache.catalina.startup.Catalina load
Informações: Initialization processed in 382 ms
Dez 13, 2013 10:26:18 AM org.apache.catalina.core.StandardService startInternal
Informações: Starting service Catalina
Dez 13, 2013 10:26:18 AM org.apache.catalina.core.StandardEngine startInternal

Informações: Starting Servlet Engine: Apache Tomcat/7.0.42

Dez 13, 2013 10:26:21 AM com.sun.faces.config.ConfigureListener contextInitialized

Informações: Inicializando Mojarra 2.1.14 ( 20121023-1153) para o contexto '/SistemaBaseJSF'

Dez 13, 2013 10:26:21 AM com.sun.faces.spi.InjectionProviderFactory createInstance

Informações: JSF1048: Anotações PostConstruct/PreDestroy presentes.  Os métodos ManagedBeans marcados com essas anotações informarão as anotações processadas.

Dez 13, 2013 10:26:22 AM org.hibernate.validator.internal.util.Version <clinit>


INFO: HV000001: Hibernate Validator 4.3.0.Final

Dez 13, 2013 10:26:22 AM org.primefaces.webapp.PostConstructApplicationEventListener processEvent

Informações: Running on PrimeFaces 4.0

Dez 13, 2013 10:26:22 AM org.apache.coyote.AbstractProtocol start
Informações: Starting ProtocolHandler ["http-bio-8080"]
Dez 13, 2013 10:26:22 AM org.apache.coyote.AbstractProtocol start
Informações: Starting ProtocolHandler ["ajp-bio-8009"]
Dez 13, 2013 10:26:22 AM org.apache.catalina.startup.Catalina start
Informações: Server startup in 3853 ms
Dez 13, 2013 10:26:27 AM org.hibernate.annotations.common.Version <clinit>


INFO: HCANN000001: Hibernate Commons Annotations {4.0.1.Final}

Dez 13, 2013 10:26:27 AM org.hibernate.Version logVersion
INFO: HHH000412: Hibernate Core {4.1.8.Final}
Dez 13, 2013 10:26:27 AM org.hibernate.cfg.Environment <clinit>


INFO: HHH000206: hibernate.properties not found

Dez 13, 2013 10:26:27 AM org.hibernate.cfg.Environment buildBytecodeProvider
INFO: HHH000021: Bytecode provider name : javassist
Dez 13, 2013 10:26:28 AM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000402: Using Hibernate built-in connection pool (not for production use!)
Dez 13, 2013 10:26:28 AM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000115: Hibernate connection pool size: 20
Dez 13, 2013 10:26:28 AM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000006: Autocommit mode: true
Dez 13, 2013 10:26:28 AM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000401: using driver [net.sourceforge.jtds.jdbc.Driver] at URL [jdbc:jtds:sqlserver://localhost:1433/JPA;instance=SQLEXPRESS]
Dez 13, 2013 10:26:28 AM org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000046: Connection properties: {user=Link, password=****, autocommit=true, release_mode=auto}
Dez 13, 2013 10:26:28 AM org.hibernate.dialect.Dialect <init>


INFO: HHH000400: Using dialect: org.hibernate.dialect.SQLServerDialect

Dez 13, 2013 10:26:28 AM org.hibernate.engine.jdbc.internal.LobCreatorBuilder useContextualLobCreation
INFO: HHH000423: Disabling contextual LOB creation as JDBC driver reported JDBC version [3] less than 4
Dez 13, 2013 10:26:28 AM org.hibernate.engine.transaction.internal.TransactionFactoryInitiator initiateService
INFO: HHH000268: Transaction strategy: org.hibernate.engine.transaction.internal.jdbc.JdbcTransactionFactory
Dez 13, 2013 10:26:28 AM org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory <init>
INFO: HHH000397: Using ASTQueryTranslatorFactory
Dez 13, 2013 10:26:28 AM org.hibernate.tool.hbm2ddl.SchemaUpdate execute
INFO: HHH000228: Running hbm2ddl schema update
Dez 13, 2013 10:26:28 AM org.hibernate.tool.hbm2ddl.SchemaUpdate execute
INFO: HHH000102: Fetching database metadata
Dez 13, 2013 10:26:28 AM org.hibernate.tool.hbm2ddl.SchemaUpdate execute
INFO: HHH000396: Updating schema
Dez 13, 2013 10:26:28 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>


INFO: HHH000261: Table found: JPA.dbo.Box

Dez 13, 2013 10:26:28 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>


INFO: HHH000037: Columns: [credenciado, terminalentrada, ticketmanobristaentrada, convenio, conferencia, datapagamento, cartao, patio, documento, dataentrada, id, quantidadepagamento, datavalidadecredenciado, vaga, datavalidade, ticketmanobristasaida, ticket, prisma, tipo, placa, empresa, operadorentrada, modelo]

Dez 13, 2013 10:26:28 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO: HHH000108: Foreign keys: []
Dez 13, 2013 10:26:28 AM org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO: HHH000126: Indexes: [pk__box__09746778]
Dez 13, 2013 10:26:28 AM org.hibernate.tool.hbm2ddl.SchemaUpdate execute
INFO: HHH000232: Schema update complete

Dez 13, 2013 10:26:29 AM com.sun.faces.lifecycle.ApplyRequestValuesPhase execute
Advertência: #{boxBean.gerarRelatorioParamentros()}: java.lang.ExceptionInInitializerError
javax.faces.FacesException: #{boxBean.gerarRelatorioParamentros()}: java.lang.ExceptionInInitializerError
    at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:117)


    at javax.faces.component.UICommand.broadcast(UICommand.java:315)
    at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:791)
    at javax.faces.component.UIViewRoot.processDecodes(UIViewRoot.java:932)
    at com.sun.faces.lifecycle.ApplyRequestValuesPhase.execute(ApplyRequestValuesPhase.java:78)
    at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
    at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
    at javax.faces.webapp.FacesServlet.service(FacesServlet.java:593)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
    at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)

Caused by: javax.faces.el.EvaluationException: java.lang.ExceptionInInitializerError
    at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:101)
    at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:101)
    ... 23 more
Caused by: java.lang.ExceptionInInitializerError
    at net.sf.jasperreports.engine.fill.JRBaseFiller.<init>(JRBaseFiller.java:121)
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.<init>(JRVerticalFiller.java:88)
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.<init>(JRVerticalFiller.java:103)
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.<init>(JRVerticalFiller.java:61)
    at net.sf.jasperreports.engine.fill.JRFiller.createFiller(JRFiller.java:153)
    at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:82)
    at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:653)
    at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:634)
    at net.sf.jasperreports.engine.JasperRunManager.runToPdfStream(JasperRunManager.java:428)
    at net.sf.jasperreports.engine.JasperRunManager.runReportToPdfStream(JasperRunManager.java:849)
    at br.com.linkc.sistemaBaseJSF.bean.BoxBean.gerarRelatorio(BoxBean.java:71)
    at br.com.linkc.sistemaBaseJSF.bean.BoxBean.gerarRelatorioParamentros(BoxBean.java:97)


    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.apache.el.parser.AstValue.invoke(AstValue.java:278)
    at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:274)
    at com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:105)
    at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:87)


    ... 24 more
Caused by: net.sf.jasperreports.engine.util.JRFontNotFoundException: Font '
            net/sf/jasperreports/fonts/pictonic/pictonic.ttf
            net/sf/jasperreports/fonts/pictonic/pictonic.svg
            net/sf/jasperreports/fonts/pictonic/pictonic.eot
            net/sf/jasperreports/fonts/pictonic/pictonic.woff
        ' is not available to the JVM. See the Javadoc for more details.
    at net.sf.jasperreports.engine.fonts.FontUtil.checkAwtFont(FontUtil.java:344)
    at net.sf.jasperreports.engine.fonts.SimpleFontFace.getInstance(SimpleFontFace.java:71)
    at net.sf.jasperreports.engine.fonts.SimpleFontFamily.setNormal(SimpleFontFamily.java:99)
    at net.sf.jasperreports.engine.fonts.SimpleFontExtensionHelper.parseFontFamily(SimpleFontExtensionHelper.java:261)
    at net.sf.jasperreports.engine.fonts.SimpleFontExtensionHelper.parseFontFamilies(SimpleFontExtensionHelper.java:232)
    at net.sf.jasperreports.engine.fonts.SimpleFontExtensionHelper.loadFontFamilies(SimpleFontExtensionHelper.java:193)
    at net.sf.jasperreports.engine.fonts.SimpleFontExtensionHelper.loadFontFamilies(SimpleFontExtensionHelper.java:162)
    at net.sf.jasperreports.engine.fonts.FontExtensionsRegistry.getExtensions(FontExtensionsRegistry.java:56)
    at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.getExtensions(DefaultExtensionsRegistry.java:110)
    at net.sf.jasperreports.engine.util.JRStyledTextParser.<clinit>(JRStyledTextParser.java:83)
    ... 44 more

Dez 13, 2013 10:26:29 AM org.apache.catalina.core.StandardWrapperValve invoke

Grave: Servlet.service() for servlet [Faces Servlet] in context with path [/SistemaBaseJSF] threw exception
java.lang.IllegalStateException: getOutputStream() has already been called for this response
    at org.apache.catalina.connector.Response.getWriter(Response.java:638)
    at org.apache.catalina.connector.ResponseFacade.getWriter(ResponseFacade.java:214)
    at com.sun.faces.context.ExternalContextImpl.getResponseOutputWriter(ExternalContextImpl.java:765)
    at com.sun.faces.context.PartialViewContextImpl.createPartialResponseWriter(PartialViewContextImpl.java:431)
    at com.sun.faces.context.PartialViewContextImpl.access$300(PartialViewContextImpl.java:71)
    at com.sun.faces.context.PartialViewContextImpl$DelayedInitPartialResponseWriter.getWrapped(PartialViewContextImpl.java:582)
    at javax.faces.context.PartialResponseWriter.startDocument(PartialResponseWriter.java:115)
    at org.primefaces.context.PrimePartialResponseWriter.startDocument(PrimePartialResponseWriter.java:134)
    at com.sun.faces.context.AjaxExceptionHandlerImpl.handlePartialResponseError(AjaxExceptionHandlerImpl.java:199)
    at com.sun.faces.context.AjaxExceptionHandlerImpl.handle(AjaxExceptionHandlerImpl.java:124)
    at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:119)

Levy Moreira

unread,

Dec 13, 2013, 8:07:26 AM12/13/13

to jav...@googlegroups.com

Esse erro de fonte faz o seguinte, vai na tua pasta lib, abre o jasperreports-x.x.x.jar com o winrar, abre o arquivo
default.jasperreports.properties

na linha
net.sf.jasperreports.awt.ignore.missing.font=false

troque por
net.sf.jasperreports.awt.ignore.missing.font=true

salve, faça um clean no tomcat, refresh no projeto e testa novamente.

When set to false, it forces the engine to check if the font used as value for the fontName attribute inside the report template is available either through the JasperReports font extension mechanism or as a JVM accesible font, and raise a JRFontNotFoundException exception, if this font is not available.

Veja que JRFontNotFoundException é exatamente seu erro :)

Isso ocorre muito quando eu programo em um SO e coloco o war em outro, tipo Windows -> CentOS = JRFontNotFoundException

http://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.awt.ignore.missing.font

ayslan

unread,

Dec 13, 2013, 8:10:19 AM12/13/13

to jav...@googlegroups.com

Levy, não precisa abrir o jar do jasperreports, dentro do próprio projeto, no root do seus fontes java, basta criar o arquivo jasperreports.properties e adicionar a propriedade:

net.sf.jasperreports.awt.ignore.missing.font=true

--
Você está recebendo esta mensagem porque se inscreveu no grupo "javasf: JavaServer Faces Group" dos Grupos do Google.
Para cancelar a inscrição neste grupo e parar de receber seus e-mails, envie um e-mail para javasf+un...@googlegroups.com.
Visite este grupo em http://groups.google.com/group/javasf.

Para ver esta discussão na web, acesse https://groups.google.com/d/msgid/javasf/CAAE4DfqSAi0GMSEEBJcoD74whWRy97sp%3D9UgGrv3mWjrMt5hyQ%40mail.gmail.com.

Para obter mais opções, acesse https://groups.google.com/groups/opt_out.

--
Att,

Ayslan M. de Sousa

Levy Moreira

unread,

Dec 13, 2013, 8:52:19 AM12/13/13

to jav...@googlegroups.com

Show, essa não sabia vou testar.

Murilo Misurini

unread,

Dec 16, 2013, 10:34:41 AM12/16/13

to jav...@googlegroups.com

Digite o código aqui...

Pessoal o problema estava nas versoes dos jar, gerei o relatorio no eclipse na versao 5.5.0 e coloquei as versoes do grove-all 2.0.1 e tambem jasperreports na 5.5.0. Esta gerando o pdf do relatorio, só que não esta carregando os dados do banco, esta indo tudo null, sendo que tem um metodo que retorna uma lista.

Seguem os codigos:

Classe Boxbean

public String generatePDF() throws JRException, IOException {
			 JRBeanCollectionDataSource beanCollectionDataSource = new JRBeanCollectionDataSource(
			 dao.buscarTicketeDocumento(Box.class));
			 HttpServletResponse httpServletResponse = (HttpServletResponse) FacesContext
					 .getCurrentInstance().getExternalContext().getResponse();
			 httpServletResponse.addHeader("Content-disposition","attachment; filename=report.pdf");
			 
			 ExternalContext externalContext = FacesContext.getCurrentInstance()
			 .getExternalContext();
			 
			ServletContext servletContext = (ServletContext) externalContext
			 .getContext();
			 
			 ServletOutputStream servletOutputStream = httpServletResponse
			 .getOutputStream();
			 
			 String reportPath = servletContext
			 .getRealPath("WEB-INF/relatorios/relatorioTicket.jasper");
			 
			 @SuppressWarnings({ "rawtypes", "unchecked" })
			 JasperPrint jasperPrint = JasperFillManager.fillReport(reportPath, new HashMap(),
			 beanCollectionDataSource);
			 byte[] bytes = JasperExportManager.exportReportToPdf(jasperPrint);
			 
			 httpServletResponse.setContentLength(bytes.length);
			 httpServletResponse.getOutputStream().write(bytes, 0, bytes.length);
			 httpServletResponse.getOutputStream().flush();
			 httpServletResponse.getOutputStream().close();
			 FacesContext.getCurrentInstance().responseComplete();
			 JasperExportManager.exportReportToPdfStream(jasperPrint,
					 servletOutputStream);
			JasperExportManager.exportReportToPdfFile(jasperPrint, "report.pdf");
			FacesContext.getCurrentInstance().responseComplete();
			
			return null;
			 
			 
			}

Classe Box:

Classe DAO

@SuppressWarnings({ "unchecked", "hiding" })
	public <T> List<Box> buscarTicketeDocumento(Class<T> clazz)
	{
		try
		{	
			
			EntityManager em = new JPAUtil().getEntityManager();
			try {
				StringBuffer hql = new StringBuffer();
				//hql.append("SELECT dataEntrada");
				hql.append("from " + clazz.getSimpleName());

//hql.append(" where ticket = " + ticket );

				
				return (List<Box>) em.createQuery(hql.toString()).getResultList();
			} finally {
				em.close();
			}
			
		}

Erro:

Dez 16, 2013 1:33:25 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/Java/jre7/bin/client;C:/Program Files/Java/jre7/bin;C:/Program Files/Java/jre7/lib/i386;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;c:\Program Files\Microsoft SQL Server\90\Tools\binn\;C:\Program Files\MySQL\MySQL Utilities 1.3.4\;C:\Users\murilo.misurini\Downloads\eclipse;;.

Dez 16, 2013 1:33:25 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:SistemaBaseJSF' did not find a matching property.

Dez 16, 2013 1:33:25 PM org.apache.coyote.AbstractProtocol init
Informações: Initializing ProtocolHandler ["http-bio-8080"]
Dez 16, 2013 1:33:25 PM org.apache.coyote.AbstractProtocol init
Informações: Initializing ProtocolHandler ["ajp-bio-8009"]
Dez 16, 2013 1:33:25 PM org.apache.catalina.startup.Catalina load
Informações: Initialization processed in 360 ms
Dez 16, 2013 1:33:25 PM org.apache.catalina.core.StandardService startInternal
Informações: Starting service Catalina
Dez 16, 2013 1:33:25 PM org.apache.catalina.core.StandardEngine startInternal

Informações: Starting Servlet Engine: Apache Tomcat/7.0.42

Dez 16, 2013 1:33:28 PM com.sun.faces.config.ConfigureListener contextInitialized

Informações: Inicializando Mojarra 2.1.14 ( 20121023-1153) para o contexto '/SistemaBaseJSF'

Dez 16, 2013 1:33:28 PM com.sun.faces.spi.InjectionProviderFactory createInstance

Informações: JSF1048: Anotações PostConstruct/PreDestroy presentes.  Os métodos ManagedBeans marcados com essas anotações informarão as anotações processadas.

Dez 16, 2013 1:33:29 PM org.hibernate.validator.internal.util.Version <clinit>

INFO: HV000001: Hibernate Validator 4.3.0.Final

Dez 16, 2013 1:33:29 PM org.primefaces.webapp.PostConstructApplicationEventListener processEvent

Informações: Running on PrimeFaces 4.0

Dez 16, 2013 1:33:29 PM org.apache.coyote.AbstractProtocol start
Informações: Starting ProtocolHandler ["http-bio-8080"]
Dez 16, 2013 1:33:29 PM org.apache.coyote.AbstractProtocol start
Informações: Starting ProtocolHandler ["ajp-bio-8009"]
Dez 16, 2013 1:33:29 PM org.apache.catalina.startup.Catalina start
Informações: Server startup in 3548 ms
Dez 16, 2013 1:33:42 PM org.hibernate.annotations.common.Version <clinit>

INFO: HCANN000001: Hibernate Commons Annotations {4.0.1.Final}

Dez 16, 2013 1:33:42 PM org.hibernate.Version logVersion

INFO: HHH000412: Hibernate Core {4.1.8.Final}

Dez 16, 2013 1:33:42 PM org.hibernate.cfg.Environment <clinit>

INFO: HHH000206: hibernate.properties not found

Dez 16, 2013 1:33:42 PM org.hibernate.cfg.Environment buildBytecodeProvider

INFO: HHH000021: Bytecode provider name : javassist