Galera pelo amor de deus peço novamente a ajuda de vcs, 2 noite e um dia sem dormir por isso não sei mas oq fazer, alguem pode me ajudar a imprimir um relatorio com este bendito irreport? segue todo meu codigo sql e o erro ja importei tudo enfim oq eu podia eu fiz alguem me da uma luz por favor?
sql
public boolean geraRelatorioCliente() {
try {
this.conectar();
this.executarSQL(
“SELECT”
+ " tbl_cliente.pk_id_cliente AS tbl_cliente_pk_id_cliente,"
+ " tbl_cliente.cli_nome AS tbl_cliente_cli_nome,"
+ " tbl_cliente.cli_endereco AS tbl_cliente_cli_endereco,"
+ " tbl_cliente.cli_bairro AS tbl_cliente_cli_bairro,"
+ " tbl_cliente.cli_cidade AS tbl_cliente_cli_cidade,"
+ " tbl_cliente.cli_uf AS tbl_cliente_cli_uf,"
+ " tbl_cliente.cli_cep AS tbl_cliente_cli_cep,"
+ " tbl_cliente.cli_telefone AS tbl_cliente_cli_telefone"
+ " FROM"
+ " tbl_cliente "
);
JRResultSetDataSource jrRs = new JRResultSetDataSource(getResultSet());
InputStream caminhoRelatorio = this.getClass().getClassLoader().getResourceAsStream(“relatorios/clientes.jasper”);
JasperPrint jasperPrint = JasperFillManager.fillReport(caminhoRelatorio, new HashMap(), jrRs);
JasperExportManager.exportReportToPdfFile(jasperPrint, “C:/Userscleit/Desktop/Vendas/rel/relatorioClientes.pdf”);
File file = new File (“C:/Userscleit/Desktop/Vendas/rel/relatorioClientes.pdf”);
try {
Desktop.getDesktop().open(file);
} catch (Exception e) {
JOptionPane.showConfirmDialog(null, e);
}
file.deleteOnExit();
return true;
} catch (Exception e) {
e.printStackTrace();
return false;
} finally {
this.fecharConexao();
}
}
erro
run:
Exception in thread “AWT-EventQueue-0” java.lang.NoClassDefFoundError: org/joda/time/ReadableInstant
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:348)
at net.sf.jasperreports.engine.util.JRClassLoader.loadClassForRealName(JRClassLoader.java:157)
at net.sf.jasperreports.engine.util.JRClassLoader.loadClassForName(JRClassLoader.java:115)
at net.sf.jasperreports.functions.FunctionsBundle.addFunctionClass(FunctionsBundle.java:84)
at net.sf.jasperreports.functions.FunctionsBundle.(FunctionsBundle.java:54)
at net.sf.jasperreports.functions.FunctionsRegistryFactory.createRegistry(FunctionsRegistryFactory.java:76)
at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.instantiateRegistry(DefaultExtensionsRegistry.java:239)
at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.loadRegistries(DefaultExtensionsRegistry.java:214)
at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.loadRegistries(DefaultExtensionsRegistry.java:162)
at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.getRegistries(DefaultExtensionsRegistry.java:133)
at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.getExtensions(DefaultExtensionsRegistry.java:105)
at net.sf.jasperreports.engine.util.JRStyledTextParser.(JRStyledTextParser.java:83)
at net.sf.jasperreports.engine.fill.JRBaseFiller.(JRBaseFiller.java:124)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.(JRVerticalFiller.java:89)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.(JRVerticalFiller.java:104)
at net.sf.jasperreports.engine.fill.JRVerticalFiller.(JRVerticalFiller.java:62)
at net.sf.jasperreports.engine.fill.JRFiller.createFiller(JRFiller.java:179)
at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:108)
at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:668)
at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:649)
at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:971)
at DAO.DAOCliente.geraRelatorioCliente(DAOCliente.java:258)
at controller.ControllerCliente.geraRelatorioCliente(ControllerCliente.java:70)
at view.ViewCliente.jbRelatActionPerformed(ViewCliente.java:385)
at view.ViewCliente.access$500(ViewCliente.java:18)
at view.ViewCliente$7.actionPerformed(ViewCliente.java:177)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2348)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
at java.awt.Component.processMouseEvent(Component.java:6533)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
at java.awt.Component.processEvent(Component.java:6298)
at java.awt.Container.processEvent(Container.java:2238)
at java.awt.Component.dispatchEventImpl(Component.java:4889)
at java.awt.Container.dispatchEventImpl(Container.java:2296)
at java.awt.Component.dispatchEvent(Component.java:4711)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4897)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4534)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4475)
at java.awt.Container.dispatchEventImpl(Container.java:2282)
at java.awt.Window.dispatchEventImpl(Window.java:2746)
at java.awt.Component.dispatchEvent(Component.java:4711)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:760)
at java.awt.EventQueue.access$500(EventQueue.java:97)
at java.awt.EventQueue$3.run(EventQueue.java:709)
at java.awt.EventQueue$3.run(EventQueue.java:703)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:90)
at java.awt.EventQueue$4.run(EventQueue.java:733)
at java.awt.EventQueue$4.run(EventQueue.java:731)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:730)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:205)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
Caused by: java.lang.ClassNotFoundException: org.joda.time.ReadableInstant
at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
… 63 more
