You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cayenne.apache.org by "Andrus Adamchik (JIRA)" <ji...@apache.org> on 2010/07/13 14:59:50 UTC
[jira] Commented: (CAY-1463) Generate Database Schema -
[ https://issues.apache.org/jira/browse/CAY-1463?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12887742#action_12887742 ]
Andrus Adamchik commented on CAY-1463:
--------------------------------------
I guess we may implement better more user friendly validation for schema generation, but the underlying problem is incomplete mapping:
org.apache.cayenne.CayenneRuntimeException: [v.3.0 Apr 26 2010 09:59:17] Undefined type for attribute 'globaldistributer.founders': 2003
at org.apache.cayenne.dba.postgres.PostgresAdapter.createTable(PostgresAdapter.java:160)
> Generate Database Schema -
> ---------------------------
>
> Key: CAY-1463
> URL: https://issues.apache.org/jira/browse/CAY-1463
> Project: Cayenne
> Issue Type: Bug
> Components: Modeler
> Affects Versions: 3.0
> Environment: Microsoft XP
> java version "1.6.0_20"
> Java(TM) SE Runtime Environment (build 1.6.0_20-b02)
> Java HotSpot(TM) Client VM (build 16.3-b01, mixed mode, sharing)
> PostgreSQL 8.4 on localhost
> Eclipse Helios
> Reporter: Roland Oertig
> Fix For: 3.0
>
>
> CayenneModeler Info
> Version: 3.0
> Build Date: Apr 26 2010 09:59:17
> Exception:
> =================================
> java.lang.NullPointerException
> at org.apache.cayenne.modeler.pref.DBGeneratorDefaults.configureGenerator(DBGeneratorDefaults.java:29)
> at org.apache.cayenne.modeler.dialog.db.DBGeneratorOptions.<init>(DBGeneratorOptions.java:82)
> at org.apache.cayenne.modeler.action.GenerateDBAction.performAction(GenerateDBAction.java:68)
> at org.apache.cayenne.modeler.util.CayenneAction.actionPerformed(CayenneAction.java:163)
> at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
> at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
> at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
> at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
> at javax.swing.AbstractButton.doClick(AbstractButton.java:357)
> at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1225)
> at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1266)
> at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)
> at java.awt.Component.processMouseEvent(Component.java:6216)
> at javax.swing.JComponent.processMouseEvent(JComponent.java:3265)
> at java.awt.Component.processEvent(Component.java:5981)
> at java.awt.Container.processEvent(Container.java:2041)
> at java.awt.Component.dispatchEventImpl(Component.java:4583)
> at java.awt.Container.dispatchEventImpl(Container.java:2099)
> at java.awt.Component.dispatchEvent(Component.java:4413)
> at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4556)
> at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4220)
> at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4150)
> at java.awt.Container.dispatchEventImpl(Container.java:2085)
> at java.awt.Window.dispatchEventImpl(Window.java:2475)
> at java.awt.Component.dispatchEvent(Component.java:4413)
> at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
> at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
> at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
> at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
> at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
> at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
> at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
> The Log:
> 13.07.2010 14:45:19
> INFO: --- will run 1 query.
> 13.07.2010 14:45:19
> INFO: --- transaction started.
> 13.07.2010 14:45:19
> INFO: SELECT t0.parent_id, t0.level, t0.id, t0.description, t0.name, t0.version FROM domain t0 WHERE (t0.name = ?) AND (t0.level = ?) [bind: 1->name:'CayenneModeler', 2->level:0]
> 13.07.2010 14:45:19
> INFO: === returned 1 row. - took 0 ms.
> 13.07.2010 14:45:19
> INFO: +++ transaction committed.
> 13.07.2010 14:45:19
> INFO: --- will run 1 query.
> 13.07.2010 14:45:19
> INFO: --- transaction started.
> 13.07.2010 14:45:19
> INFO: SELECT t0.key_value_pairs, t0.domain_id, t0.key, t0.id FROM domain_preference t0 JOIN domain t1 ON (t0.domain_id = t1.id) WHERE (t0.key = ?) AND (t0.domain_id = ?) ORDER BY t1.level DESC LIMIT 1 OFFSET 0 [bind: 1->key:'show.log.console', 2->domain_id:203]
> 13.07.2010 14:45:19
> INFO: === returned 1 row. - took 16 ms.
> 13.07.2010 14:45:19
> INFO: +++ transaction committed.
> 13.07.2010 14:45:19
> INFO: --- will run 1 query.
> 13.07.2010 14:45:19
> INFO: --- transaction started.
> 13.07.2010 14:45:19
> INFO: SELECT t0.parent_id, t0.level, t0.id, t0.description, t0.name, t0.version FROM domain t0 WHERE (t0.name = ?) AND (t0.level = ?) [bind: 1->name:'CayenneModeler', 2->level:0]
> 13.07.2010 14:45:19
> INFO: === returned 1 row. - took 0 ms.
> 13.07.2010 14:45:19
> INFO: +++ transaction committed.
> 13.07.2010 14:45:19
> INFO: --- will run 1 query.
> 13.07.2010 14:45:19
> INFO: --- transaction started.
> 13.07.2010 14:45:19
> INFO: SELECT t0.key_value_pairs, t0.domain_id, t0.key, t0.id FROM domain_preference t0 JOIN domain t1 ON (t0.domain_id = t1.id) WHERE (t0.key = ?) AND (t0.domain_id = ?) ORDER BY t1.level DESC LIMIT 1 OFFSET 0 [bind: 1->key:'show.log.console', 2->domain_id:203]
> 13.07.2010 14:45:19
> INFO: === returned 1 row. - took 15 ms.
> 13.07.2010 14:45:19
> INFO: +++ transaction committed.
> 13.07.2010 14:45:26
> INFO: --- will run 1 query.
> 13.07.2010 14:45:26
> INFO: --- transaction started.
> 13.07.2010 14:45:26
> INFO: SELECT t0.key_value_pairs, t0.domain_id, t0.key, t0.id FROM domain_preference t0 JOIN domain t1 ON (t0.domain_id = t1.id) WHERE (t0.key = ?) AND (t0.domain_id = ?) ORDER BY t1.level DESC LIMIT 1 OFFSET 0 [bind: 1->key:'ramasART', 2->domain_id:219]
> 13.07.2010 14:45:26
> INFO: === returned 1 row. - took 0 ms.
> 13.07.2010 14:45:26
> INFO: +++ transaction committed.
> 13.07.2010 14:45:26
> INFO: --- will run 1 query.
> 13.07.2010 14:45:26
> INFO: --- transaction started.
> 13.07.2010 14:45:26
> INFO: SELECT t0.parent_id, t0.level, t0.id, t0.description, t0.name, t0.version FROM domain t0 WHERE (t0.name = ?) AND (t0.level = ?) [bind: 1->name:'CayenneModeler', 2->level:0]
> 13.07.2010 14:45:26
> INFO: === returned 1 row. - took 0 ms.
> 13.07.2010 14:45:26
> INFO: +++ transaction committed.
> 13.07.2010 14:45:26
> INFO: --- will run 1 query.
> 13.07.2010 14:45:26
> INFO: --- transaction started.
> 13.07.2010 14:45:26
> INFO: SELECT t0.domain_preference_id, t0.db_adapter, t0.user_name, t0.password, t0.url, t0.jdbc_driver, t0.id FROM db_connection_info t0 WHERE t0.id IN (?, ?, ?) [bind: 1->id:203, 2->id:209, 3->id:210]
> 13.07.2010 14:45:26
> INFO: === returned 1 row. - took 0 ms.
> 13.07.2010 14:45:26
> INFO: +++ transaction committed.
> 13.07.2010 14:45:35
> INFO: --- will run 1 query.
> 13.07.2010 14:45:35
> INFO: --- transaction started.
> 13.07.2010 14:45:35
> INFO: UPDATE domain_preference SET key_value_pairs = ? WHERE id = ?
> 13.07.2010 14:45:35
> INFO: [bind: 1->key_value_pairs:'#Tue Jul 13 14:45:19 CEST 2010...', 2->id:200]
> 13.07.2010 14:45:35
> INFO: === updated 1 row.
> 13.07.2010 14:45:35
> INFO: +++ transaction committed.
> 13.07.2010 14:45:36
> INFO: --- will run 1 query.
> 13.07.2010 14:45:36
> INFO: --- transaction started.
> 13.07.2010 14:45:36
> INFO: SELECT t0.key_value_pairs, t0.domain_id, t0.key, t0.id FROM domain_preference t0 JOIN domain t1 ON (t0.domain_id = t1.id) WHERE (t0.key = ?) AND (t0.domain_id = ?) ORDER BY t1.level DESC LIMIT 1 OFFSET 0 [bind: 1->key:'DbGenerator', 2->domain_id:217]
> 13.07.2010 14:45:36
> INFO: === returned 1 row. - took 16 ms.
> 13.07.2010 14:45:36
> INFO: +++ transaction committed.
> 13.07.2010 14:45:38
> DEBUG: searching for resource under: org/apache/cayenne/dba/postgres/types.xml
> 13.07.2010 14:45:38
> INFO: Detected and installed adapter: org.apache.cayenne.dba.postgres.PostgresAdapter
> 13.07.2010 14:45:38
> INFO: Error in org.apache.cayenne.modeler.dialog.db.DBGeneratorOptions
> org.apache.cayenne.CayenneRuntimeException: [v.3.0 Apr 26 2010 09:59:17] Undefined type for attribute 'globaldistributer.founders': 2003
> at org.apache.cayenne.dba.postgres.PostgresAdapter.createTable(PostgresAdapter.java:160)
> at org.apache.cayenne.dba.AutoAdapter.createTable(AutoAdapter.java:247)
> at org.apache.cayenne.access.DbGenerator.buildStatements(DbGenerator.java:164)
> at org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:134)
> at org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:105)
> at org.apache.cayenne.modeler.dialog.db.DBGeneratorOptions.prepareGenerator(DBGeneratorOptions.java:148)
> at org.apache.cayenne.modeler.dialog.db.DBGeneratorOptions.<init>(DBGeneratorOptions.java:81)
> at org.apache.cayenne.modeler.action.GenerateDBAction.performAction(GenerateDBAction.java:68)
> at org.apache.cayenne.modeler.util.CayenneAction.actionPerformed(CayenneAction.java:163)
> at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
> at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
> at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
> at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
> at javax.swing.AbstractButton.doClick(AbstractButton.java:357)
> at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1225)
> at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1266)
> at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)
> at java.awt.Component.processMouseEvent(Component.java:6216)
> at javax.swing.JComponent.processMouseEvent(JComponent.java:3265)
> at java.awt.Component.processEvent(Component.java:5981)
> at java.awt.Container.processEvent(Container.java:2041)
> at java.awt.Component.dispatchEventImpl(Component.java:4583)
> at java.awt.Container.dispatchEventImpl(Container.java:2099)
> at java.awt.Component.dispatchEvent(Component.java:4413)
> at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4556)
> at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4220)
> at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4150)
> at java.awt.Container.dispatchEventImpl(Container.java:2085)
> at java.awt.Window.dispatchEventImpl(Window.java:2475)
> at java.awt.Component.dispatchEvent(Component.java:4413)
> at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
> at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
> at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
> at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
> at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
> at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
> at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
> 13.07.2010 14:45:40
> ERROR: CayenneModeler Error
> java.lang.NullPointerException
> at org.apache.cayenne.modeler.pref.DBGeneratorDefaults.configureGenerator(DBGeneratorDefaults.java:29)
> at org.apache.cayenne.modeler.dialog.db.DBGeneratorOptions.<init>(DBGeneratorOptions.java:82)
> at org.apache.cayenne.modeler.action.GenerateDBAction.performAction(GenerateDBAction.java:68)
> at org.apache.cayenne.modeler.util.CayenneAction.actionPerformed(CayenneAction.java:163)
> at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
> at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
> at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
> at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
> at javax.swing.AbstractButton.doClick(AbstractButton.java:357)
> at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1225)
> at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1266)
> at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)
> at java.awt.Component.processMouseEvent(Component.java:6216)
> at javax.swing.JComponent.processMouseEvent(JComponent.java:3265)
> at java.awt.Component.processEvent(Component.java:5981)
> at java.awt.Container.processEvent(Container.java:2041)
> at java.awt.Component.dispatchEventImpl(Component.java:4583)
> at java.awt.Container.dispatchEventImpl(Container.java:2099)
> at java.awt.Component.dispatchEvent(Component.java:4413)
> at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4556)
> at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4220)
> at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4150)
> at java.awt.Container.dispatchEventImpl(Container.java:2085)
> at java.awt.Window.dispatchEventImpl(Window.java:2475)
> at java.awt.Component.dispatchEvent(Component.java:4413)
> at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
> at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
> at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
> at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
> at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
> at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
> at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
> 13.07.2010 14:45:49
> INFO: --- will run 1 query.
> 13.07.2010 14:45:49
> INFO: --- transaction started.
> 13.07.2010 14:45:49
> INFO: SELECT t0.parent_id, t0.level, t0.id, t0.description, t0.name, t0.version FROM domain t0 WHERE (t0.name = ?) AND (t0.level = ?) [bind: 1->name:'CayenneModeler', 2->level:0]
> 13.07.2010 14:45:49
> INFO: === returned 1 row. - took 16 ms.
> 13.07.2010 14:45:49
> INFO: +++ transaction committed.
> 13.07.2010 14:45:49
> INFO: --- will run 1 query.
> 13.07.2010 14:45:49
> INFO: --- transaction started.
> 13.07.2010 14:45:49
> INFO: SELECT t0.key_value_pairs, t0.domain_id, t0.key, t0.id FROM domain_preference t0 JOIN domain t1 ON (t0.domain_id = t1.id) WHERE (t0.key = ?) AND (t0.domain_id = ?) ORDER BY t1.level DESC LIMIT 1 OFFSET 0 [bind: 1->key:'show.log.console', 2->domain_id:203]
> 13.07.2010 14:45:49
> INFO: === returned 1 row. - took 0 ms.
> 13.07.2010 14:45:49
> INFO: +++ transaction committed.
> 13.07.2010 14:45:49
> INFO: --- will run 1 query.
> 13.07.2010 14:45:49
> INFO: --- transaction started.
> 13.07.2010 14:45:49
> INFO: SELECT t0.parent_id, t0.level, t0.id, t0.description, t0.name, t0.version FROM domain t0 WHERE (t0.name = ?) AND (t0.level = ?) [bind: 1->name:'CayenneModeler', 2->level:0]
> 13.07.2010 14:45:49
> INFO: === returned 1 row. - took 0 ms.
> 13.07.2010 14:45:49
> INFO: +++ transaction committed.
> 13.07.2010 14:45:49
> INFO: --- will run 1 query.
> 13.07.2010 14:45:49
> INFO: --- transaction started.
> 13.07.2010 14:45:49
> INFO: SELECT t0.key_value_pairs, t0.domain_id, t0.key, t0.id FROM domain_preference t0 JOIN domain t1 ON (t0.domain_id = t1.id) WHERE (t0.key = ?) AND (t0.domain_id = ?) ORDER BY t1.level DESC LIMIT 1 OFFSET 0 [bind: 1->key:'show.log.console', 2->domain_id:203]
> 13.07.2010 14:45:49
> INFO: === returned 1 row. - took 16 ms.
> 13.07.2010 14:45:49
> INFO: +++ transaction committed.
> 13.07.2010 14:45:49
> INFO: --- will run 1 query.
> 13.07.2010 14:45:49
> INFO: --- transaction started.
> 13.07.2010 14:45:49
> INFO: SELECT t0.parent_id, t0.level, t0.id, t0.description, t0.name, t0.version FROM domain t0 WHERE (t0.name = ?) AND (t0.level = ?) [bind: 1->name:'CayenneModeler', 2->level:0]
> 13.07.2010 14:45:49
> INFO: === returned 1 row. - took 0 ms.
> 13.07.2010 14:45:49
> INFO: +++ transaction committed.
> 13.07.2010 14:45:49
> INFO: --- will run 1 query.
> 13.07.2010 14:45:50
> INFO: --- transaction started.
> 13.07.2010 14:45:50
> INFO: SELECT t0.key_value_pairs, t0.domain_id, t0.key, t0.id FROM domain_preference t0 JOIN domain t1 ON (t0.domain_id = t1.id) WHERE (t0.key = ?) AND (t0.domain_id = ?) ORDER BY t1.level DESC LIMIT 1 OFFSET 0 [bind: 1->key:'log.console.docked', 2->domain_id:203]
> 13.07.2010 14:45:50
> INFO: === returned 1 row. - took 0 ms.
> 13.07.2010 14:45:50
> INFO: +++ transaction committed.
> 13.07.2010 14:45:55
> INFO: --- will run 1 query.
> 13.07.2010 14:45:55
> INFO: --- transaction started.
> 13.07.2010 14:45:55
> INFO: UPDATE domain_preference SET key_value_pairs = ? WHERE id = ?
> 13.07.2010 14:45:55
> INFO: [bind: 1->key_value_pairs:'#Tue Jul 13 14:45:49 CEST 2010...', 2->id:200]
> 13.07.2010 14:45:55
> INFO: === updated 1 row.
> 13.07.2010 14:45:55
> INFO: +++ transaction committed.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.