Olá pessoal, estou com dificuldades em visualizar um relatorio e não consigo encontrar o erro.
ele chega a ser gerado, mais não visualiza.
Segue o codigo e o erro:
RelatorioUsuarioHandler
public class RelatorioUsuarioHandler {
public JasperPrint relatorioUsuario() throws JRException {
try {
String arquivoJasper;
// arquivoJasper = "/relatorios/Usuario.jasper";
arquivoJasper = "/relatorios/Usuario.jrxml";
System.out.println("Opening file report...");
InputStream is = RelatorioUsuarioHandler.class
.getResourceAsStream(arquivoJasper);
System.out.println("File open.");
JasperReport jr = JasperCompileManager.compileReport(is);
JRResultSetDataSource jrrs = new JRResultSetDataSource(relatorioDao
.getUsuarios());
Map param = new HashMap();
JasperPrint print = JasperFillManager.fillReport(jr, param, jrrs);
JasperViewer.viewReport(is, false);
return print;
} catch (Exception e) {
System.out.println("Erro Relatorio UsuarioHandler "
+ e.getMessage());
e.printStackTrace();
return null;
}
}
}
RelatorioDao
public class relatorioDao {
public static ResultSet getUsuarios() {
System.out.println("Executando query Relatorio...");
String sql = "select id_usuario, login_usuario, nivel_usuario, nome_usuario from usuario";
ResultSet rsRelatorio = null;
try {
System.out.println("Abrindo connection...");
Connection con = HibernateUtil.getConection();
PreparedStatement ps = con.prepareStatement(sql);
rsRelatorio = ps.executeQuery();
} catch (Exception e) {
System.out.println("Erro relatorioDAO " + e.getMessage());
e.printStackTrace();
}
return rsRelatorio;
}
}
RelatorioTeste.jsp
<%@ taglib uri="http://richfaces.org/a4j" prefix="a4j"%>
<%@ taglib uri="http://richfaces.org/rich" prefix="rich"%>
<%@ taglib uri="http://java.sun.com/jsf/core" prefix="f"%>
<%@ taglib uri="http://java.sun.com/jsf/html" prefix="h"%>
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<!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>Insert title here</title>
</head>
<body>
<f:view>
<h:form>
<a4j:region>
<a4j:commandButton value="Relatorio"
action="#{relatorioUsuarioHandler.relatorioUsuario}"
status="statusRelatorio"></a4j:commandButton>
<a4j:status id="statusRelatorio">
<f:facet name="start">
<h:outputText value="GERANDO RELATORIO"></h:outputText>
</f:facet>
<f:facet name="stop">
<h:outputText value="RELATORIO GERADO COM SUCESSO"></h:outputText>
</f:facet>
</a4j:status>
</a4j:region>
</h:form>
</f:view>
</body>
</html>
Console do Eclipse ao gerar
Opening file report…
File open.
Executando query Relatorio…
Abrindo connection…
22:07:31,583 INFO C3P0ConnectionProvider:81 - C3P0 using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost/saudetotal
22:07:31,583 INFO C3P0ConnectionProvider:82 - Connection properties: {user=root, password=<strong><strong>}
22:07:31,583 INFO C3P0ConnectionProvider:85 - autocommit mode: false
22:07:31,614 INFO AbstractPoolBackedDataSource:462 - Initializing c3p0 pool… com.mchange.v2.c3p0.PoolBackedDataSource@c357bd29 [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@12f0bfbf [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, debugUnreturnedConnectionStackTraces -> false, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 2rxclf7xdopa92gv1i12|41d471, idleConnectionTestPeriod -> 3000, initialPoolSize -> 2, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 5000, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 2, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 2, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@c47f2917 [ description -> null, driverClass -> null, factoryClassLocation -> null, identityToken -> 2rxclf7xdopa92gv1i12|b0dffe, jdbcUrl -> jdbc:mysql://localhost/saudetotal, properties -> {user=</strong></strong>**, password=******} ], preferredTestQuery -> null, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false; userOverrides: {} ], dataSourceName -> null, factoryClassLocation -> null, identityToken -> 2rxclf7xdopa92gv1i12|adcd81, numHelperThreads -> 3 ]
22:07:31,645 INFO SettingsFactory:89 - RDBMS: MySQL, version: 5.0.67-community-nt
22:07:31,645 INFO SettingsFactory:90 - JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.0.4 ( $Date: 2006-10-19 17:47:48 +0200 (Thu, 19 Oct 2006) $, $Revision: 5908 $ )
22:07:31,645 INFO Dialect:152 - Using dialect: org.hibernate.dialect.MySQLDialect
22:07:31,645 INFO TransactionFactoryFactory:31 - Using default transaction strategy (direct JDBC transactions)
22:07:31,645 INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
22:07:31,645 INFO SettingsFactory:143 - Automatic flush during beforeCompletion(): disabled
22:07:31,645 INFO SettingsFactory:147 - Automatic session close at end of transaction: disabled
22:07:31,661 INFO SettingsFactory:154 - JDBC batch size: 15
22:07:31,661 INFO SettingsFactory:157 - JDBC batch updates for versioned data: disabled
22:07:31,661 INFO SettingsFactory:162 - Scrollable result sets: enabled
22:07:31,661 INFO SettingsFactory:170 - JDBC3 getGeneratedKeys(): enabled
22:07:31,661 INFO SettingsFactory:178 - Connection release mode: auto
22:07:31,661 INFO SettingsFactory:202 - Maximum outer join fetch depth: 2
22:07:31,661 INFO SettingsFactory:205 - Default batch fetch size: 1
22:07:31,661 INFO SettingsFactory:209 - Generate SQL with comments: disabled
22:07:31,661 INFO SettingsFactory:213 - Order SQL updates by primary key: disabled
22:07:31,661 INFO SettingsFactory:382 - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
22:07:31,661 INFO ASTQueryTranslatorFactory:24 - Using ASTQueryTranslatorFactory
22:07:31,661 INFO SettingsFactory:221 - Query language substitutions: {}
22:07:31,661 INFO SettingsFactory:226 - JPA-QL strict compliance: disabled
22:07:31,661 INFO SettingsFactory:231 - Second-level cache: enabled
22:07:31,661 INFO SettingsFactory:235 - Query cache: disabled
22:07:31,661 INFO SettingsFactory:369 - Cache provider: org.hibernate.cache.NoCacheProvider
22:07:31,661 INFO SettingsFactory:250 - Optimize cache for minimal puts: disabled
22:07:31,661 INFO SettingsFactory:259 - Structured second-level cache entries: disabled
22:07:31,661 INFO SettingsFactory:279 - Echoing all SQL to stdout
22:07:31,661 INFO SettingsFactory:286 - Statistics: disabled
22:07:31,661 INFO SettingsFactory:290 - Deleted entity synthetic identifier rollback: disabled
22:07:31,661 INFO SettingsFactory:305 - Default entity-mode: pojo
22:07:31,661 INFO SettingsFactory:309 - Named query checking : enabled
Erro Relatorio UsuarioHandler Error loading object from InputStream
net.sf.jasperreports.engine.JRException: Error loading object from InputStream
at net.sf.jasperreports.engine.util.JRLoader.loadObject(JRLoader.java:196)
at net.sf.jasperreports.view.JRViewer.loadReport(JRViewer.java:1438)
at net.sf.jasperreports.view.JRViewer.(JRViewer.java:274)
at net.sf.jasperreports.view.JRViewer.(JRViewer.java:231)
at net.sf.jasperreports.view.JasperViewer.(JasperViewer.java:162)
at net.sf.jasperreports.view.JasperViewer.viewReport(JasperViewer.java:429)
at net.sf.jasperreports.view.JasperViewer.viewReport(JasperViewer.java:351)
at br.com.saudetotal.relatorios.RelatorioUsuarioHandler.relatorioUsuario(RelatorioUsuarioHandler.java:37)
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: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)
at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:91)
at javax.faces.component.UICommand.broadcast(UICommand.java:383)
at org.ajax4jsf.component.AjaxActionComponent.broadcast(AjaxActionComponent.java:55)
at org.ajax4jsf.component.AjaxViewRoot.processEvents(AjaxViewRoot.java:317)
at org.ajax4jsf.component.AjaxViewRoot.broadcastEvents(AjaxViewRoot.java:292)
at org.ajax4jsf.component.AjaxViewRoot.processPhase(AjaxViewRoot.java:249)
at org.ajax4jsf.component.AjaxViewRoot.processApplication(AjaxViewRoot.java:462)
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 javax.faces.webapp.FacesServlet.service(FacesServlet.java:244)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:154)
at org.ajax4jsf.webapp.BaseFilter.handleRequest(BaseFilter.java:260)
at org.ajax4jsf.webapp.BaseFilter.processUploadsAndHandleRequest(BaseFilter.java:366)
at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:493)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at br.com.saudetotal.util.HibernateSessionFilter.doFilter(HibernateSessionFilter.java:19)
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(Unknown Source)
Caused by: java.io.EOFException
at java.io.ObjectInputStream$PeekInputStream.readFully(Unknown Source)
at java.io.ObjectInputStream$BlockDataInputStream.readShort(Unknown Source)
at java.io.ObjectInputStream.readStreamHeader(Unknown Source)
at java.io.ObjectInputStream.(Unknown Source)
at net.sf.jasperreports.engine.util.JRLoader.loadObject(JRLoader.java:191)
… 47 more