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

Summary:	Query Editor: changing in SQL statement has no effect on Table Layout
Product:	obsolete	Reporter:	_ alexpetrov <alexpetrov>
Component:	visualweb	Assignee:	John Baker <jbaker>
Status:	NEW ---
Severity:	blocker
Priority:	P4
Version:	6.x
Hardware:	All
OS:	All
Issue Type:	DEFECT	Exception Reporter:

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.

Result:
- 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.