Return-Path: Delivered-To: apmail-cayenne-commits-archive@www.apache.org Received: (qmail 64792 invoked from network); 13 Jul 2010 13:07:47 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 13 Jul 2010 13:07:47 -0000 Received: (qmail 59903 invoked by uid 500); 13 Jul 2010 13:07:47 -0000 Delivered-To: apmail-cayenne-commits-archive@cayenne.apache.org Received: (qmail 59873 invoked by uid 500); 13 Jul 2010 13:07:46 -0000 Mailing-List: contact commits-help@cayenne.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@cayenne.apache.org Delivered-To: mailing list commits@cayenne.apache.org Received: (qmail 59864 invoked by uid 99); 13 Jul 2010 13:07:45 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 13 Jul 2010 13:07:45 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.22] (HELO thor.apache.org) (140.211.11.22) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 13 Jul 2010 13:07:42 +0000 Received: from thor (localhost [127.0.0.1]) by thor.apache.org (8.13.8+Sun/8.13.8) with ESMTP id o6DCxofe019481 for ; Tue, 13 Jul 2010 12:59:51 GMT Message-ID: <13585959.346841279025990844.JavaMail.jira@thor> Date: Tue, 13 Jul 2010 08:59:50 -0400 (EDT) From: "Andrus Adamchik (JIRA)" To: commits@cayenne.apache.org Subject: [jira] Commented: (CAY-1463) Generate Database Schema - In-Reply-To: <979711.346711279025450605.JavaMail.jira@thor> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 X-Virus-Checked: Checked by ClamAV on apache.org [ 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.(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.(DbGenerator.java:134) > at org.apache.cayenne.access.DbGenerator.(DbGenerator.java:105) > at org.apache.cayenne.modeler.dialog.db.DBGeneratorOptions.prepareGenerator(DBGeneratorOptions.java:148) > at org.apache.cayenne.modeler.dialog.db.DBGeneratorOptions.(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.(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.