Parâmetros Ireport do tido TimeStamp (Resolvido)

2 respostas
java
Elivelton_Oliveira

Pessoal, como faço para passar como parâmetros campos TimeStamp para o Ireport ?
Eu estou usando o JDateChooser para pegar a data, mas ele da erro:

String pontos = 00:00:00;

String espaco = " ";

Timestamp timestamp = new Timestamp(System.currentTimeMillis());

date_i = new SimpleDateFormat(((JTextField) Data_Inicial.getDateEditor().getUiComponent()).getText()+espaco+pontos).format(timestamp.getTime());

date_f = new SimpleDateFormat(((JTextField) Data_Final.getDateEditor().getUiComponent()).getText()+espaco+pontos).format(timestamp.getTime();
Erro:

java.lang.ClassCastException: java.lang.String cannot be cast to java.sql.Timestamp

at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.setTimestamp(JRJdbcQueryExecuter.java:605)

at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.setStatementParameter(JRJdbcQueryExecuter.java:569)

at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.setStatementParameter(JRJdbcQueryExecuter.java:399)

at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter$1.visit(JRJdbcQueryExecuter.java:332)

at net.sf.jasperreports.engine.query.JRAbstractQueryExecuter$QueryParameter.accept(JRAbstractQueryExecuter.java:157)

at net.sf.jasperreports.engine.query.JRAbstractQueryExecuter.visitQueryParameters(JRAbstractQueryExecuter.java:646)

at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createStatement(JRJdbcQueryExecuter.java:317)

at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:196)

at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1086)

at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:667)

at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1258)

at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:877)

at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:822)

at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:61)

at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:446)

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

at br.com.relatorios.RelatorioService.gerarRelatorio(RelatorioService.java:35)

at br.com.relatorios.Relatorio_Reservas.btn_ImprimirActionPerformed(Relatorio_Reservas.java:188)

at br.com.relatorios.Relatorio_Reservas.access$000(Relatorio_Reservas.java:24)

at br.com.relatorios.Relatorio_Reservas$1.actionPerformed(Relatorio_Reservas.java:95)

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

at java.awt.Component.dispatchEventImpl(Component.java:4889)

at java.awt.Container.dispatchEventImpl(Container.java:2294)

at java.awt.Component.dispatchEvent(Component.java:4711)

at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4888)

at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4525)

at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4466)

at java.awt.Container.dispatchEventImpl(Container.java:2280)

at java.awt.Window.dispatchEventImpl(Window.java:2746)

at java.awt.Component.dispatchEvent(Component.java:4711)

at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:758)

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

at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86)

at java.awt.EventQueue$4.run(EventQueue.java:731)

at java.awt.EventQueue$4.run(EventQueue.java:729)

at java.security.AccessController.doPrivileged(Native Method)

at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)

at java.awt.EventQueue.dispatchEvent(EventQueue.java:728)

at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)

at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)

at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:109)

at java.awt.WaitDispatchSupport$2.run(WaitDispatchSupport.java:184)

at java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:229)

at java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:227)

at java.security.AccessController.doPrivileged(Native Method)

at java.awt.WaitDispatchSupport.enter(WaitDispatchSupport.java:227)

at java.awt.Dialog.show(Dialog.java:1084)

at java.awt.Component.show(Component.java:1671)

at java.awt.Component.setVisible(Component.java:1623)

at java.awt.Window.setVisible(Window.java:1014)

at java.awt.Dialog.setVisible(Dialog.java:1005)

at br.com.relatorios.Relatorio_Reservas$2.run(Relatorio_Reservas.java:233)

at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:311)

at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:756)

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

at java.awt.EventQueue.dispatchEvent(EventQueue.java:726)

at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)

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)

2 Respostas

darlan_machado

Existe o tipo Timestamp no java. Use-o.

Elivelton_Oliveira

Mestre, Muito Obrigado !

Consegui resolver. Vlw

Criado 10 de maio de 2019
Ultima resposta 10 de mai. de 2019
Respostas 2
Participantes 2