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 138786 - NB 6.1 SQL engine and BPEL engine incompatible
Summary: NB 6.1 SQL engine and BPEL engine incompatible
Status: NEW
Alias: None
Product: soa
Classification: Unclassified
Component: SQL Project (show other bugs)
Version: 6.x
Hardware: All All
: P3 blocker (vote)
Assignee: Venkat Srinivasan
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-07-02 09:29 UTC by siitpe
Modified: 2008-10-01 14:28 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 siitpe 2008-07-02 09:29:40 UTC 
NB 6.1 and SQL server 2005: NB SQL module generates WSDL where SQL result set is 1..n records tagged with <record>.
When SQL module is run, no errors, result set does not have <record> tags but only sequences of result data !?!?!?.
Referencing data fields of SQL result set in Bpel process fail and generate error: Selection Failure occurred in BPEL
To reproduce:
1. Create simple SQL module with sql command "SELECT name,age FROM employees WHERE personId > ? AND personId < ?", build
2. Create corresponding Composite application, build and deploy. Test. 
3. Create simple Bpel process which uses SQL operation, build
4. Create corresponding Composite application, build and deploy. 
5. When debugged: invoke to SQL  module returns data but when trying to assign sql data to operation output variable fails.
Comment 1 siitpe 2008-07-11 10:14:03 UTC 
Any progress with NB 6.1 SQL engine? 
NB 6.5m seems to to have same issue: SQL engine return message is not like WSDL commands it to be:
Results should be tagged as set of records, not sequences of fields...

regards Pentti
Comment 2 Sergey Lunegov 2008-10-01 14:28:23 UTC 
Changed target milestone.