Cannot find "Enable REST for procedures" option.

[dsusin]

Hello,

I'm trying to generate a RESTEasy WAR following the user's guide. I created a get procedure that returns a result as a XMLLiteral, it very simple, a select * from a table in fact, but when I go to the context menu to find the option "Modelling -> Enable REST for procedures" in order to edit the additional properties, the option is nowhere to be found.

The procedure code is as simple as:

CREATE VIRTUAL PROCEDURE
BEGIN
          SELECT XMLELEMENT(NAME offices, XMLAGG(XMLELEMENT(NAME office, XMLFOREST(OFF_NAME, OFF_CITY)))) AS result FROM OFFICES_VIEW.OFFICES_TABLE;
END

Can anyone help me?

Thanks!

[tejones]

Daniel,

You are probably using a newer version of Designer. The "Enable REST for Procedures" option was removed in favor of using extended metadata properties. If you select the procedure in the model explorer and look at the properties panel below, you will the REST properties (URL and PATH). Just set tthose values accordingly and your procedure will be REST enabled.

Thanks,

Ted

[dsusin]

Thanks for the quick answer, I'm using Designer 8, the last one if I'm not mistaken, but URL does not appear on the properties tab, and neither does PATH... I'll detail the steps I followed in case I miss something basic:

- Once I have a view and a table I create a procedure via New Sibling context menu on the table.

- I create a resultset inside the procedure.

- I create a result column inside the resultset with datatype XMLLiteral.

- I create the code of the procedure in the transformation diagram, the code is the one above on the OP.

Now am I supposed to have the REST properties on the procedure's properties tab? In that case I don't...

Thanks again.

[tejones]

Daniel,

I am able to reproduce your scenario. It appears something is broken with the metadata extension logic in 8.0.  In the meantime, please try this as a workaround: https://docs.jboss.org/author/display/teiid82final/REST+Service+Through+VDB

Jira logged here: https://issues.jboss.org/browse/TEIIDDES-1569

Sorry for the hassle and thanks,

Ted

[gioppoluca]

I've seen you already fixed this. Is there any nightly repos available?

Thanks

Luca

[rareddy]

Luca,

I believe you can get nightly of Designer here http://download.jboss.org/jbosstools/updates/nightly/soa-tooling/trunk/

Ramesh..

[gioppoluca]

I found the latest artifact in http://hudson.jboss.org/hudson/job/jbosstools-teiid-designer_trunk/ the latest good artifact is the #2179 and it seems to fix something and have still some quirks.

Luca