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

          is incorporated by

          Task - Represents a small unit of work that is not end-user facing. TEIIDDES-2699 Issues with Dynamic VDB import/export

          • Blocker - To be worked above all other priorities. This term is chosen when the severity of the issue is very high, has no workaround, or the effort for the change is comparatively low. Issues that may be very publicly visible and could generate significant media attention may also drive a higher priority.
          • Closed

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: