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.0M10 (build 200706260050) Java: 1.6.0_01; Java HotSpot(TM) Client VM 1.6.0_01-b06 System: Windows XP version 5.1 running on x86; Cp1251; ru_RU (nb) 1. Connect to DB Derby Travel. 2. Create new VWP project. 3. DnD DB table "PERSON" on Designer View. 4. In the window "Navigator" expand tree node "SessionBean1" and select tree subnode "personRowSet". Result: - the name of this RowSet-subnode contains SQL satement "SELECT * FROM TRAVEL.PERSON" - its property "command" in the window "Properties" also contains SQL statement "SELECT * FROM TRAVEL.PERSON" - SessionBean1.java contains the line "personRowSet.setCommand("SELECT * FROM TRAVEL.PERSON");" 5. Use popup menu item "Edit SQL Statement" for selected "personRowSet" (Query Editor window will be opened) Result: - Query Editor contains quite another SQL statement: SELECT ALL "TRAVEL"."PERSON"."PERSONID", "TRAVEL"."PERSON"."NAME", "TRAVEL"."PERSON"."JOBTITLE", "TRAVEL"."PERSON"."FREQUENTFLYER", "TRAVEL"."PERSON"."LASTUPDATED" FROM TRAVEL.PERSON - previous SQL statement "SELECT * ..." will be changed to this new SQL satement "SELECT ALL ..." in the RowSet-subnode name, in the property "command", in the "SessionBean1.java". But definitely "SELECT * " isn't quite equal to "SELECT ALL " ("*" != "ALL" in SQL-92)
More correctly: I have in mind that SQL statement "SELECT * ..." shouldn't be changed to "SELECT ALL <db_column_list> ..." without user approval.
*** This issue has been marked as a duplicate of 103287 ***
Closed as duplicate of http://www.netbeans.org/issues/show_bug.cgi?id=103287