net.adrianromero.dataloader.DataException

java.sql.SQLException: Cannot convert value '2005-04-04 01:' from column 3 to TIMESTAMP.

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web3

  • via openbravopos by salvafl
    , 11 months ago
    java.sql.SQLException: Cannot convert value '2005-04-04 01:' from column 3 to TIMESTAMP.
  • via openbravopos by sugaray24
    , 11 months ago
    java.sql.SQLException: Unique constra int violation:  in statement \[INSERT INTO TICKETS (TICKETID, DATENEW, HOST, MONE Y, PERSON, PAYMENT) VALUES (?, ?, ?, NULL, ?, ?)\]
  • Stack trace

    • net.adrianromero.dataloader.DataException: java.sql.SQLException: Cannot convert value '2005-04-04 01:' from column 3 to TIMESTAMP. at net.adrianromero.dataloader.JDBCSentence$JDBCDataResultSet.getTimestamp(Unknown Source) at net.adrianromero.dataloader.Datas$DatasTIMESTAMP.getValue(Unknown Source) at net.adrianromero.dataloader.SerializerReadBasic.readValues(Unknown Source) at net.adrianromero.dataloader.SentenceDataResultSet.getCurrent(Unknown Source) at net.adrianromero.tpv.reports.JRDataSourceBasic.next(JRDataSourceBasic.java:91) at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:878) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:160) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:691) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:160) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:472) at net.adrianromero.tpv.reports.JPanelReport.launchreport(JPanelReport.java:118) at net.adrianromero.tpv.reports.JPanelReport.jButton1ActionPerformed(JPanelReport.java:180) at net.adrianromero.tpv.reports.JPanelReport.access$000(JPanelReport.java:48) at net.adrianromero.tpv.reports.JPanelReport$1.actionPerformed(JPanelReport.java:166) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1786) at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1839) 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:245) at java.awt.Component.processMouseEvent(Component.java:5100) at java.awt.Component.processEvent(Component.java:4897) at java.awt.Container.processEvent(Container.java:1569) at java.awt.Component.dispatchEventImpl(Component.java:3615) at java.awt.Container.dispatchEventImpl(Container.java:1627) at java.awt.Component.dispatchEvent(Component.java:3477) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128) at java.awt.Container.dispatchEventImpl(Container.java:1613) at java.awt.Window.dispatchEventImpl(Window.java:1606) at java.awt.Component.dispatchEvent(Component.java:3477) at java.awt.EventQueue.dispatchEvent(EventQueue.java:456) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137) at java.awt.EventDispatchThread.run(EventDispatchThread.java:100) Caused by: java.sql.SQLException: Cannot convert value '2005-04-04 01:' from column 3 to TIMESTAMP. at com.mysql.jdbc.ResultSet.getTimestampFromString(ResultSet.java:6369) at com.mysql.jdbc.ResultSet.getTimestampInternal(ResultSet.java:6394) at com.mysql.jdbc.ResultSet.getTimestamp(ResultSet.java:2268) ... 37 more

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 1 year ago