Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-2698

REST procedure in generated dynamic VDB does not work

    XMLWordPrintable

Details

    Description

      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, nor 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;
      

      Attachments

        Issue Links

          Activity

            People

              mdrillin1@redhat.com Mark Drilling
              asmigala@redhat.com Andrej Smigala
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: