Olá,
fiz um report pelo ireport 3.1.0(usando sql dentro report) e executa normalmente mas quando vou
executar através do jasper version 3.1.0 através do eclipse galileo me apresenta
o erro abaixo através do metodo abaixo
public String relatorio1() throws MalformedURLException, SQLException {
OutputStream ops = null;
Session session = null;
Connection con = null;
byte[] bytes = null;
Map parameters = new HashMap();
try {
WebReportUtil.invoke(getServletContext(), getRequest(), getResponse());
String jasper = getRequest().getContextPath()+ "/jasperreports/report4.jasper";
String host = "http://" + getRequest().getServerName() + ":" + getRequest().getServerPort();
URL jasperURL = new URL(host + jasper);
getResponse().setContentType(CONTENT_TYPE_PDF);
//
session = HibernateUtil.getInstance().getSession();
con = session.connection();
//
bytes = JasperRunManager.runReportToPdf(jasperURL.openStream(), parameters,con);
} catch (JRException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
ops = getResponse().getOutputStream();
ops.write(bytes);
ops.flush();
ops.close();
con.close();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
13/04/2011 04:27:40 org.hibernate.cfg.SettingsFactory buildSettings
INFO : Optimize cache for minimal puts: disabled
13/04/2011 04:27:40 org.hibernate.cfg.SettingsFactory buildSettings
INFO : Structured second-level cache entries: disabled
13/04/2011 04:27:40 org.hibernate.cfg.SettingsFactory buildSettings
INFO : Echoing all SQL to stdout
13/04/2011 04:27:40 org.hibernate.cfg.SettingsFactory buildSettings
INFO : Statistics: disabled
13/04/2011 04:27:40 org.hibernate.cfg.SettingsFactory buildSettings
INFO : Deleted entity synthetic identifier rollback: disabled
13/04/2011 04:27:40 org.hibernate.cfg.SettingsFactory buildSettings
INFO : Default entity-mode: pojo
13/04/2011 04:27:40 org.hibernate.cfg.SettingsFactory buildSettings
INFO : Named query checking : enabled
13/04/2011 04:27:40 org.hibernate.impl.SessionFactoryImpl <init>
INFO : building session factory
13/04/2011 04:27:42 org.hibernate.impl.SessionFactoryObjectFactory addInstance
INFO : Not binding factory to JNDI, no JNDI name configured
13/04/2011 04:27:42 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
INFO : Running hbm2ddl schema update
13/04/2011 04:27:42 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
INFO : fetching database metadata
13/04/2011 04:27:42 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
INFO : updating schema
13/04/2011 04:27:42 org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO : table found: avalia.instituto
13/04/2011 04:27:42 org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO : columns: [nm_instituto, id_instituto]
13/04/2011 04:27:42 org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO : foreign keys: []
13/04/2011 04:27:42 org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO : indexes: [primary]
13/04/2011 04:27:42 org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO : table found: avalia.papel
13/04/2011 04:27:42 org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO : columns: [id_papel, papel]
13/04/2011 04:27:42 org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO : foreign keys: []
13/04/2011 04:27:42 org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO : indexes: [primary]
13/04/2011 04:27:42 org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO : table found: avalia.pergunta_aluno
13/04/2011 04:27:42 org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO : columns: [nm_pergunta_aluno, id_pergunta_aluno]
13/04/2011 04:27:42 org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO : foreign keys: []
13/04/2011 04:27:42 org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO : indexes: [primary]
13/04/2011 04:27:42 org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO : table found: avalia.pergunta_aluno_resposta_aluno
13/04/2011 04:27:42 org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO : columns: [respostas_id_resposta_aluno, pergunta_aluno_id_pergunta_aluno]
13/04/2011 04:27:42 org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO : foreign keys: [fk11f72850ae18c9a, fk11f728501dc6bf64]
13/04/2011 04:27:42 org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO : indexes: [fk11f72850ae18c9a, respostas_id_resposta_aluno, primary, fk11f728501dc6bf64]
13/04/2011 04:27:42 org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO : table found: avalia.pergunta_professor
13/04/2011 04:27:42 org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO : columns: [id_pergunta_professor, nm_pergunta_professor]
13/04/2011 04:27:42 org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO : foreign keys: []
13/04/2011 04:27:42 org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO : indexes: [primary]
13/04/2011 04:27:42 org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO : table found: avalia.resposta_aluno
13/04/2011 04:27:42 org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO : columns: [pontua4, pontua3, pontua2, pontua1, id_resposta_aluno, id_pergunta_aluno, nm_aluno]
13/04/2011 04:27:42 org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO : foreign keys: [fk92d1b24df5669847]
13/04/2011 04:27:42 org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO : indexes: [fk92d1b24df5669847, primary]
13/04/2011 04:27:42 org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO : table found: avalia.resposta_professor
13/04/2011 04:27:42 org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO : columns: [nm_professor, pontua4, id_pergunta_professor, pontua3, pontua2, id_resposta_professor, pontua1]
13/04/2011 04:27:42 org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO : foreign keys: [fk66cc42d1dc101acf]
13/04/2011 04:27:42 org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO : indexes: [primary, fk66cc42d1dc101acf]
13/04/2011 04:27:42 org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO : table found: avalia.usuario
13/04/2011 04:27:42 org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO : columns: [id_usuario, login, cpf, nome, senha, skin]
13/04/2011 04:27:42 org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO : foreign keys: []
13/04/2011 04:27:42 org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO : indexes: [primary]
13/04/2011 04:27:42 org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO : table found: avalia.usuario_papel
13/04/2011 04:27:42 org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO : columns: [papeis_id_papel, usuario_id_usuario]
13/04/2011 04:27:42 org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO : foreign keys: [fk4d25cd354ef56ccd, fk4d25cd35a0ce33d5]
13/04/2011 04:27:42 org.hibernate.tool.hbm2ddl.TableMetadata <init>
INFO : indexes: [fk4d25cd354ef56ccd, primary, fk4d25cd35a0ce33d5, papeis_id_papel]
13/04/2011 04:27:42 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
INFO : schema update complete
13/04/2011 04:28:26 com.sun.faces.application.ActionListenerImpl processAction
GRAVE: java.lang.NullPointerException
javax.faces.el.EvaluationException: java.lang.NullPointerException
at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:102)
at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)
at javax.faces.component.UICommand.broadcast(UICommand.java:387)
at org.ajax4jsf.component.AjaxViewRoot.processEvents(AjaxViewRoot.java:184)
at org.ajax4jsf.component.AjaxViewRoot.broadcastEvents(AjaxViewRoot.java:162)
at org.ajax4jsf.component.AjaxViewRoot.processApplication(AjaxViewRoot.java:350)
at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:82)
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100)
at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:265)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.myfaces.webapp.filter.ExtensionsFilter.doFilter(ExtensionsFilter.java:246)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:141)
at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:281)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.myfaces.webapp.filter.ExtensionsFilter.doFilter(ExtensionsFilter.java:301)
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:191)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:558)
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:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.lang.NullPointerException
at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63)
at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:402)
at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:363)
at net.sf.jasperreports.engine.JasperRunManager.runReportToPdf(JasperRunManager.java:242)
at ao.edu.imag.avalia.view.managedbean.RespostaProfessorMB.relatorio1(RespostaProfessorMB.java:240)
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:191)
at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276)
at com.sun.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:68)
at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)
... 32 more