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.
Product Version: NetBeans IDE 6.0 Beta 2 (Build 200710181000) Java: 1.6.0_03; Java HotSpot(TM) Client VM 1.6.0_03-b02 System: Windows XP version 5.1 running on x86 1. Connect to DB Derby Travel 2. Create new WVP project (JavaEE 5, Glassfish V2, Visual Web JavaServer Faces) 3. DnD JSF component Table on Designer, DnD DB table "TRIP" on it. 4. In the window Navigator click twice on tree subnode "SessionBean1 -> tripRowSet" to open Query Editor. 5. Unmark checkbox "TRIPTYPEID" on diagram and mark it again. Save All. 6. Return to Page1. Result: - JSF component Table doesn't contain the column "TRIPTYPEID" (list item "TRIPTYPEID" isn't presented in the list "Selected" of Table Layout).
I will evaluate if visualweb is used
I can reproduce.This may not be a Query Editor issue though, could be data provider
So where exactly is the issue? Would be good to know that before setting the target milestone.
When a Table component is bound to a rowset which is defined by a query, then the Table component columns correspond to the display values of the query. If the underlying query is changed then the columns of the Table component should be updated. In this case, the available display columns are correctly updated once the TRIPTYPEID is "removed" from the query. However, the TRIPTYPEID is not "restored" as part of the query - TRIPTYPEID is no longer available as a display column of the Table component. This worked in Creator2, but I'd like to test this in 5.5
I tested again in 6.0 using the latest trunk build and now TRIPTYPEID is appearing in the Available columns list instead of the Displayed columns list. This is fairly minor since there is an easy workaround (In the Table layout customizer, move TRIPTYPEID from the Available list to the Displayed list by clicking the arrow button) so I'm downgrading the priority
So if I understand correctly the issue is not in the visual SQL editor.