JSP + IReport

ConexaoDB conex = new ConexaoDB();
conex.iniciarConexao("jdbc:sqlserver://TECNOARTE-SRV01:1433;databasename=ADMDB");
String query = "SELECT * FROM Asa_Atendimento";
PreparedStatement comando1=conex.getCon().prepareStatement(query);
String relanome = "D:/SGV/RegistroDeAtendimento.jasper"; 
ResultSet rs1=comando1.executeQuery();
JRResultSetDataSource jrRS = new JRResultSetDataSource( rs1 );
Map parameters = new HashMap();
// parameters.put("COLUNA", valor);
JasperPrint jasperPrint = JasperFillManager.fillReport(relanome, parameters,conex.getCon()); 
JasperViewer.viewReport(jasperPrint);   
JasperFillManager.fillReportToFile( relanome, parameters, jrRS );
JasperExportManager.exportReportToPdfFile( "RegistroDeAtendimento.jrprint" );
JasperViewer.viewReport( "RegistroDeAtendimento.pdf", false );
conex.fecharConexao();
}

3/11/2008 17:22:24 com.sun.faces.lifecycle.LifecycleImpl phase

WARNING: executePhase(RENDER_RESPONSE 6,com.sun.faces.context.FacesContextImpl@187aa9e) threw exception

com.sun.rave.web.ui.appbase.ApplicationException: #{Atendimento_brw.btnImprime_action}: java.lang.NoClassDefFoundError: org/apache/commons/javaflow/bytecode/Continuable

at com.sun.rave.web.ui.appbase.faces.ViewHandlerImpl.cleanup(ViewHandlerImpl.java:594)

at com.sun.rave.web.ui.appbase.faces.ViewHandlerImpl.renderView(ViewHandlerImpl.java:311)

at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:106)

at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:251)

at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:144)

at com.sun.faces.extensions.avatar.lifecycle.PartialTraversalLifecycle.render(PartialTraversalLifecycle.java:106)

at javax.faces.webapp.FacesServlet.service(FacesServlet.java:245)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at com.sun.webui.jsf.util.UploadFilter.doFilter(UploadFilter.java:267)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:390)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

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:175)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)

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:286)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)

at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)

at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)

at java.lang.Thread.run(Thread.java:619)

Caused by: javax.faces.FacesException: #{Atendimento_brw.btnImprime_action}: java.lang.NoClassDefFoundError: org/apache/commons/javaflow/bytecode/Continuable

at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:107)

at com.sun.rave.web.ui.appbase.faces.ActionListenerImpl.processAction(ActionListenerImpl.java:91)

at javax.faces.component.UICommand.broadcast(UICommand.java:383)

at com.sun.webui.jsf.component.WebuiCommand.broadcast(WebuiCommand.java:160)

at com.sun.webui.jsf.component.TableRowGroupBase.broadcast(TableRowGroupBase.java:1402)

at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:447)

at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:752)

at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:97)

at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:251)

at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:117)

at com.sun.faces.extensions.avatar.lifecycle.PartialTraversalLifecycle.execute(PartialTraversalLifecycle.java:94)

at javax.faces.webapp.FacesServlet.service(FacesServlet.java:244)

… 18 more

Caused by: javax.faces.el.EvaluationException: java.lang.NoClassDefFoundError: org/apache/commons/javaflow/bytecode/Continuable

at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:91)

at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:91)

… 29 more

Caused by: java.lang.NoClassDefFoundError: org/apache/commons/javaflow/bytecode/Continuable

at java.lang.ClassLoader.defineClass1(Native Method)

at java.lang.ClassLoader.defineClass(ClassLoader.java:621)

at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:124)

at org.apache.catalina.loader.WebappClassLoader.findClassInternal(WebappClassLoader.java:1819)

at org.apache.catalina.loader.WebappClassLoader.findClass(WebappClassLoader.java:872)

at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1327)

at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1206)

at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)

at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:402)

at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:234)

at sgv.Atendimento_brw.geraRelatorio(Atendimento_brw.java:181)

at sgv.Atendimento_brw.btnImprime_action(Atendimento_brw.java:160)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at org.apache.el.parser.AstValue.invoke(AstValue.java:152)

at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276)

at org.apache.jasper.el.JspMethodExpression.invoke(JspMethodExpression.java:68)

at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:77)

… 30 more

Caused by: java.lang.ClassNotFoundException: org.apache.commons.javaflow.bytecode.Continuable

at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1360)

at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1206)

at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)

… 50 more

import br.com.sistema.DAO.Conexao;  // Essa classe só tem 2 métodos (abrirConexao()  e fecharConexao())

import java.io.File;
import java.sql.Connection;
import java.util.HashMap;

import net.sf.jasperreports.engine.JRException;
import net.sf.jasperreports.engine.JRExporterParameter;
import net.sf.jasperreports.engine.JasperFillManager;
import net.sf.jasperreports.engine.JasperPrint;
import net.sf.jasperreports.engine.export.JRPdfExporter;
import net.sf.jasperreports.engine.export.JRRtfExporter;

public class Relatorio{
	private String arquivoJasper;
	private String pathArquivoJasper;
	private HashMap parametros;
	private JasperPrint jasperprint;
	
	public Relatorio(String arquivoJasper, String pathArquivoJasper, HashMap parametros){
		this.pathArquivoJasper = pathArquivoJasper;
		this.arquivoJasper = arquivoJasper;
		this.parametros = parametros;
		
		try{
			this.jasperprint = geraTmp();
		} catch(JRException e){
			this.jasperprint = null;
		}
	}
	
	public JasperPrint geraTmp() throws JRException{
		Conexao objConn = new Conexao();
		Connection conn = objConn.abrirConexao();
	
		try{
			JasperPrint jasperPrint = JasperFillManager.fillReport(this.pathArquivoJasper + File.separator + this.arquivoJasper, this.parametros, conn);
			return jasperPrint;
		}
		catch(JRException e){
			throw e;
		}
		finally{
			objConn.fecharConexao(conn);
		}
	}

	public boolean exporta(String tipo, String pathSaida, String arqSaida) throws JRException {
		try{
			if("pdf".equalsIgnoreCase(tipo) ){
				JRPdfExporter exporterPDF = new JRPdfExporter();
				exporterPDF.setParameter(JRExporterParameter.JASPER_PRINT, this.jasperprint);
				exporterPDF.setParameter(JRExporterParameter.OUTPUT_FILE_NAME, pathSaida + File.separator + arqSaida + ".pdf");
				exporterPDF.exportReport();
			}

			else if("rtf".equalsIgnoreCase(tipo) ){
				JRRtfExporter exporterRTF = new JRRtfExporter();
				exporterRTF.setParameter(JRExporterParameter.JASPER_PRINT, this.jasperprint);
				exporterRTF.setParameter(JRExporterParameter.OUTPUT_FILE_NAME, pathSaida + File.separator + arqSaida + ".rtf");
				exporterRTF.exportReport();
			}

			return true;
		}
		catch(Exception e){
			return false;
		}
	}
}

// Prepara os parametros
HashMap parametros = new HashMap();
parametros.put("MAX_REGISTROS_POR_PAGINA", 100);
parametros.put("ZEBRADO", 0);


// Ao instanciar a linha abaixo, o relatório é executado e "preenchido" com as informações do banco.

Relatorio relatorio = new Relatorio("meuRelatorio.jasper", "c:", parametros);

// Exporta o relatório preenchido para o formato desejado:

relatorio.exporta("pdf", "c:", "meuRelatorio_data_hora");  // Vc tem duas opções:  pdf ou rtf, mas dá pra implementar outras opções facilmente.

<%@page pageEncoding="Cp1252" contentType="text/html; charset=Cp1252" %>
<%@page import="java.util.*, java.text.*, br.com.sistema.rotinas.*" %>

<!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=Cp1252"/>
<title>Relatório:</title>
</head>
<body>
	<%
		//Pega Parâmetros
		String relatorio = "ListagemEstoque";
                String arquivoJasper = relatorio + ".jasper";
		String tipo = "pdf"


		SimpleDateFormat data = new SimpleDateFormat("dd_MM_yyyy_H_m_s");
		Calendar cal = Calendar.getInstance();
		String dataHora = data.format(cal.getTime());

		String relatorioSaida = relatorio + "_" + dataHora; 

                //Define diretório de entrada ".jasper" e o diretório de saida
		String dir_origem = application.getRealPath("/relatorios_jasper");
		String dir_saida = application.getRealPath("/tmp");
			
		
			
		HashMap map = new HashMap();

		//Gera Relatório
		Relatorio rep = new Relatorio(relatorio  + ".jasper", dir_origem, map);
		rep.exporta(tipo, dir_saida, relatorioSaida);
				
			
	%>

         
         Abrir: <a href="tmp/<%= relatorioSaida + "." + tipo %>">Clique aqui</a>


</body>
</html>

String dir_origem = application.getRealPath("/relatorios_jasper");  
        String dir_saida = application.getRealPath("/temporarios");

<%@page contentType="text/html" pageEncoding="iso-8859-1"%>
<%@page import="java.util.HashMap,java.util.Map,
net.sf.jasperreports.engine.*,net.sf.jasperreports.view.JasperViewer"%>
<%@page import="database.Conexao"%>
<%@page import="java.sql.*"%>
<%@page import="java.io.*"%>

<%
String imprimir = request.getParameter("imprimir");
 if (imprimir != null) { 

Connection conn = Conexao.getConection();
PreparedStatement pstmt = null;
ResultSet rs = null;
try {
   pstmt = conn.prepareStatement("SELECT * FROM voluntapae WHERE idvolunt = ?");
   pstmt.setObject(1, imprimir);
   rs = pstmt.executeQuery();
   rs.next();

   File reportFile = new File(application.getRealPath("/reports/volunt.jasper"));

   Map parameters = new HashMap();
   parameters.put("pcd_slip", imprimir);  // o que eu faço aqui?
   parameters.put("pdirectory", application.getRealPath(""));  // e aqui?

   byte[] bytes =
     JasperRunManager.runReportToPdf(reportFile.getPath(), parameters, conn);   // mostra erro nesta linha

   response.setContentType("application/pdf");
   response.setContentLength(bytes.length);
   ServletOutputStream ouputStream = response.getOutputStream();
   ouputStream.write(bytes, 0, bytes.length);
   ouputStream.flush();
   ouputStream.close();
   
   rs.close();
}
catch(Exception e){
    response.sendRedirect("msg_err.jsp");  // caso haja erro, vai pra outra página
    out.println(e);
} // catch
finally {
   if (conn != null) conn.close();
}
}
%>

$P{PAR_PEDID}

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.HashMap;
import net.sf.jasperreports.engine.JRException;
import net.sf.jasperreports.engine.JasperFillManager;
import net.sf.jasperreports.engine.JasperPrint;
import net.sf.jasperreports.view.JasperViewer;

public class Main {

	public static void main(String[] args) {
		Connection conn = null;

		try {
			 //cria a conexão com o banco de dados
			Class.forName("com.mysql.jdbc.Driver");
			String db = "jdbc:mysql://localhost:3306/relatorios";
			conn = DriverManager.getConnection(db,"root","123456");

			System.out.println("Gerando relatório...");

			HashMap<String, Integer> parameterMap = 
						new HashMap<String, Integer>( );
			 //o Nome do parâmetro e o valor é passado ao HashMap
			parameterMap.put("PAR_PEDID", 10248);

			 //pega o caminho físico até o arquivo .jasper
			String arquivo = System.getProperty("user.dir") + "/relatorios/relatorio.jasper";
 //chama fillReport
			JasperPrint jp = JasperFillManager.fillReport(arquivo, parameterMap, conn);  // quando executo, mostra erro aqui

			 //exibe o relatório com viewReport
			JasperViewer.viewReport(jp, false);
            
		} catch (SQLException ex) {
            ex.printStackTrace();
		} catch (ClassNotFoundException ex) {
            ex.printStackTrace();
		} catch (JRException e) {
            e.printStackTrace();
		} finally {
            try {
                if (!conn.isClosed()) {
                    conn.close();
                }
                System.out.println("Finalizado!");
            } catch (SQLException ex) {}
		}
	}
}

java.lang.ClassCastException: cannot assign instance of net.sf.jasperreports.engine.base.JRBaseRectangle to field net.sf.jasperreports.engine.base.JRBasePen.penContainer of type net.sf.jasperreports.engine.JRPenContainer in instance of net.sf.jasperreports.engine.base.JRBasePen
	at java.io.ObjectStreamClass$FieldReflector.setObjFieldValues(ObjectStreamClass.java:2032)
	at java.io.ObjectStreamClass.setObjFieldValues(ObjectStreamClass.java:1212)
	at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1951)
	at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1869)
	at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1753)
	at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1329)
	at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1945)
	at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1869)
	at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1753)
	at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1329)
	at java.io.ObjectInputStream.readObject(ObjectInputStream.java:351)
	at java.util.ArrayList.readObject(ArrayList.java:593)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at java.io.ObjectStreamClass.invokeReadObject(ObjectStreamClass.java:974)
	at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1846)
	at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1753)
	at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1329)
	at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1945)
	at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1869)
	at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1753)
	at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1329)
	at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1945)
	at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1869)
	at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1753)
	at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1329)
	at java.io.ObjectInputStream.readObject(ObjectInputStream.java:351)
	at net.sf.jasperreports.engine.util.JRLoader.loadObject(JRLoader.java:88)
	at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:232)
	at Main.main(Main.java:31)