[JBoss JIRA] (TEIIDDES-1430) WSDL to Relational Source importer generates incorrect SQL for response (Windows only)
7:45 p.m.
[
https://issues.jboss.org/browse/TEIIDDES-1430?page=com.atlassian.jira.plu...
]
RH Bugzilla Integration commented on TEIIDDES-1430:
---------------------------------------------------
Douglas Palmer <dpalmer(a)redhat.com> changed the Status of [bug
835678|https://bugzilla.redhat.com/show_bug.cgi?id=835678] from MODIFIED to ON_QA
WSDL to Relational Source importer generates incorrect SQL for
response (Windows only)
--------------------------------------------------------------------------------------
Key: TEIIDDES-1430
URL: https://issues.jboss.org/browse/TEIIDDES-1430
Project: Teiid Designer
Issue Type: Bug
Components: Web Services Support
Affects Versions: 7.7.1
Environment: Found with JBDS 5.0GA and SOA-tooling CR1 & Windows 7
Reporter: Paul Nittel
Assignee: Barry LaFond
Fix For: 7.7.1, 7.8
Attachments: org.teiid.designer.modelgenerator.wsdl.ui.patch
Importing WSDL to make a relational source model, teh response procedure's SQL
misuses the namespace when it should include the name of the object. For example:
SELECT t.* FROM
XMLTABLE(XMLNAMESPACES('http://www.metamatrix.com/suppInfo_Output' AS ns),
'/ns:suppInfo_Output/suppInfo_Output_Instance' PASSING
Supp2View.getsuppInfo_response.xml_in COLUMNS SUPPLIER_NAME string PATH '/ns:') AS
t
should be:
SELECT t.* FROM
XMLTABLE(XMLNAMESPACES('http://www.metamatrix.com/suppInfo_Output' AS ns),
'/ns:suppInfo_Output/suppInfo_Output_Instance' PASSING
Supp2View.getsuppInfo_response.xml_in COLUMNS SUPPLIER_NAME string PATH
'/SUPPLIER_NAME') AS t
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:11 p.m.
[
https://issues.jboss.org/browse/TEIIDDES-1430?page=com.atlassian.jira.plu...
]
RH Bugzilla Integration commented on TEIIDDES-1430:
---------------------------------------------------
Paul Nittel <pnittel(a)redhat.com> made a comment on [bug
835678|https://bugzilla.redhat.com/show_bug.cgi?id=835678]
Just tested and verified with soa-tooling CR2.
WSDL to Relational Source importer generates incorrect SQL for
response (Windows only)
--------------------------------------------------------------------------------------
Key: TEIIDDES-1430
URL: https://issues.jboss.org/browse/TEIIDDES-1430
Project: Teiid Designer
Issue Type: Bug
Components: Web Services Support
Affects Versions: 7.7.1
Environment: Found with JBDS 5.0GA and SOA-tooling CR1 & Windows 7
Reporter: Paul Nittel
Assignee: Barry LaFond
Fix For: 7.7.1, 7.8
Attachments: org.teiid.designer.modelgenerator.wsdl.ui.patch
Importing WSDL to make a relational source model, teh response procedure's SQL
misuses the namespace when it should include the name of the object. For example:
SELECT t.* FROM
XMLTABLE(XMLNAMESPACES('http://www.metamatrix.com/suppInfo_Output' AS ns),
'/ns:suppInfo_Output/suppInfo_Output_Instance' PASSING
Supp2View.getsuppInfo_response.xml_in COLUMNS SUPPLIER_NAME string PATH '/ns:') AS
t
should be:
SELECT t.* FROM
XMLTABLE(XMLNAMESPACES('http://www.metamatrix.com/suppInfo_Output' AS ns),
'/ns:suppInfo_Output/suppInfo_Output_Instance' PASSING
Supp2View.getsuppInfo_response.xml_in COLUMNS SUPPLIER_NAME string PATH
'/SUPPLIER_NAME') AS t
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:11 p.m.
[
https://issues.jboss.org/browse/TEIIDDES-1430?page=com.atlassian.jira.plu...
]
RH Bugzilla Integration commented on TEIIDDES-1430:
---------------------------------------------------
Paul Nittel <pnittel(a)redhat.com> changed the Status of [bug
835678|https://bugzilla.redhat.com/show_bug.cgi?id=835678] from ON_QA to VERIFIED
WSDL to Relational Source importer generates incorrect SQL for
response (Windows only)
--------------------------------------------------------------------------------------
Key: TEIIDDES-1430
URL: https://issues.jboss.org/browse/TEIIDDES-1430
Project: Teiid Designer
Issue Type: Bug
Components: Web Services Support
Affects Versions: 7.7.1
Environment: Found with JBDS 5.0GA and SOA-tooling CR1 & Windows 7
Reporter: Paul Nittel
Assignee: Barry LaFond
Fix For: 7.7.1, 7.8
Attachments: org.teiid.designer.modelgenerator.wsdl.ui.patch
Importing WSDL to make a relational source model, teh response procedure's SQL
misuses the namespace when it should include the name of the object. For example:
SELECT t.* FROM
XMLTABLE(XMLNAMESPACES('http://www.metamatrix.com/suppInfo_Output' AS ns),
'/ns:suppInfo_Output/suppInfo_Output_Instance' PASSING
Supp2View.getsuppInfo_response.xml_in COLUMNS SUPPLIER_NAME string PATH '/ns:') AS
t
should be:
SELECT t.* FROM
XMLTABLE(XMLNAMESPACES('http://www.metamatrix.com/suppInfo_Output' AS ns),
'/ns:suppInfo_Output/suppInfo_Output_Instance' PASSING
Supp2View.getsuppInfo_response.xml_in COLUMNS SUPPLIER_NAME string PATH
'/SUPPLIER_NAME') AS t
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:05 p.m.
[
https://issues.jboss.org/browse/TEIIDDES-1430?page=com.atlassian.jira.plu...
]
RH Bugzilla Integration commented on TEIIDDES-1430:
---------------------------------------------------
Paul Nittel <pnittel(a)redhat.com> changed the Status of [bug
835678|https://bugzilla.redhat.com/show_bug.cgi?id=835678] from VERIFIED to CLOSED
WSDL to Relational Source importer generates incorrect SQL for
response (Windows only)
--------------------------------------------------------------------------------------
Key: TEIIDDES-1430
URL: https://issues.jboss.org/browse/TEIIDDES-1430
Project: Teiid Designer
Issue Type: Bug
Components: Web Services Support
Affects Versions: 7.7.1
Environment: Found with JBDS 5.0GA and SOA-tooling CR1 & Windows 7
Reporter: Paul Nittel
Assignee: Barry LaFond
Fix For: 7.7.1, 7.8
Attachments: org.teiid.designer.modelgenerator.wsdl.ui.patch
Importing WSDL to make a relational source model, teh response procedure's SQL
misuses the namespace when it should include the name of the object. For example:
SELECT t.* FROM
XMLTABLE(XMLNAMESPACES('http://www.metamatrix.com/suppInfo_Output' AS ns),
'/ns:suppInfo_Output/suppInfo_Output_Instance' PASSING
Supp2View.getsuppInfo_response.xml_in COLUMNS SUPPLIER_NAME string PATH '/ns:') AS
t
should be:
SELECT t.* FROM
XMLTABLE(XMLNAMESPACES('http://www.metamatrix.com/suppInfo_Output' AS ns),
'/ns:suppInfo_Output/suppInfo_Output_Instance' PASSING
Supp2View.getsuppInfo_response.xml_in COLUMNS SUPPLIER_NAME string PATH
'/SUPPLIER_NAME') AS t
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:05 p.m.
[
https://issues.jboss.org/browse/TEIIDDES-1430?page=com.atlassian.jira.plu...
]
RH Bugzilla Integration commented on TEIIDDES-1430:
---------------------------------------------------
Paul Nittel <pnittel(a)redhat.com> made a comment on [bug
835678|https://bugzilla.redhat.com/show_bug.cgi?id=835678]
Closed!
WSDL to Relational Source importer generates incorrect SQL for
response (Windows only)
--------------------------------------------------------------------------------------
Key: TEIIDDES-1430
URL: https://issues.jboss.org/browse/TEIIDDES-1430
Project: Teiid Designer
Issue Type: Bug
Components: Web Services Support
Affects Versions: 7.7.1
Environment: Found with JBDS 5.0GA and SOA-tooling CR1 & Windows 7
Reporter: Paul Nittel
Assignee: Barry LaFond
Fix For: 7.7.1, 7.8
Attachments: org.teiid.designer.modelgenerator.wsdl.ui.patch
Importing WSDL to make a relational source model, teh response procedure's SQL
misuses the namespace when it should include the name of the object. For example:
SELECT t.* FROM
XMLTABLE(XMLNAMESPACES('http://www.metamatrix.com/suppInfo_Output' AS ns),
'/ns:suppInfo_Output/suppInfo_Output_Instance' PASSING
Supp2View.getsuppInfo_response.xml_in COLUMNS SUPPLIER_NAME string PATH '/ns:') AS
t
should be:
SELECT t.* FROM
XMLTABLE(XMLNAMESPACES('http://www.metamatrix.com/suppInfo_Output' AS ns),
'/ns:suppInfo_Output/suppInfo_Output_Instance' PASSING
Supp2View.getsuppInfo_response.xml_in COLUMNS SUPPLIER_NAME string PATH
'/SUPPLIER_NAME') AS t
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
4323
days inactive
4343
days old
teiid-designer-issues@lists.jboss.org
17 comments
3 participants
participants (3)
-
Barry LaFond (JIRA) -
Paul Nittel (JIRA)
-
RH Bugzilla Integration (JIRA)