java.sql.SQLException: Wrong data type: Timestamp format must be yyyy-mm-dd hh:mm:ss.fffffffff

hsqldb | nobody | 1 decade ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Trouble with 'timestamp' type..

    hsqldb | 1 decade ago | nobody
    java.sql.SQLException: Wrong data type: Timestamp format must be yyyy-mm-dd hh:mm:ss.fffffffff
  2. 0

    JBoss Community / Mailing Lists

    sourceforge.net | 1 year ago
    java.sql.SQLException: Wrong data type: For input string: "org.jboss.invocation.InvocationResponse@..."
  3. 0

    When I try to generate classes I get the following error: CayenneModeler Info Version: 1.1.3 Build Date: September 28 2005 Exception: ================================= java.sql.SQLException: Wrong data type: For input string: "true" at org.hsqldb.Trace.getError(Unknown Source) at org.hsqldb.Trace.error(Unknown Source) at org.hsqldb.Column.convertObject(Unknown Source) at org.hsqldb.jdbcPreparedStatement.setObject(Unknown Source) at org.objectstyle.cayenne.access.types.AbstractType.setJdbcObject(AbstractType.java:78) at org.objectstyle.cayenne.dba.JdbcAdapter.bindParameter(JdbcAdapter.java:549) at org.objectstyle.cayenne.access.trans.BatchQueryBuilder.bindParameters(BatchQueryBuilder.java:143) at org.objectstyle.cayenne.access.DataNode.runBatchUpdateAsIndividualQueries(DataNode.java:594) at org.objectstyle.cayenne.access.DataNode.runBatchUpdate(DataNode.java:495) at org.objectstyle.cayenne.access.DataNode.performQueries(DataNode.java:353) at org.objectstyle.cayenne.access.ContextCommit.commit(ContextCommit.java:192) at org.objectstyle.cayenne.access.DataContext.commitChanges(DataContext.java:1266) at org.objectstyle.cayenne.access.DataContext.commitChanges(DataContext.java:1236) at org.objectstyle.cayenne.pref.Domain.getDetail(Domain.java:265) at org.objectstyle.cayenne.modeler.ProjectController.getDataMapPreferences(ProjectController.java:230) at org.objectstyle.cayenne.modeler.dialog.classgen.ClassGeneratorController.prepareModel(ClassGeneratorController.java:99) at org.objectstyle.cayenne.modeler.dialog.classgen.ClassGeneratorController.<init>(ClassGeneratorController.java:93) at org.objectstyle.cayenne.modeler.action.GenerateClassesAction.generateClasses(GenerateClassesAction.java:90) at org.objectstyle.cayenne.modeler.action.GenerateClassesAction.performAction(GenerateClassesAction.java:86) at org.objectstyle.cayenne.modeler.util.CayenneAction.actionPerformed(CayenneAction.java:188) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1819) at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1872) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258) at javax.swing.AbstractButton.doClick(AbstractButton.java:321) at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1113) at javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased(BasicMenuItemUI.java:943) at java.awt.Component.processMouseEvent(Component.java:5166) at java.awt.Component.processEvent(Component.java:4963) at java.awt.Container.processEvent(Container.java:1613) at java.awt.Component.dispatchEventImpl(Component.java:3681) at java.awt.Container.dispatchEventImpl(Container.java:1671) at java.awt.Component.dispatchEvent(Component.java:3543) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3527) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3242) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3172) at java.awt.Container.dispatchEventImpl(Container.java:1657) at java.awt.Window.dispatchEventImpl(Window.java:1606) at java.awt.Component.dispatchEvent(Component.java:3543) at java.awt.EventQueue.dispatchEvent(EventQueue.java:480) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:234) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:184) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:178) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:170) at java.awt.EventDispatchThread.run(EventDispatchThread.java:100)

    Apache's JIRA Issue Tracker | 1 decade ago | Kurt Rheaume
    java.sql.SQLException: Wrong data type: For input string: "true"
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    JBoss Community / Mailing Lists

    sourceforge.net | 6 months ago
    java.sql.SQLException: Wrong data type: For input string: "org.jboss.invocation.InvocationResponse@..."

    Root Cause Analysis

    1. java.sql.SQLException

      Wrong data type: Timestamp format must be yyyy-mm-dd hh:mm:ss.fffffffff

      at org.hsqldb.Trace.getError()
    2. HSQLDB
      jdbcPreparedStatement.setObject
      1. org.hsqldb.Trace.getError(Unknown Source)
      2. org.hsqldb.Trace.error(Unknown Source)
      3. org.hsqldb.Column.convertObject(Unknown Source)
      4. org.hsqldb.jdbcPreparedStatement.setObject(Unknown Source)
      4 frames