[teiid-issues] [JBoss JIRA] Commented: (TEIID-817) XML-Relational connector is not handling = criteria.

Thu Sep 10 15:32:23 EDT 2009

    [ https://jira.jboss.org/jira/browse/TEIID-817?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12485283#action_12485283 ] 

Steven Hawkins commented on TEIID-817:
--------------------------------------

The request table(s) just has to map to a "request" whether it takes the form of a SOAP call or just a http get with parameters.  John could cover all of the connector/designer magic for handling that.  An access pattern always exists on the id column of a response table.  You could also have access patterns covering required parameters.

The alternative we've talked about before is to treat the source access and table extraction as primary and separate functions of Teiid.  Executing a web service could have a procedure like xml getDoc(xml param) - which is essentially the approach of the XML Source logic.  On top of that there can be helper SQL/XML like functions to map a rowset to xml, such as xmlforest, and the result xml to "tables" - something like extract(xml param, xpath as col1, xpath as col2....).  At the very least adding a rowset or table type.

> XML-Relational connector is not handling = criteria.
> ----------------------------------------------------
>
>                 Key: TEIID-817
>                 URL: https://jira.jboss.org/jira/browse/TEIID-817
>             Project: Teiid
>          Issue Type: Bug
>    Affects Versions: 6.1.0, 6.2.0
>            Reporter: John Doyle
>            Assignee: John Doyle
>             Fix For: 6.2.0
>
>
> All XML-R connectors are ignoring = criteria passed in queries.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira