bom dia senhores
estou desenvolvendo uns relatorios, usando o ireport com netbeans. desenvolvir os relatois no ireport, compilei e executei belesa sem nunhum problema. + quando chamo o .jasper pelo sistema não estar funcionando como deveria, o problema é o seguinte. a aplicação chama o . jasper, gera o .jrprint e o .pdf + NAO ABRIR O .PDF. O código é esse
private void executarRelatorio() throws ClassNotFoundException, SQLException, JRException, Exception {
String driver = “com.mysql.jdbc.Driver”;
String url = “jdbc:mysql://localhost/jsgp”;
String user = “root”;
String password = “para”;
Class.forName(driver);
Connection con = DriverManager.getConnection( url, user, password );
Statement stm = con.createStatement( );
String query = "select * from Atividade";
ResultSet rs = stm.executeQuery( query );
/* implementação da interface JRDataSource para DataSource ResultSet */
JRResultSetDataSource jrRS = new JRResultSetDataSource( rs );
/* HashMap de parametros utilizados no relatório. Sempre instanciados */
Map parameters = new HashMap();
// parameters.put("COLUNA", valor);
/* Preenche o relatório com os dados. Gera o arquivo BibliotecaPessoal.jrprint */
JasperFillManager.fillReportToFile( "RelatorioAtividade.jasper", parameters, jrRS );
/* Exporta para o formato PDF */
JasperExportManager.exportReportToPdfFile( "RelatorioAtivadade.jrprint" );
/* Preenche o relatorio e o salva diretamente em arquivo PDF. Sem
a necessidade do .jrprint */
//JasperRunManager.runReportToPdfFile("RelatorioAtivadade.jasper", parameters, jrRS);
/* Visualiza o relatório em formato PDF */
JasperViewer.viewReport("RelatorioAtividade.pdf", true );
String comando = "C:\\Documents and Settings\\cferreira.NPD\\Desktop\\jsgp\\jsgp\\lib\\RelatorioAtividade.pdf";
try {
Runtime.getRuntime().exec("rundll32 SHELL32.DLL,ShellExec_RunDLL "+comando);
} catch (IOException e) {
e.printStackTrace();
}
}
org.xml.sax.SAXParseException: Content is not allowed in prolog.
at org.apache.xerces.util.ErrorHandlerWrapper.createSAXParseException(Unknown Source)
at org.apache.xerces.util.ErrorHandlerWrapper.fatalError(Unknown Source)
at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source)
at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source)
at org.apache.xerces.impl.XMLScanner.reportFatalError(Unknown Source)
at org.apache.xerces.impl.XMLDocumentScannerImpl$PrologDispatcher.dispatch(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
at org.apache.xerces.parsers.DTDConfiguration.parse(Unknown Source)
at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
at org.apache.commons.digester.Digester.parse(Digester.java:1591)
org.xml.sax.SAXParseException: Content is not allowed in prolog.
at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
at org.apache.commons.digester.Digester.parse(Digester.java:1591)
at net.sf.jasperreports.engine.xml.JRPrintXmlLoader.loadXML(JRPrintXmlLoader.java:190)
at net.sf.jasperreports.engine.xml.JRPrintXmlLoader.load(JRPrintXmlLoader.java:142)
at net.sf.jasperreports.view.JRViewer.loadReport(JRViewer.java:1266)
at net.sf.jasperreports.view.JRViewer.(JRViewer.java:172)
at net.sf.jasperreports.view.JasperViewer.(JasperViewer.java:161)
at net.sf.jasperreports.view.JasperViewer.viewReport(JasperViewer.java:297)
at com.apl.gui.CadastroAtividade.executarRelatorio(CadastroAtividade.java:502)
at com.apl.gui.CadastroAtividade.btnImprimirActionPerformed(CadastroAtividade.java:418)
at com.apl.gui.CadastroAtividade.access$600(CadastroAtividade.java:30)
at com.apl.gui.CadastroAtividade$7.actionPerformed(CadastroAtividade.java:154)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849)
at net.sf.jasperreports.engine.xml.JRPrintXmlLoader.loadXML(JRPrintXmlLoader.java:190)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169)
at net.sf.jasperreports.engine.xml.JRPrintXmlLoader.load(JRPrintXmlLoader.java:142)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
at net.sf.jasperreports.view.JRViewer.loadReport(JRViewer.java:1266)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
at net.sf.jasperreports.view.JRViewer.(JRViewer.java:172)
at net.sf.jasperreports.view.JasperViewer.(JasperViewer.java:161)
at net.sf.jasperreports.view.JasperViewer.viewReport(JasperViewer.java:297)
at com.apl.gui.CadastroAtividade.executarRelatorio(CadastroAtividade.java:502)
at com.apl.gui.CadastroAtividade.btnImprimirActionPerformed(CadastroAtividade.java:418)
at com.apl.gui.CadastroAtividade.access$600(CadastroAtividade.java:30)
at com.apl.gui.CadastroAtividade$7.actionPerformed(CadastroAtividade.java:154)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:234)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:234)
at java.awt.Component.processMouseEvent(Component.java:5488)
at java.awt.Component.processMouseEvent(Component.java:5488)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3093)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3093)
at java.awt.Component.processEvent(Component.java:5253)
at java.awt.Container.processEvent(Container.java:1966)
at java.awt.Component.dispatchEventImpl(Component.java:3955)
at java.awt.Container.dispatchEventImpl(Container.java:2024)
at java.awt.Component.dispatchEvent(Component.java:3803)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
at java.awt.Container.dispatchEventImpl(Container.java:2010)
at java.awt.Window.dispatchEventImpl(Window.java:1766)
at java.awt.Component.processEvent(Component.java:5253)
at java.awt.Container.processEvent(Container.java:1966)
at java.awt.Component.dispatchEvent(Component.java:3803)
at java.awt.Component.dispatchEventImpl(Component.java:3955)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
at java.awt.Container.dispatchEventImpl(Container.java:2024)
at java.awt.Component.dispatchEvent(Component.java:3803)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
at java.awt.Container.dispatchEventImpl(Container.java:2010)
at java.awt.Window.dispatchEventImpl(Window.java:1766)
at java.awt.Component.dispatchEvent(Component.java:3803)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:234)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:234)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
NESTED BY :
org.xml.sax.SAXParseException: Content is not allowed in prolog.
at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
at org.apache.commons.digester.Digester.parse(Digester.java:1591)
at net.sf.jasperreports.engine.xml.JRPrintXmlLoader.loadXML(JRPrintXmlLoader.java:190)
at net.sf.jasperreports.engine.xml.JRPrintXmlLoader.load(JRPrintXmlLoader.java:142)
at net.sf.jasperreports.view.JRViewer.loadReport(JRViewer.java:1266)
at net.sf.jasperreports.view.JRViewer.(JRViewer.java:172)
at net.sf.jasperreports.view.JasperViewer.(JasperViewer.java:161)
at net.sf.jasperreports.view.JasperViewer.viewReport(JasperViewer.java:297)
at com.apl.gui.CadastroAtividade.executarRelatorio(CadastroAtividade.java:502)
at com.apl.gui.CadastroAtividade.btnImprimirActionPerformed(CadastroAtividade.java:418)
at com.apl.gui.CadastroAtividade.access$600(CadastroAtividade.java:30)
at com.apl.gui.CadastroAtividade$7.actionPerformed(CadastroAtividade.java:154)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:234)
at java.awt.Component.processMouseEvent(Component.java:5488)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3093)
at java.awt.Component.processEvent(Component.java:5253)
at java.awt.Container.processEvent(Container.java:1966)
at java.awt.Component.dispatchEventImpl(Component.java:3955)
at java.awt.Container.dispatchEventImpl(Container.java:2024)
at java.awt.Component.dispatchEvent(Component.java:3803)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
at java.awt.Container.dispatchEventImpl(Container.java:2010)
at java.awt.Window.dispatchEventImpl(Window.java:1766)
at java.awt.Component.dispatchEvent(Component.java:3803)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:234)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
NESTED BY :
net.sf.jasperreports.engine.JRException: Content is not allowed in prolog.
at net.sf.jasperreports.engine.xml.JRPrintXmlLoader.loadXML(JRPrintXmlLoader.java:198)
at net.sf.jasperreports.engine.xml.JRPrintXmlLoader.load(JRPrintXmlLoader.java:142)
at net.sf.jasperreports.view.JRViewer.loadReport(JRViewer.java:1266)
at net.sf.jasperreports.view.JRViewer.(JRViewer.java:172)
at net.sf.jasperreports.view.JasperViewer.(JasperViewer.java:161)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
at net.sf.jasperreports.view.JasperViewer.viewReport(JasperViewer.java:297)
at com.apl.gui.CadastroAtividade.executarRelatorio(CadastroAtividade.java:502)
at com.apl.gui.CadastroAtividade.btnImprimirActionPerformed(CadastroAtividade.java:418)
at com.apl.gui.CadastroAtividade.access$600(CadastroAtividade.java:30)
at com.apl.gui.CadastroAtividade$7.actionPerformed(CadastroAtividade.java:154)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:234)
at java.awt.Component.processMouseEvent(Component.java:5488)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3093)
at java.awt.Component.processEvent(Component.java:5253)
at java.awt.Container.processEvent(Container.java:1966)
at java.awt.Component.dispatchEventImpl(Component.java:3955)
at java.awt.Container.dispatchEventImpl(Container.java:2024)
at java.awt.Component.dispatchEvent(Component.java:3803)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
at java.awt.Container.dispatchEventImpl(Container.java:2010)
at java.awt.Window.dispatchEventImpl(Window.java:1766)
at java.awt.Component.dispatchEvent(Component.java:3803)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:234)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
Caused by: org.xml.sax.SAXParseException: Content is not allowed in prolog.
at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
at org.apache.commons.digester.Digester.parse(Digester.java:1591)
at net.sf.jasperreports.engine.xml.JRPrintXmlLoader.loadXML(JRPrintXmlLoader.java:190)
… 33 more
BUILD SUCCESSFUL (total time: 1 minute 47 seconds)
sera que alguem poderia me ajudar