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 104623 - Unable to DnD DB table onto dropdown
Summary: Unable to DnD DB table onto dropdown
Status: VERIFIED WORKSFORME
Alias: None
Product: obsolete
Classification: Unclassified
Component: visualweb (show other bugs)
Version: 6.x
Hardware: All All
: P1 blocker (vote)
Assignee: John Baker
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-05-23 15:05 UTC by Lark Fitzgerald
Modified: 2007-07-31 15:50 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
Exception (4.97 KB, text/plain)
2007-05-23 15:06 UTC, Lark Fitzgerald 		Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Lark Fitzgerald 2007-05-23 15:05:40 UTC 
NB6: 200705221200
WS4.1: 200705180325

DnD of table onto dropdown throws: org.apache.derby.client.am.SqlException: 
Table/View 'APP.CUSTOMER' does not exist.

Steps:
1. EE5 project
2. add basic > dropdown
3. Services Tab
4. Start jdbc:derby://localhost:1527/sample [app on APP]
5. DnD customer table onto dropdown

Exception is thrown (attached)
Comment 1 Lark Fitzgerald 2007-05-23 15:06:48 UTC 
Created attachment 42691 [details]
Exception
Comment 2 Lark Fitzgerald 2007-05-23 15:10:06 UTC 
Note: The customerDataProvider is created and SessionBean1 gets the sql 
statement, but if you try to edit the sql an error appears:
APP.CUSTOMER: Error encountered in the query value.
Tables will not display correctly.
Please check the table and column names.

The query shows as:
SELECT * FROM APP.CUSTOMER 

But at the top of the screen the TAB says:
jdbc:derby//localhost:1527/travel [travel on TRAVEL]

which is wrong.
Comment 3 John Baker 2007-05-30 03:41:28 UTC 
subcomponent should be database, not databinding
Comment 4 John Baker 2007-06-20 02:12:11 UTC 
works for me.

query generated is 

SELECT ALL "APP"."CUSTOMER"."CUSTOMER_ID", 
                    "APP"."CUSTOMER"."DISCOUNT_CODE", 
                    "APP"."CUSTOMER"."ZIP", 
                    "APP"."CUSTOMER"."NAME", 
                    "APP"."CUSTOMER"."ADDRESSLINE1", 
                    "APP"."CUSTOMER"."ADDRESSLINE2", 
                    "APP"."CUSTOMER"."CITY", 
                    "APP"."CUSTOMER"."STATE", 
                    "APP"."CUSTOMER"."PHONE", 
                    "APP"."CUSTOMER"."FAX", 
                    "APP"."CUSTOMER"."EMAIL", 
                    "APP"."CUSTOMER"."CREDIT_LIMIT" 
FROM APP.CUSTOMER 

I do notice the tab label shows the wrong connection.  I can file this issue
Comment 5 John Baker 2007-06-22 07:35:26 UTC 
works for me
Comment 6 _ alexpetrov 2007-07-31 15:50:15 UTC 
Product Version: NetBeans IDE Dev (Build 200707270000) 
Java: 1.6.0_02; Java HotSpot(TM) Client VM 1.6.0_02-b06 
System: Windows XP version 5.1 running on x86; 

Woodstock 4.1 JSF Components Release: Build 9 200707261055 (07/27/2007)

Verified - not reproduced.