[JBoss JIRA] (TEIIDDES-325) Web Service As Relational importer cannot handle web services that have an input but no output
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-325?page=com.atlassian.jira.plug... ]
Barry LaFond updated TEIIDDES-325:
----------------------------------
Fix Version/s: 7.7.1
> Web Service As Relational importer cannot handle web services that have an input but no output
> ----------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-325
> URL: https://issues.jboss.org/browse/TEIIDDES-325
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Environment: 5.5SP3 GA Designer on Linux
> Reporter: Greg Haber
> Assignee: Barry LaFond
> Fix For: 7.7.1
>
> Attachments: StockQuoteService-ghh.wsdl, StockQuoteService.wsdl
>
>
> If you try to use the Web Service As Relational Importer on the attached StockQuoteService.wsdl file (a sample from the Axis2 1.3 distribution), you'll find that while it passes validation, if on the WSDL Operations Selection screen you leave the selections at their defaults (both of the SOAP 1.1 web services selected, and the SOAP 1.2 web services unchecked), when you press Finish you'll get an NPE. But if you uncheck the "update" service (leaving only getPrice selected), then you can click Finish and create the source model.
> The issue with the "update" operation is that it is an operation with an input but no output. If you modify the WSDL so that this service does indeed have an output (per the StockQuoteService-greg.wsdl attached), both services will import successfully.
> We should be able to handle such operations (ones with no output).
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 11 months
[JBoss JIRA] (TEIIDDES-319) Request for single table import option in Web Service As Relational web service
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-319?page=com.atlassian.jira.plug... ]
Barry LaFond updated TEIIDDES-319:
----------------------------------
Fix Version/s: 7.7.1
> Request for single table import option in Web Service As Relational web service
> -------------------------------------------------------------------------------
>
> Key: TEIIDDES-319
> URL: https://issues.jboss.org/browse/TEIIDDES-319
> Project: Teiid Designer
> Issue Type: Feature Request
> Affects Versions: Future
> Environment: 5.5.3 GA on Linux
> Reporter: Greg Haber
> Assignee: Barry LaFond
> Fix For: 7.7.1
>
>
> This is a longer term feature request - not expecting any near term resolution.
> It would be great if the web service as relational importer could have an option to model a web service with a single table representing both the request and response, instead of as separate tables as today. Not sure if it makes sense to allow this for heirarchical response web services, or only simple ones returning a flat schema.
> Whenever possible I always manually model web service connections this way because of the pros - but would be much better if the importer would do it for me.
> Pros:
> -Would avoid multiple queries to web service connector for a single web service call (since XML-Relational connectors don't support join pushdown) - simpler query plans
> -With that single call it lessens use/paves way for disabling the XML-Relational connector internal doc cache (which, at least in 5.0SP2, was a _big_ bottleneck in the field with concurrent calls to the same web service, if the web service takes more than a few seconds to respond - I believe because the whole doc cache is locked on both read and write, effectively resulting in single threaded and blocking behavior. Anyway, just speculating on the cause, but it is established that in 5.0SP2 that single-table web services were much faster than multi-table ones).
> -Would work in preview
> Cons:
> -Does not logically represent the way web services actually work
> -Confusing as it jumbles together elements from two XML docs in a single relational base table
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 11 months