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.
1. Connect to "sakila" MySQL DB. 2. Expand "Tables > films > Foreign Keys > fk_film_language". "language_id -> language.language_id" node should be shown. 3. Rightclick "fk_film_language" node and chosse "Refresh". Result: "language_id -> language.language_id" node disappears. Why?
Reassigned to new owner.
The foreign keys are addressed by an internal name - this is only valid for the lifetime of the parent table. On refresh the whole metadata is refreshed and the internal name of the foreign-key changes. You'd have to recreate the whole "Foreign key" - node structure, as everything under it depends volatile data. This also means that an ForeignKey Metadata Handle is not stable accross refreshes.
Created attachment 116823 [details] part1: only use internal name of no real name is provided
Created attachment 116824 [details] part 2: Allow refresh of all foreign keys
Patches applied as http://hg.netbeans.org/core-main/rev/8019c75d5f27 Thank you.
Integrated into 'main-golden', will be available in build *201206200001* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress) Changeset: http://hg.netbeans.org/main-golden/rev/8019c75d5f27 User: Jaroslav Havlin <jhavlin@netbeans.org> Log: #156062: Foreign keys subnodes disappear after refreshing