[
https://issues.jboss.org/browse/TEIIDDES-2284?page=com.atlassian.jira.plu...
]
Barry LaFond commented on TEIIDDES-2284:
----------------------------------------
Here is the Generated SQL for the google search WS REST use-case....
{code}
BEGIN
DECLARE STRING VARIABLES.qp =
QUERYSTRING('http://www.google.com/complete/search';, ViewModel.google.q AS q,
ViewModel.google."output" AS "output");
SELECT A.suggestion AS suggestion FROM (EXEC SourceModel.invokeHttp('GET', null,
VARIABLES.qp, 'TRUE')) AS f,
XMLTABLE('/toplevel' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS suggestion
string PATH 'CompleteSuggestion/suggestion/text()') AS A;
END
{code}
Here is the current exception trying to execute the VDB:
org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote
org.teiid.core.TeiidProcessingException: *TEIID30151 Error building Source for context
item.*
[~shawkins] Any idea why this SQL isnt' working?
Preview Error for REST Web Service Source
-----------------------------------------
Key: TEIIDDES-2284
URL:
https://issues.jboss.org/browse/TEIIDDES-2284
Project: Teiid Designer
Issue Type: Bug
Components: Data Preview
Affects Versions: 8.6
Reporter: Ted Jones
Assignee: Ted Jones
Priority: Blocker
Fix For: 8.6.1, 9.0
When previewing a procedure that invokes a REST web service source, I get the following
error:
select * from ( exec
"ViewModel"."google"('toolbar','reciever') ) AS X_X
org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote
org.teiid.core.TeiidProcessingException: TEIID30152 Failed to evaluate XQuery expression;
Please check the query and correct errors in syntax or usage.
However, if I add the view procedure to a VDB and deploy, I am able to execute without
error.
GOOGLE SEARCH URL:
http://www.google.com/complete/search
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)