This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.
Summary: | [67cat] org.netbeans.lib.ddl.DDLException: Unable to execute command: drop table "APP"."groups" Operation 'DROP CONSTRAINT' cannot be performed on object 'SQL090512101816021' because CONSTRAINT 'FK_USER_GROUP | ||
---|---|---|---|
Product: | db | Reporter: | aldobrucale <aldobrucale> |
Component: | Code | Assignee: | Jiri Rechtacek <jrechtacek> |
Status: | RESOLVED FIXED | ||
Severity: | blocker | CC: | alex02, diesil, evandro1979, fedesaravia, jgrabowski, jungmat, martin_zmrhal, masaki, mohhmekk, pjiricka, pjulien, ranjan_compmail, sgtgarcia |
Priority: | P3 | ||
Version: | 6.x | ||
Hardware: | All | ||
OS: | All | ||
URL: | http://statistics.netbeans.org/exceptions/detail.do?id=149769 | ||
Issue Type: | DEFECT | Exception Reporter: | 149769 |
Attachments: |
stacktrace
stacktrace stacktrace stacktrace stacktrace stacktrace |
Description
aldobrucale
2009-05-12 09:40:54 UTC
Created attachment 81942 [details]
stacktrace
Build: NetBeans IDE 6.7 Beta (Build 200904242137) VM: Java HotSpot(TM) 64-Bit Server VM, 11.3-b02, Java(TM) SE Runtime Environment, 1.6.0_13-b03 OS: Linux, 2.6.30-020630rc4-generic, amd64 User Comments: Stacktrace: org.netbeans.lib.ddl.DDLException: Unable to execute command: drop table "SPRINGWEBAPPMVC"."STUDENTS" Operacja 'DROP CONSTRAINT' nie mo?e by? wykonana na obiekcie 'SQL090512153806280', poniewa? instrukcja CONSTRAINT 'FK887AB4E733E5FEF8' jest zale?na od tego obiektu. at org.netbeans.lib.ddl.impl.AbstractCommand.execute(AbstractCommand.java:241) at org.netbeans.modules.db.explorer.node.TableNode.destroy(TableNode.java:155) at org.openide.nodes.FilterNode.destroy(FilterNode.java:604) at org.openide.explorer.ExplorerActionsImpl$DeleteActionPerformer.doDestroy(ExplorerActionsImpl.java:645) at org.openide.explorer.ExplorerActionsImpl$DeleteActionPerformer.actionPerformed(ExplorerActionsImpl.java:595) at org.openide.util.actions.CallbackSystemAction$DelegateAction$1.run(CallbackSystemAction.java:593) Created attachment 81969 [details]
stacktrace
This issue already has 10 duplicates see http://statistics.netbeans.org/exceptions/detail.do?id=149769 Build: NetBeans IDE 6.7 RC1 (Build 200905282243) VM: Java HotSpot(TM) Client VM, 14.0-b16, Java(TM) SE Runtime Environment, 1.6.0_14-b08 OS: Windows XP, 5.1, x86 User Comments: Stacktrace: org.netbeans.lib.ddl.DDLException: Unable to execute command: drop table "public"."vyrobce" ERROR: cannot drop table vyrobce because other objects depend on it at org.netbeans.lib.ddl.impl.AbstractCommand.execute(AbstractCommand.java:241) at org.netbeans.modules.db.explorer.node.TableNode.destroy(TableNode.java:155) at org.openide.nodes.FilterNode.destroy(FilterNode.java:604) at org.openide.explorer.ExplorerActionsImpl$DeleteActionPerformer.doDestroy(ExplorerActionsImpl.java:645) at org.openide.explorer.ExplorerActionsImpl$DeleteActionPerformer.actionPerformed(ExplorerActionsImpl.java:595) at org.openide.util.actions.CallbackSystemAction$DelegateAction$1.run(CallbackSystemAction.java:593) Created attachment 83322 [details]
stacktrace
Build: NetBeans IDE Dev (Build web-main-1363-on-090813) VM: Java HotSpot(TM) 64-Bit Server VM, 11.3-b02-83, Java(TM) SE Runtime Environment, 1.6.0_13-b03-211 OS: Mac OS X, 10.5.8, x86_64 User Comments: Deleting several (interconnected) tables at once in the JDBC explorer, Derby. Stacktrace: org.netbeans.lib.ddl.DDLException: Unable to execute command: drop table "APP"."PERSISTENCE_ORDER_VENDOR" Operation 'DROP CONSTRAINT' cannot be performed on object 'SQL090813155957740' because CONSTRAINT 'PRSSTNCRDRVNDVNDRD' is dependent on that object. at org.netbeans.lib.ddl.impl.AbstractCommand.execute(AbstractCommand.java:241) at org.netbeans.modules.db.explorer.node.TableNode.destroy(TableNode.java:155) at org.openide.nodes.FilterNode.destroy(FilterNode.java:604) at org.openide.explorer.ExplorerActionsImpl$DeleteActionPerformer.doDestroy(ExplorerActionsImpl.java:658) at org.openide.explorer.ExplorerActionsImpl$DeleteActionPerformer.actionPerformed(ExplorerActionsImpl.java:608) at org.netbeans.modules.openide.util.ActionsBridge$ActionRunnable$1.run(ActionsBridge.java:108) Created attachment 86201 [details]
stacktrace
Build: NetBeans IDE 6.7.1 (Build 200907230233) VM: Java HotSpot(TM) Client VM, 14.0-b16, Java(TM) SE Runtime Environment, 1.6.0_14-b08 OS: Linux, 2.6.28-15-generic, i386 User Comments: delete a table from the database Stacktrace: org.netbeans.lib.ddl.DDLException: Unable to execute command: drop table "MPAYMENT"."OWNER" ORA-02449: unique/primary keys in table referenced by foreign keys at org.netbeans.lib.ddl.impl.AbstractCommand.execute(AbstractCommand.java:241) at org.netbeans.modules.db.explorer.node.TableNode.destroy(TableNode.java:155) at org.openide.nodes.FilterNode.destroy(FilterNode.java:604) at org.openide.explorer.ExplorerActionsImpl$DeleteActionPerformer.doDestroy(ExplorerActionsImpl.java:658) at org.openide.explorer.ExplorerActionsImpl$DeleteActionPerformer.actionPerformed(ExplorerActionsImpl.java:608) at org.openide.util.actions.CallbackSystemAction$DelegateAction$1.run(CallbackSystemAction.java:593) Created attachment 86387 [details]
stacktrace
I'm investigating what's wrong. core-main/rev/a7c6e1830a22 The exceptions dialogs won't jump anymore. Nevertheless the depending table cannot be dropping still because existing constraints on any its column. Integrated into 'main-golden', will be available in build *200908220201* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress) Changeset: http://hg.netbeans.org/main-golden/rev/a7c6e1830a22 User: Jiri Rechtacek <jrechtacek@netbeans.org> Log: #164915: [67cat] org.netbeans.lib.ddl.DDLException: Unable to execute command: drop table "APP"."groups" Operation 'DROP CONSTRAINT' cannot be performed on object 'SQL090512101816021' because CONSTRAINT 'FK_USER_GROUP Build: NetBeans IDE 6.7.1 (Build 200907230101) VM: Java HotSpot(TM) Client VM, 11.0-b16, Java(TM) SE Runtime Environment, 1.6.0_11-b03 OS: Windows XP, 5.1, x86 User Comments: Stacktrace: org.netbeans.lib.ddl.DDLException: Unable to execute command: drop table `minerva`.`courses` Cannot delete or update a parent row: a foreign key constraint fails at org.netbeans.lib.ddl.impl.AbstractCommand.execute(AbstractCommand.java:241) at org.netbeans.modules.db.explorer.node.TableNode.destroy(TableNode.java:155) at org.openide.nodes.FilterNode.destroy(FilterNode.java:604) at org.openide.explorer.ExplorerActionsImpl$DeleteActionPerformer.doDestroy(ExplorerActionsImpl.java:658) at org.openide.explorer.ExplorerActionsImpl$DeleteActionPerformer.actionPerformed(ExplorerActionsImpl.java:608) at org.openide.util.actions.CallbackSystemAction$DelegateAction$1.run(CallbackSystemAction.java:593) Created attachment 87766 [details]
stacktrace
|