java.sql.SQLException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • 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)
    via by Kurt Rheaume,
  • JBoss Community / Mailing Lists
    via by Unknown author,
  • Trouble with 'timestamp' type..
    via hsqldb by nobody
    ,
  • JBoss Community / Mailing Lists
    via by Unknown author,
  • need help using hsqldb
    via by Mladen Adamovic,
  • Newbie: Problems with hsqldb
    via by bjoern,
  • HSQLDB problem
    via by Manolis Christodoulou,
  • HSQLDB - User - Error of loading a database
    via by Unknown author,
    • 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)

    Users with the same issue

    Unknown visitor
    Unknown visitor1 times, last one,