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 131586 - FAST:EAP:KBC FAST:PRIORITY:1-CRITICAL WSDL from database wizard fails to show available DB2 tables
Summary: FAST:EAP:KBC FAST:PRIORITY:1-CRITICAL WSDL from database wizard fails to show...
Status: NEW
Alias: None
Product: soa
Classification: Unclassified
Component: -- Other -- (show other bugs)
Version: 6.x
Hardware: All All
: P3 blocker (vote)
Assignee: Narayana Rallabandi
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-03-31 08:46 UTC by mfoster
Modified: 2008-10-01 13:55 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
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 mfoster 2008-03-31 08:46:05 UTC 
This may be a problem with RACF control of the Z/OS DB2 tables as I can get this working against non-RACF controlled DB2
tables.

Will try with M8
Comment 1 Venkat Chellasamy 2008-04-01 22:00:47 UTC 
mark, can you attach log file. did you get a chance to try with M8?
Comment 2 Narayana Rallabandi 2008-04-02 07:51:07 UTC 
I am copying the thread for the context for which I am downgrading this to p3.

--Narayanaa

Venkat Srinivasan wrote:

Pls downgrade this to p3.

Narayana Rallabandi wrote:
> Venkat,
>
> Just now saw the thread.
> Yes, perhaps it helps in other ways too where in we can get the data from Oracle also without depending upon the
DataDirect drivers.
>
> We already have this in the SQL SE/JDBC BC get well plan.
>
> Thanks,
> Narayanaa
>
> Venkat Srinivasan wrote:
>> Mark,
>> Currently we depend on the metadata provided by the jdbc driver, unlike 51x where we query the DB for the metadata.
>>
>> Narayana,
>> May be we should just revert back to the 51x way. This would also ensure driver independence.
>>
>> -VS
>>
>> Mark Foster wrote:
>>> Hi Narayana,
>>>
>>> I'll get KBC to try this with M8 today.
>>>
>>> To save you some work, it would make it much easier if you could tell me how I can see what SQL statement is run to
retrieve the database metadata (list of available tables) in the wizard at that point.
>>> The last time I had an issue like this with "5.1.x DB2 OTD wizard" we were able to view the SQL which had been run
and evaluate it outside of CAPS to determine if it was correct or not (it wasn't).
>>>
>>> Do you know what SQL is run at this point in the wizard ?
>>>
>>> BTW, they are using DB2 on Z/OS with RACF control and the DataDirect drivers
>>>
>>> Thanks
>>> Mark
>>>
>>> 	
>>>
>>> Mark Foster
>>> Field Assist Support Team
>>>
>>> Sun Microsystems, Inc.
>>> Mobile +44 7876 681565
>>> Email Mark.Foster@Sun.COM
>>>
>>> Sun's Open ESB Community (http://open-esb.org)
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> Narayana Rallabandi wrote:
>>>>
>>>> The SQL SE was working with DB2. Might be an issue with RACF control of the Z/OS DB2 tables.
>>>>
>>>> Mark,
>>>>
>>>> Can you please let me know what's the machine you are trying to connect to, since I do not have such setup at IEC
to test? Also please give the information reg. the Drivers you are using for connection.
>>>>
>>>> Thanks,
>>>> Narayanaa
>>>>
>>>>
>>>> Fred Aabedi wrote:
>>>>> Narayana R?
>>>>>
>>>>> Fred Aabedi
>>>>> Open ESB Community http://open-esb.org
>>>>>
>>>>>
>>>>>
>>>>> Venkat Chellasamy wrote:
>>>>>> Fred,
>>>>>>
>>>>>> who is working on the db wizard?
>>>>>>
>>>>
>
	
Venkat R Srinivasan
Sr. Engineering Manager
SOA/Business Integration
Sun Microsystems
Comment 3 Sergey Lunegov 2008-10-01 13:55:05 UTC 
Changed target milestone.