[JBoss JIRA] (TEIIDDES-2942) Procedure input parameter has result in the generated DDL
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2942?page=com.atlassian.jira.plu... ]
Barry LaFond edited comment on TEIIDDES-2942 at 10/24/16 9:31 AM:
------------------------------------------------------------------
10.0.x:
* https://github.com/Teiid-Designer/teiid-designer/commit/46d93354e3ee1a1fc...
* https://github.com/Teiid-Designer/teiid-designer/commit/710aa164b426deaa6... (fixed test and added missing constant change)
was (Author: blafond):
10.0.x: https://github.com/Teiid-Designer/teiid-designer/commit/46d93354e3ee1a1fc...
> Procedure input parameter has result in the generated DDL
> ---------------------------------------------------------
>
> Key: TEIIDDES-2942
> URL: https://issues.jboss.org/browse/TEIIDDES-2942
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dynamic VDBs
> Affects Versions: 10.0.2
> Environment: Fedora 24
> Reporter: Matej Kralik
> Priority: Critical
> Fix For: 10.0.2
>
> Attachments: ddlProject.zip
>
>
> I have a procedure with one input parameter. When I want to preview this procedure or deploy dynamic VDB, server shows me error that:
> {code:java}
> TEIID31100 Parsing error: Encountered "(4000) [*]result[*]) RETURNS" at line 2, column 52.
> Procedure testProc RESULT param p1 must be of type OUT.
> {code}
> I noticed that generated dynamic VDB contains 'result' in this parameter but this parameter has set direction to IN. When I delete the result from dynamic VDB, the procedure works fine.
> Actual DDL:
> {code:java}
> CREATE VIRTUAL PROCEDURE testProc (p1 string(4000) result) 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;
> {code}
> expected DDL:
> {code:java}
> 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;
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
7 years, 11 months
[JBoss JIRA] (TEIIDDES-2948) Created REST Connection Profile isn't appearing in Designer
by stanislav kaleta (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2948?page=com.atlassian.jira.plu... ]
stanislav kaleta updated TEIIDDES-2948:
---------------------------------------
Description:
Use Steps to Reproduce to create REST Connection Profile. I assume Connection Profile is created because if u try to create another CP with same name it shows error that CP with given name already exists. However if you check Data Source Explorer, no REST CP is there.
Also when I try _Import.../Teiid Designer/Web Service Source >> Source and View Model (REST)_, following _REST WebService Source_ combo box is empty. (Using _New..._ (next to combo box) should create CP, however combo box remains empty after creation)
was:
Use Steps to Reproduce to create REST Connection Profile. I assume Connection Profile is created because if u try to create another CP with same name it shows error that CP with given name already exists. However if you check Data Source Explorer, no REST CP is there.
Also when I try _Import.../Teiid Designer/Web Service Source >> Source and View Model (REST)_, following _REST WebService Source_ combo box is empty. (Using _New..._, next to combo box, should create CP, however combo box remains empty after creation)
> Created REST Connection Profile isn't appearing in Designer
> -----------------------------------------------------------
>
> Key: TEIIDDES-2948
> URL: https://issues.jboss.org/browse/TEIIDDES-2948
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 10.0.2
> Reporter: stanislav kaleta
> Priority: Blocker
>
> Use Steps to Reproduce to create REST Connection Profile. I assume Connection Profile is created because if u try to create another CP with same name it shows error that CP with given name already exists. However if you check Data Source Explorer, no REST CP is there.
> Also when I try _Import.../Teiid Designer/Web Service Source >> Source and View Model (REST)_, following _REST WebService Source_ combo box is empty. (Using _New..._ (next to combo box) should create CP, however combo box remains empty after creation)
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
7 years, 11 months
[JBoss JIRA] (TEIIDDES-2948) Created REST Connection Profile isn't appearing in Designer
by stanislav kaleta (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2948?page=com.atlassian.jira.plu... ]
stanislav kaleta updated TEIIDDES-2948:
---------------------------------------
Description:
Use Steps to Reproduce to create REST Connection Profile. I assume Connection Profile is created because if u try to create another CP with same name it shows error that CP with given name already exists. However if you check Data Source Explorer, no REST CP is there.
Also when I try _Import.../Teiid Designer/Web Service Source >> Source and View Model (REST)_, following _REST WebService Source_ combo box is empty. (Using _New..._, next to combo box, should create CP, however combo box remains empty after creation)
was:
Use Steps to Reproduce to create REST Connection Profile. I assume Connection Profile is created because if u try to create another CP with same name it shows error that CP with given name already exists. However if you check Data Source Explorer, no REST CP is there.
Also when I try _Import.../Teiid Designer/Web Service Source >> Source and View Model (REST)_, following _REST WebService Source_ combo box is empty. (Using _New..._ next to combo box, should create CP, however combo box remains empty after creation)
> Created REST Connection Profile isn't appearing in Designer
> -----------------------------------------------------------
>
> Key: TEIIDDES-2948
> URL: https://issues.jboss.org/browse/TEIIDDES-2948
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 10.0.2
> Reporter: stanislav kaleta
> Priority: Blocker
>
> Use Steps to Reproduce to create REST Connection Profile. I assume Connection Profile is created because if u try to create another CP with same name it shows error that CP with given name already exists. However if you check Data Source Explorer, no REST CP is there.
> Also when I try _Import.../Teiid Designer/Web Service Source >> Source and View Model (REST)_, following _REST WebService Source_ combo box is empty. (Using _New..._, next to combo box, should create CP, however combo box remains empty after creation)
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
7 years, 11 months
[JBoss JIRA] (TEIIDDES-2948) Created REST Connection Profile isn't appearing in Designer
by stanislav kaleta (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2948?page=com.atlassian.jira.plu... ]
stanislav kaleta updated TEIIDDES-2948:
---------------------------------------
Description:
Use Steps to Reproduce to create REST Connection Profile. Connection Profile is created because if u try to create another CP with same name it shows error that CP with given name already exists. However if you check Data Source Explorer, no REST CP is there.
Also when I try _Import.../Teiid Designer/Web Service Source >> Source and View Model (REST)_, following _REST WebService Source_ combo box is empty. (Using _New..._ next to combo box, should create CP, however combo box remains empty after creation)
was:
Use Steps to Reproduce to create REST Connection Profile. Connection Profile is created because if u try to create another CP with same name it shows error that CP with given name already exists. However if you check Data Source Explorer, no REST CP is there.
Also when I try _Import.../Teiid Designer/Web Service Source >> Source and View Model (REST)_, following _REST WebService Source_ combo box is empty.
> Created REST Connection Profile isn't appearing in Designer
> -----------------------------------------------------------
>
> Key: TEIIDDES-2948
> URL: https://issues.jboss.org/browse/TEIIDDES-2948
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 10.0.2
> Reporter: stanislav kaleta
> Priority: Blocker
>
> Use Steps to Reproduce to create REST Connection Profile. Connection Profile is created because if u try to create another CP with same name it shows error that CP with given name already exists. However if you check Data Source Explorer, no REST CP is there.
> Also when I try _Import.../Teiid Designer/Web Service Source >> Source and View Model (REST)_, following _REST WebService Source_ combo box is empty. (Using _New..._ next to combo box, should create CP, however combo box remains empty after creation)
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
7 years, 11 months
[JBoss JIRA] (TEIIDDES-2948) Created REST Connection Profile isn't appearing in Designer
by stanislav kaleta (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2948?page=com.atlassian.jira.plu... ]
stanislav kaleta updated TEIIDDES-2948:
---------------------------------------
Description:
Use Steps to Reproduce to create REST Connection Profile. I assume Connection Profile is created because if u try to create another CP with same name it shows error that CP with given name already exists. However if you check Data Source Explorer, no REST CP is there.
Also when I try _Import.../Teiid Designer/Web Service Source >> Source and View Model (REST)_, following _REST WebService Source_ combo box is empty. (Using _New..._ next to combo box, should create CP, however combo box remains empty after creation)
was:
Use Steps to Reproduce to create REST Connection Profile. Connection Profile is created because if u try to create another CP with same name it shows error that CP with given name already exists. However if you check Data Source Explorer, no REST CP is there.
Also when I try _Import.../Teiid Designer/Web Service Source >> Source and View Model (REST)_, following _REST WebService Source_ combo box is empty. (Using _New..._ next to combo box, should create CP, however combo box remains empty after creation)
> Created REST Connection Profile isn't appearing in Designer
> -----------------------------------------------------------
>
> Key: TEIIDDES-2948
> URL: https://issues.jboss.org/browse/TEIIDDES-2948
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 10.0.2
> Reporter: stanislav kaleta
> Priority: Blocker
>
> Use Steps to Reproduce to create REST Connection Profile. I assume Connection Profile is created because if u try to create another CP with same name it shows error that CP with given name already exists. However if you check Data Source Explorer, no REST CP is there.
> Also when I try _Import.../Teiid Designer/Web Service Source >> Source and View Model (REST)_, following _REST WebService Source_ combo box is empty. (Using _New..._ next to combo box, should create CP, however combo box remains empty after creation)
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
7 years, 11 months
[JBoss JIRA] (TEIIDDES-2948) Created REST Connection Profile isn't appearing in Designer
by stanislav kaleta (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2948?page=com.atlassian.jira.plu... ]
stanislav kaleta updated TEIIDDES-2948:
---------------------------------------
Description:
Use Steps to Reproduce to create REST Connection Profile. Connection Profile is created because if u try to create another CP with same name it shows error that CP with given name already exists. However if you check Data Source Explorer, no REST CP is there.
Also when I try _Import.../Teiid Designer/Web Service Source >> Source and View Model (REST)_, following _REST WebService Source_ combo box is empty.
was:
Use Steps to Reproduce to create REST Connection Profile. Connection Profile is created because if u try to create another CP with same name it shows error that CP with given name already exists. However if you check Data Source Explorer, no REST CP is there.
Also when I try Import.../Teiid Designer/Web Service Source >> Source and View Model (REST), combo box REST WebService Source is empty.
> Created REST Connection Profile isn't appearing in Designer
> -----------------------------------------------------------
>
> Key: TEIIDDES-2948
> URL: https://issues.jboss.org/browse/TEIIDDES-2948
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 10.0.2
> Reporter: stanislav kaleta
> Priority: Blocker
>
> Use Steps to Reproduce to create REST Connection Profile. Connection Profile is created because if u try to create another CP with same name it shows error that CP with given name already exists. However if you check Data Source Explorer, no REST CP is there.
> Also when I try _Import.../Teiid Designer/Web Service Source >> Source and View Model (REST)_, following _REST WebService Source_ combo box is empty.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
7 years, 11 months
[JBoss JIRA] (TEIIDDES-2948) Created REST Connection Profile isn't appearing in Designer
by stanislav kaleta (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2948?page=com.atlassian.jira.plu... ]
stanislav kaleta updated TEIIDDES-2948:
---------------------------------------
Description:
Use Steps to Reproduce to create REST Connection Profile. Connection Profile is created because if u try to create another CP with same name it shows error that CP with given name already exists. However if you check Data Source Explorer, no REST CP is there.
Also when I try Import.../Teiid Designer/Web Service Source >> Source and View Model (REST), combo box REST WebService Source is empty.
was:...
> Created REST Connection Profile isn't appearing in Designer
> -----------------------------------------------------------
>
> Key: TEIIDDES-2948
> URL: https://issues.jboss.org/browse/TEIIDDES-2948
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 10.0.2
> Reporter: stanislav kaleta
> Priority: Blocker
>
> Use Steps to Reproduce to create REST Connection Profile. Connection Profile is created because if u try to create another CP with same name it shows error that CP with given name already exists. However if you check Data Source Explorer, no REST CP is there.
> Also when I try Import.../Teiid Designer/Web Service Source >> Source and View Model (REST), combo box REST WebService Source is empty.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
7 years, 11 months