Error in creating classes from a HSQLDB 2.0 database
----------------------------------------------------
Key: CAY-1535
URL: https://issues.apache.org/jira/browse/CAY-1535
Project: Cayenne
Issue Type: Bug
Components: Modeler
Affects Versions: 3.0.1
Environment: Mac OS X 10.6.6 (10J567)
MyEclipse Enterprise Workbench
Version: 8.6.1
Build id: 8.6.1-20101117
Reporter: Lorenzo Mengoni
I'm running the modeler in myEclipse, because I'm trying to make a model on a
HSQLDB 2.0 server.
To do that I run the modeler source code from the IDE in debug mode, with all
library in distribution except for hsqldb, in the classpath I've putted hsqldb
version 2.0.
I get the error when i try to generate the java code for classes mapped on the
db
The error comes up at line 76 of org.apache.cayenne.access.types.BooleanType
the offending statement: st.setObject(pos, val, type);
The vaules:
this BooleanType (id=143)
st JDBCPreparedStatement (id=203)
val Boolean (id=177)
pos 1
type 4
precision -1
The stack trace
CayenneModeler Info
Version: 3.0.1
Build Date: Aug 25 2010 19:38:17
Exception:
=================================
java.sql.SQLSyntaxErrorException: incompatible data type in conversion
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.JDBCPreparedStatement.setParameter(Unknown Source)
at org.hsqldb.jdbc.JDBCPreparedStatement.setObject(Unknown Source)
at org.hsqldb.jdbc.JDBCPreparedStatement.setObject(Unknown Source)
at
org.apache.cayenne.access.types.BooleanType.setJdbcObject(BooleanType.java:76)
at
org.apache.cayenne.dba.JdbcAdapter.bindParameter(JdbcAdapter.java:542)
at
org.apache.cayenne.access.trans.InsertBatchQueryBuilder.bindParameters(InsertBatchQueryBuilder.java:61)
at
org.apache.cayenne.access.jdbc.BatchAction.runAsIndividualQueries(BatchAction.java:219)
at
org.apache.cayenne.access.jdbc.BatchAction.performAction(BatchAction.java:91)
at
org.apache.cayenne.access.DataNodeQueryAction.runQuery(DataNodeQueryAction.java:87)
at org.apache.cayenne.access.DataNode.performQueries(DataNode.java:269)
at
org.apache.cayenne.access.DataDomainFlushAction.runQueries(DataDomainFlushAction.java:226)
at
org.apache.cayenne.access.DataDomainFlushAction.flush(DataDomainFlushAction.java:144)
at org.apache.cayenne.access.DataDomain.onSyncFlush(DataDomain.java:824)
at org.apache.cayenne.access.DataDomain$2.transform(DataDomain.java:791)
at
org.apache.cayenne.access.DataDomain.runInTransaction(DataDomain.java:850)
at org.apache.cayenne.access.DataDomain.onSync(DataDomain.java:788)
at
org.apache.cayenne.access.DataContext.flushToParent(DataContext.java:1106)
at
org.apache.cayenne.access.DataContext.commitChanges(DataContext.java:1045)
at
org.apache.cayenne.pref.DomainPreference.getPreference(DomainPreference.java:107)
at org.apache.cayenne.pref.Domain.getDetail(Domain.java:231)
at
org.apache.cayenne.modeler.ProjectController.getDataMapPreferences(ProjectController.java:376)
at
org.apache.cayenne.modeler.dialog.codegen.StandardModeController.createDefaults(StandardModeController.java:49)
at
org.apache.cayenne.modeler.dialog.codegen.GeneratorController.<init>(GeneratorController.java:69)
at
org.apache.cayenne.modeler.dialog.codegen.StandardModeController.<init>(StandardModeController.java:34)
at
org.apache.cayenne.modeler.dialog.codegen.GeneratorTabController.<init>(GeneratorTabController.java:54)
at
org.apache.cayenne.modeler.dialog.codegen.CodeGeneratorController.<init>(CodeGeneratorController.java:55)
at
org.apache.cayenne.modeler.action.GenerateCodeAction.performAction(GenerateCodeAction.java:47)
at
org.apache.cayenne.modeler.util.CayenneAction.actionPerformed(CayenneAction.java:163)
at
javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2028)
at
javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2351)
at
javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
at
javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
at javax.swing.AbstractButton.doClick(AbstractButton.java:389)
at
javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1223)
at com.apple.laf.AquaMenuItemUI.doClick(AquaMenuItemUI.java:137)
at
javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1264)
at
java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)
at java.awt.Component.processMouseEvent(Component.java:6352)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
at java.awt.Component.processEvent(Component.java:6117)
at java.awt.Container.processEvent(Container.java:2085)
at java.awt.Component.dispatchEventImpl(Component.java:4714)
at java.awt.Container.dispatchEventImpl(Container.java:2143)
at java.awt.Component.dispatchEvent(Component.java:4544)
at
java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4621)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4282)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4212)
at java.awt.Container.dispatchEventImpl(Container.java:2129)
at java.awt.Window.dispatchEventImpl(Window.java:2478)
at java.awt.Component.dispatchEvent(Component.java:4544)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:635)
at
java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:296)
at
java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:211)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:201)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:196)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:188)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
Caused by: org.hsqldb.HsqlException: incompatible data type in conversion
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.types.NumberType.convertToDefaultType(Unknown Source)
... 57 more
Caused by:
org.hsqldb.HsqlException: incompatible data type in conversion
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.types.NumberType.convertToDefaultType(Unknown Source)
at org.hsqldb.jdbc.JDBCPreparedStatement.setParameter(Unknown Source)
at org.hsqldb.jdbc.JDBCPreparedStatement.setObject(Unknown Source)
at org.hsqldb.jdbc.JDBCPreparedStatement.setObject(Unknown Source)
at
org.apache.cayenne.access.types.BooleanType.setJdbcObject(BooleanType.java:76)
at
org.apache.cayenne.dba.JdbcAdapter.bindParameter(JdbcAdapter.java:542)
at
org.apache.cayenne.access.trans.InsertBatchQueryBuilder.bindParameters(InsertBatchQueryBuilder.java:61)
at
org.apache.cayenne.access.jdbc.BatchAction.runAsIndividualQueries(BatchAction.java:219)
at
org.apache.cayenne.access.jdbc.BatchAction.performAction(BatchAction.java:91)
at
org.apache.cayenne.access.DataNodeQueryAction.runQuery(DataNodeQueryAction.java:87)
at org.apache.cayenne.access.DataNode.performQueries(DataNode.java:269)
at
org.apache.cayenne.access.DataDomainFlushAction.runQueries(DataDomainFlushAction.java:226)
at
org.apache.cayenne.access.DataDomainFlushAction.flush(DataDomainFlushAction.java:144)
at org.apache.cayenne.access.DataDomain.onSyncFlush(DataDomain.java:824)
at org.apache.cayenne.access.DataDomain$2.transform(DataDomain.java:791)
at
org.apache.cayenne.access.DataDomain.runInTransaction(DataDomain.java:850)
at org.apache.cayenne.access.DataDomain.onSync(DataDomain.java:788)
at
org.apache.cayenne.access.DataContext.flushToParent(DataContext.java:1106)
at
org.apache.cayenne.access.DataContext.commitChanges(DataContext.java:1045)
at
org.apache.cayenne.pref.DomainPreference.getPreference(DomainPreference.java:107)
at org.apache.cayenne.pref.Domain.getDetail(Domain.java:231)
at
org.apache.cayenne.modeler.ProjectController.getDataMapPreferences(ProjectController.java:376)
at
org.apache.cayenne.modeler.dialog.codegen.StandardModeController.createDefaults(StandardModeController.java:49)
at
org.apache.cayenne.modeler.dialog.codegen.GeneratorController.<init>(GeneratorController.java:69)
at
org.apache.cayenne.modeler.dialog.codegen.StandardModeController.<init>(StandardModeController.java:34)
at
org.apache.cayenne.modeler.dialog.codegen.GeneratorTabController.<init>(GeneratorTabController.java:54)
at
org.apache.cayenne.modeler.dialog.codegen.CodeGeneratorController.<init>(CodeGeneratorController.java:55)
at
org.apache.cayenne.modeler.action.GenerateCodeAction.performAction(GenerateCodeAction.java:47)
at
org.apache.cayenne.modeler.util.CayenneAction.actionPerformed(CayenneAction.java:163)
at
javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2028)
at
javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2351)
at
javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
at
javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
at javax.swing.AbstractButton.doClick(AbstractButton.java:389)
at
javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1223)
at com.apple.laf.AquaMenuItemUI.doClick(AquaMenuItemUI.java:137)
at
javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1264)
at
java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)
at java.awt.Component.processMouseEvent(Component.java:6352)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
at java.awt.Component.processEvent(Component.java:6117)
at java.awt.Container.processEvent(Container.java:2085)
at java.awt.Component.dispatchEventImpl(Component.java:4714)
at java.awt.Container.dispatchEventImpl(Container.java:2143)
at java.awt.Component.dispatchEvent(Component.java:4544)
at
java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4621)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4282)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4212)
at java.awt.Container.dispatchEventImpl(Container.java:2129)
at java.awt.Window.dispatchEventImpl(Window.java:2478)
at java.awt.Component.dispatchEvent(Component.java:4544)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:635)
at
java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:296)
at
java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:211)
at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:201)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:196)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:188)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
