When a VDB containing view model with a REST procedure is exported as a dynamic VDB, the resulting autogenrated WAR does not work. This is because the generated DDL does not contain the OPTIONS clause with REST properties, not does it contain the required SET NAMESPACE statement Generated DDL: CREATE VIRTUAL PROCEDURE testProc (p1 string(4000)) AS BEGIN SELECT XMLELEMENT(NAME test, XMLFOREST(ProcedureModel.testProc.p1 AS elem1, 'elem2' AS elem2)) AS xml_out; END; Expected DDL (note that this also incorporates TEIIDDES-2697): SET NAMESPACE 'http://teiid.org/rest' AS REST; CREATE VIRTUAL PROCEDURE testProc (p1 string(4000)) RETURNS TABLE (xml_out xml) OPTIONS ("REST:METHOD" 'GET', "REST:URI" 'test/{p1}') AS BEGIN SELECT XMLELEMENT(NAME test, XMLFOREST(ProcedureModel.testProc.p1 AS elem1, 'elem2' AS elem2)) AS xml_out; END; Steps to Reproduce: # import the attached project # generate a dynamic VDB from DynamicProcedureVdb # deploy and execute the dynamic vdb # go to {{http://localhost:8080/dynamicprocedurevdb_1/proceduremodel/test/a}} in the browser, returns 500
Using only JIRA now. Marking as closed
Matus Makovy <mmakovy> updated the status of jira TEIIDDES-2698 to Reopened
Matus Makovy <mmakovy> updated the status of jira TEIIDDES-2698 to Resolved
Matus Makovy <mmakovy> updated the status of jira TEIIDDES-2698 to Closed