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.

Bug 119519 - Query Editor: changing in SQL statement has no effect on Table Layout
Summary: Query Editor: changing in SQL statement has no effect on Table Layout
Status: NEW
Alias: None
Product: obsolete
Classification: Unclassified
Component: visualweb (show other bugs)
Version: 6.x
Hardware: All All
: P4 blocker (vote)
Assignee: John Baker
Depends on:
Reported: 2007-10-19 20:56 UTC by _ alexpetrov
Modified: 2007-10-23 12:43 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:


Note You need to log in before you can comment on or make changes to this bug.
Description _ alexpetrov 2007-10-19 20:56:11 UTC
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.

- JSF component Table doesn't contain the column "TRIPTYPEID" (list item "TRIPTYPEID" isn't presented 
  in the list "Selected" of Table Layout).
Comment 1 John Baker 2007-10-19 22:32:28 UTC
I will evaluate if visualweb is used
Comment 2 John Baker 2007-10-19 22:58:53 UTC
I can reproduce.This may not be a Query Editor issue though, could be data provider
Comment 3 Andrei Badea 2007-10-22 14:18:43 UTC
So where exactly is the issue? Would be good to know that before setting the target milestone.
Comment 4 John Baker 2007-10-22 18:39:32 UTC
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
Comment 5 John Baker 2007-10-22 19:04:55 UTC
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
Comment 6 Andrei Badea 2007-10-23 12:43:06 UTC
So if I understand correctly the issue is not in the visual SQL editor.