Bug 780375 (SOA-2786)

Summary: Teiid Designer should create models for the WS translator invoke and invokeHttp procedures and the File translator getFiles procedure.
Product: [JBoss] JBoss Enterprise SOA Platform 5 Reporter: John Doyle <jdoyle>
Component: ToolingAssignee: Dana Mison <dmison>
Status: CLOSED NEXTRELEASE QA Contact:
Severity: high Docs Contact:
Priority: high    
Version: 5.1.0.ER6CC: blafond, shawkins
Target Milestone: ---   
Target Release: 5.1.0 GA   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/SOA-2786
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2011-02-15 21:32:24 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Attachments:
Description Flags
SOA-2786.patch.txt none

Description John Doyle 2011-01-14 20:44:43 UTC 
Affects: Documentation (Ref Guide, User Guide, etc.)
Workaround: Workaround Exists
Workaround Description: Users can create the procedures manually.
project_key: SOA

If a user models a SOAP service defined by a WSDL using the WSDL to Relational Model importer, the importer creates the invoke() physical procedure for the user.  The execute procedure is required to execute the translator/connector.  

If the service is not defined by a WSDL (ie. REST service, XML RPC service, ...), or is File based, then the user  currently has to go through the error prone process of creating the physical models that define the procedures for the File and WS translators.  Since the declaration of these procedures is static and known, JBDS/Teiid Designer should create the models for the user.

For the File Translator we should define getFiles, getTextFiles, and saveFile.
For the WS Translator we should define invoke and invokeHttp.
Comment 1 John Doyle 2011-01-18 18:15:25 UTC 
Link: Added: This issue Cloned to SOA-2803
Comment 2 John Doyle 2011-01-18 18:16:06 UTC 
Link: Removed: This issue Cloned to SOA-2803
Comment 3 John Doyle 2011-01-18 18:52:50 UTC 
Link: Added: This issue Cloned to SOA-2805
Comment 4 Barry LaFond 2011-01-20 21:10:27 UTC 
Patch/fix is now available from TEIIDDES-781 that introduces an option in the New Model > Relational model wizard to "Create File Translator procecdures". This simplifies the use-case and prevents user-error.

Recommend applying patch and getting in to JBDS CR2.
Comment 5 Steven Hawkins 2011-02-11 21:13:50 UTC 
on the trunk version I'm seeing invoke/invokeHttp with result parameter modeled as IN rather than as a result.  invokeHttp contenttype should also be an OUT parameter.
Comment 6 Steven Hawkins 2011-02-11 21:16:36 UTC 
also all parameters to invoke/invokeHttp should be nullable.
Comment 7 John Doyle 2011-02-11 22:21:36 UTC 
A patch for shawkins comments.  Fear that this may have missed the boat.  User can modify these operations manually as a workaround.
Comment 8 John Doyle 2011-02-11 22:21:36 UTC 
Attachment: Added: SOA-2786.patch.txt
Comment 9 John Doyle 2011-02-15 21:28:16 UTC 
Adding remaining bug to Teiid Designer queue.
Comment 10 John Doyle 2011-02-15 21:28:16 UTC 
Link: Added: This issue is related to TEIIDDES-869
Comment 11 John Doyle 2011-02-15 21:32:24 UTC 
Release Notes Docs Status: Added: Not Yet Documented
Release Notes Text: Added: The procedures created by the Teiid Designer's New Model Wizard for the Web Service Translator models the 'result' and 'contentype' parameters as IN parameters.  They should be modeled as OUT parameters.  Also, all the parameters should be modeled as 'nullable'.  The user can edit these properties on the procedures to correct the model.
Comment 12 Dana Mison 2011-02-16 00:52:11 UTC 
Release Notes Docs Status: Removed: Not Yet Documented Added: Documented as Known Issue
Writer: Added: Darrin
Release Notes Text: Removed: The procedures created by the Teiid Designer's New Model Wizard for the Web Service Translator models the 'result' and 'contentype' parameters as IN parameters.  They should be modeled as OUT parameters.  Also, all the parameters should be modeled as 'nullable'.  The user can edit these properties on the procedures to correct the model. Added: https://issues.jboss.org/browse/TEIIDDES-869
The procedures created by the JBoss Developer Studio Teiid Designer's "New Model Wizard" for the Web Service Translator models the 'result' and 'contentype' parameters as IN parameters.  They should be modeled as OUT parameters.  Also, all the parameters should be modeled as 'nullable'.  As a workaround you must edit these properties on the procedures to correct the model.