[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-1566) Create Web Service On procedure generates invalid sql
[
https://issues.jboss.org/browse/TEIIDDES-1566?page=com.atlassian.jira.plu...
]
Barry LaFond edited comment on TEIIDDES-1566 at 1/31/13 9:02 AM:
-----------------------------------------------------------------
Completed.
In GenerateXsdHelper.generateSql() method added a object type check. If Result Set object,
then delegate to the procedure's full name instead.
{code}
if( source instanceof ProcedureResult) {
newSql.append(TransformationHelper.getSqlEObjectFullName(((ProcedureResult)source).getProcedure()));
} else {
newSql.append(TransformationHelper.getSqlEObjectFullName(source));
}
{code}
Note the commit message incorrectly references JIRA 1572 instead of this one.
was (Author: blafond):
Completed.
In GenerateXsdHelper.generateSql() method added a object type check. If Result Set object,
then delegate to the procedure's full name instead.
{code}
if( source instanceof ProcedureResult) {
newSql.append(TransformationHelper.getSqlEObjectFullName(((ProcedureResult)source).getProcedure()));
} else {
newSql.append(TransformationHelper.getSqlEObjectFullName(source));
}
{code}
Create Web Service On procedure generates invalid sql
-----------------------------------------------------
Key: TEIIDDES-1566
URL: https://issues.jboss.org/browse/TEIIDDES-1566
Project: Teiid Designer
Issue Type: Bug
Components: Web Services Support
Affects Versions: 7.4.2
Environment: Windows 7
Reporter: Michael Conner
Assignee: Barry LaFond
Priority: Minor
Fix For: 8.1
# I select on a procedure, {{Rsw_CustomerUnitProc}}, whose result is
{{Rsw_CustomerUnitResult}}.
# Choose Modeling > Create Web Service
# Enter in the appropriate info in the web service, including {{Rsw_CustomerUnit_Output}}
for the Output Schema Model.
The generated code for the output Model Transformation Editor is:
{code}
SELECT
*
FROM
Procedures.Rsw_CustomerUnitProc.Rsw_CustomerUnitResult
{code}
And there is an error:
{{ERROR: Group does not exist: Procedures.Rsw_CustomerUnitProc.Rsw_CustomerUnitResult}}
Removing the Result seems to fix the problem:
{code}
SELECT
*
FROM
Procedures.Rsw_CustomerUnitProc
{code}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira