java.sql.SQLException: Wrong data type: For input string: "true"

Apache's JIRA Issue Tracker | Kurt Rheaume | 1 decade ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 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"
  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

    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
  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: For input string: "true"

      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
    3. org.objectstyle.cayenne
      CayenneAction.actionPerformed
      1. org.objectstyle.cayenne.access.types.AbstractType.setJdbcObject(AbstractType.java:78)
      2. org.objectstyle.cayenne.dba.JdbcAdapter.bindParameter(JdbcAdapter.java:549)
      3. org.objectstyle.cayenne.access.trans.BatchQueryBuilder.bindParameters(BatchQueryBuilder.java:143)
      4. org.objectstyle.cayenne.access.DataNode.runBatchUpdateAsIndividualQueries(DataNode.java:594)
      5. org.objectstyle.cayenne.access.DataNode.runBatchUpdate(DataNode.java:495)
      6. org.objectstyle.cayenne.access.DataNode.performQueries(DataNode.java:353)
      7. org.objectstyle.cayenne.access.ContextCommit.commit(ContextCommit.java:192)
      8. org.objectstyle.cayenne.access.DataContext.commitChanges(DataContext.java:1266)
      9. org.objectstyle.cayenne.access.DataContext.commitChanges(DataContext.java:1236)
      10. org.objectstyle.cayenne.pref.Domain.getDetail(Domain.java:265)
      11. org.objectstyle.cayenne.modeler.ProjectController.getDataMapPreferences(ProjectController.java:230)
      12. org.objectstyle.cayenne.modeler.dialog.classgen.ClassGeneratorController.prepareModel(ClassGeneratorController.java:99)
      13. org.objectstyle.cayenne.modeler.dialog.classgen.ClassGeneratorController.<init>(ClassGeneratorController.java:93)
      14. org.objectstyle.cayenne.modeler.action.GenerateClassesAction.generateClasses(GenerateClassesAction.java:90)
      15. org.objectstyle.cayenne.modeler.action.GenerateClassesAction.performAction(GenerateClassesAction.java:86)
      16. org.objectstyle.cayenne.modeler.util.CayenneAction.actionPerformed(CayenneAction.java:188)
      16 frames
    4. Java RT
      EventDispatchThread.run
      1. javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1819)
      2. javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1872)
      3. javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
      4. javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
      5. javax.swing.AbstractButton.doClick(AbstractButton.java:321)
      6. javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1113)
      7. javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased(BasicMenuItemUI.java:943)
      8. java.awt.Component.processMouseEvent(Component.java:5166)
      9. java.awt.Component.processEvent(Component.java:4963)
      10. java.awt.Container.processEvent(Container.java:1613)
      11. java.awt.Component.dispatchEventImpl(Component.java:3681)
      12. java.awt.Container.dispatchEventImpl(Container.java:1671)
      13. java.awt.Component.dispatchEvent(Component.java:3543)
      14. java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3527)
      15. java.awt.LightweightDispatcher.processMouseEvent(Container.java:3242)
      16. java.awt.LightweightDispatcher.dispatchEvent(Container.java:3172)
      17. java.awt.Container.dispatchEventImpl(Container.java:1657)
      18. java.awt.Window.dispatchEventImpl(Window.java:1606)
      19. java.awt.Component.dispatchEvent(Component.java:3543)
      20. java.awt.EventQueue.dispatchEvent(EventQueue.java:480)
      21. java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:234)
      22. java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:184)
      23. java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:178)
      24. java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:170)
      25. java.awt.EventDispatchThread.run(EventDispatchThread.java:100)
      25 frames