[JBoss JIRA] (TEIIDDES-2748) ‘Import => Teiid Designer => Web Service Source >> Source and View Model (SOAP)’ import wizard I am not getting columns for either my input or output wrapers methods.
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2748?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2748:
-----------------------------------
Priority: Minor (was: Major)
> ‘Import => Teiid Designer => Web Service Source >> Source and View Model (SOAP)’ import wizard I am not getting columns for either my input or output wrapers methods.
> -----------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2748
> URL: https://issues.jboss.org/browse/TEIIDDES-2748
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Affects Versions: 9.0.3, 9.2
> Reporter: Debbie Steigner
> Assignee: Ted Jones
> Priority: Minor
> Fix For: 9.0.5, 9.2.1
>
>
> Using the ‘Import => Teiid Designer => Web Service Source >> Source and View Model (SOAP)’ import wizard I am not getting columns for either my input or output wrapers methods.
> On the Source and WSDL Operations Definitions screen, the selected WSDL does validate. All the WSDL Operatoins are visible and selected.
> On the Models Definition screen the folders are setup and the names are unique. The recommended User-specified Procedures is checked.
> On the Procedure definition screen for EVERY operation has the warning “No columns are defined for the response result set for the operation:<name of operation>
> The Schema Contents section is blank. I can easily trace the very obvious connections through the wsdl to the associated schema that defines the complex type and the individual elements that compose it for every method. The add button doesn’t work.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 3 months
[JBoss JIRA] (TEIIDDES-2713) UDF jar not referenced in exported dynamic VDB
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2713?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2713:
----------------------------------------
[~phantomjinx] I think this JIRA should be lumped into the work to support exporting VDB archives that include DDL as well and should not be part of 9.2.1. If user is round-tripping, then the starting point is a dynamic VDB which wouldn't have a UDF jar referenced anyway.
Going to push this one
> UDF jar not referenced in exported dynamic VDB
> ----------------------------------------------
>
> Key: TEIIDDES-2713
> URL: https://issues.jboss.org/browse/TEIIDDES-2713
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export, Patch Release, VDB & Execution
> Affects Versions: 9.0.4
> Reporter: Andrej Šmigala
> Assignee: Paul Richardson
> Fix For: 9.2.1
>
>
> When exporting a VDB with a User Defined Function, the information about the UDF jar is not present in the resulting dynamic VDB file.
> With regular VDB archives, the UDF jar is added to the lib/ directory within the archive and is referenced like so in META-INF/vdb.xml:
> {code:xml}
> <entry path="/lib/MyTestUdf-1.0-SNAPSHOT.jar">
> <property name="checksum" value="2689317444"/>
> </entry>
> {code}
> This approach is not possible in case of dynamic VDB defined only as an xml file. It is, however, possible to create a module on the server with UDF jar and then reference it in the *-vdb.xml like so:
> {code:xml}
> <property name ="lib" value ="mytestudf-module"></property>
> {code}
> It is currently possible to define such property manually in the VDB editor before exporting, but Designer should be able to define one automatically, or at least warn the user when there is a UDF jar present and the lib property is not defined.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 3 months
[JBoss JIRA] (TEIIDDES-2713) UDF jar not referenced in exported dynamic VDB
by Paul Richardson (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2713?page=com.atlassian.jira.plu... ]
Paul Richardson commented on TEIIDDES-2713:
-------------------------------------------
[~blafond]
The value of the property is not the udf name but the jboss as module name, see [here|https://docs.jboss.org/author/display/teiid812final/Support+for+User...].
* Should we throw up another wizard window asking for the udf module name?
* Should we avoid more user questions and assume the udf name is the same as the module name?
* Should we do above but also create a warning, that tells the user what we have done?
> UDF jar not referenced in exported dynamic VDB
> ----------------------------------------------
>
> Key: TEIIDDES-2713
> URL: https://issues.jboss.org/browse/TEIIDDES-2713
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export, Patch Release, VDB & Execution
> Affects Versions: 9.0.4
> Reporter: Andrej Šmigala
> Assignee: Paul Richardson
> Fix For: 9.2.1
>
>
> When exporting a VDB with a User Defined Function, the information about the UDF jar is not present in the resulting dynamic VDB file.
> With regular VDB archives, the UDF jar is added to the lib/ directory within the archive and is referenced like so in META-INF/vdb.xml:
> {code:xml}
> <entry path="/lib/MyTestUdf-1.0-SNAPSHOT.jar">
> <property name="checksum" value="2689317444"/>
> </entry>
> {code}
> This approach is not possible in case of dynamic VDB defined only as an xml file. It is, however, possible to create a module on the server with UDF jar and then reference it in the *-vdb.xml like so:
> {code:xml}
> <property name ="lib" value ="mytestudf-module"></property>
> {code}
> It is currently possible to define such property manually in the VDB editor before exporting, but Designer should be able to define one automatically, or at least warn the user when there is a UDF jar present and the lib property is not defined.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 3 months
[JBoss JIRA] (TEIIDDES-2765) View model procedure_response created using SOAP import is missing information in XMLNAMESPACES()
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2765?page=com.atlassian.jira.plu... ]
Matus Makovy updated TEIIDDES-2765:
-----------------------------------
Description:
Transformation SQL on xxx_response procedures looks like this:
{code:java}
CREATE VIRTUAL PROCEDURE
BEGIN
SELECT t.* FROM
XMLTABLE(XMLNAMESPACES() , '/FullCountryInfoResponse/return' PASSING CountriesSOAPServiceView.FullCountryInfo_response.xml_in
COLUMNS
continentCode string PATH '/continentCode',
capitalCity string PATH '/capitalCity',
currencyIsoCode string PATH '/currencyIsoCode',
isoCode string PATH '/isoCode',
name string PATH '/name',
phoneCode string PATH '/phoneCode') AS t;
END
{code}
XMLNAMESPACES() is empty. When I add: "'http://qe.dv.jboss.org/' AS tns" everything works. (I copied this from TD 9.0.4)
was:
Transformation SQL on xxx_response procedures looks like this:
{code:java}
CREATE VIRTUAL PROCEDURE
BEGIN
SELECT t.* FROM
XMLTABLE(XMLNAMESPACES() , '/FullCountryInfoResponse/return' PASSING CountriesSOAPServiceView.FullCountryInfo_response.xml_in
COLUMNS
continentCode string PATH '/continentCode',
capitalCity string PATH '/capitalCity',
currencyIsoCode string PATH '/currencyIsoCode',
isoCode string PATH '/isoCode',
name string PATH '/name',
phoneCode string PATH '/phoneCode') AS t;
END
{code}
XMLNAMESPACES() is empty. When I add: "'http://qe.dv.jboss.org/' AS tns" everything works.
> View model procedure_response created using SOAP import is missing information in XMLNAMESPACES()
> -------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2765
> URL: https://issues.jboss.org/browse/TEIIDDES-2765
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 9.0.5
> Environment: MAC
> Reporter: Matus Makovy
> Priority: Critical
> Attachments: Screen Shot 2016-01-21 at 10.16.55.png
>
>
> Transformation SQL on xxx_response procedures looks like this:
> {code:java}
> CREATE VIRTUAL PROCEDURE
> BEGIN
> SELECT t.* FROM
> XMLTABLE(XMLNAMESPACES() , '/FullCountryInfoResponse/return' PASSING CountriesSOAPServiceView.FullCountryInfo_response.xml_in
> COLUMNS
> continentCode string PATH '/continentCode',
> capitalCity string PATH '/capitalCity',
> currencyIsoCode string PATH '/currencyIsoCode',
> isoCode string PATH '/isoCode',
> name string PATH '/name',
> phoneCode string PATH '/phoneCode') AS t;
> END
> {code}
> XMLNAMESPACES() is empty. When I add: "'http://qe.dv.jboss.org/' AS tns" everything works. (I copied this from TD 9.0.4)
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 3 months
[JBoss JIRA] (TEIIDDES-2765) View model procedure_response created using SOAP import is missing information in XMLNAMESPACES()
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2765?page=com.atlassian.jira.plu... ]
Matus Makovy updated TEIIDDES-2765:
-----------------------------------
Workaround Description:
Edit transformation SQL like this:
... XMLNAMESPACES('http://qe.dv.jboss.org/' AS tns) ...
or
... XMLNAMESPACES(NO DEFAULT) ...
was:
Edit transformation SQL like this:
... XMLNAMESPACES('http://qe.dv.jboss.org/' AS tns) ...
> View model procedure_response created using SOAP import is missing information in XMLNAMESPACES()
> -------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2765
> URL: https://issues.jboss.org/browse/TEIIDDES-2765
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 9.0.5
> Environment: MAC
> Reporter: Matus Makovy
> Priority: Critical
> Attachments: Screen Shot 2016-01-21 at 10.16.55.png
>
>
> Transformation SQL on xxx_response procedures looks like this:
> {code:java}
> CREATE VIRTUAL PROCEDURE
> BEGIN
> SELECT t.* FROM
> XMLTABLE(XMLNAMESPACES() , '/FullCountryInfoResponse/return' PASSING CountriesSOAPServiceView.FullCountryInfo_response.xml_in
> COLUMNS
> continentCode string PATH '/continentCode',
> capitalCity string PATH '/capitalCity',
> currencyIsoCode string PATH '/currencyIsoCode',
> isoCode string PATH '/isoCode',
> name string PATH '/name',
> phoneCode string PATH '/phoneCode') AS t;
> END
> {code}
> XMLNAMESPACES() is empty. When I add: "'http://qe.dv.jboss.org/' AS tns" everything works.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 3 months
[JBoss JIRA] (TEIIDDES-2765) View model procedure_response created using SOAP import is missing information in XMLNAMESPACES()
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2765?page=com.atlassian.jira.plu... ]
Matus Makovy updated TEIIDDES-2765:
-----------------------------------
Workaround Description:
Edit transformation SQL like this:
... XMLNAMESPACES('http://qe.dv.jboss.org/' AS tns) ...
was:
Edit transformation SQL like this:
... XMLNAMESPACES(http://qe.dv.jboss.org/' AS tns) ...
> View model procedure_response created using SOAP import is missing information in XMLNAMESPACES()
> -------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2765
> URL: https://issues.jboss.org/browse/TEIIDDES-2765
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 9.0.5
> Environment: MAC
> Reporter: Matus Makovy
> Priority: Critical
> Attachments: Screen Shot 2016-01-21 at 10.16.55.png
>
>
> Transformation SQL on xxx_response procedures looks like this:
> {code:java}
> CREATE VIRTUAL PROCEDURE
> BEGIN
> SELECT t.* FROM
> XMLTABLE(XMLNAMESPACES() , '/FullCountryInfoResponse/return' PASSING CountriesSOAPServiceView.FullCountryInfo_response.xml_in
> COLUMNS
> continentCode string PATH '/continentCode',
> capitalCity string PATH '/capitalCity',
> currencyIsoCode string PATH '/currencyIsoCode',
> isoCode string PATH '/isoCode',
> name string PATH '/name',
> phoneCode string PATH '/phoneCode') AS t;
> END
> {code}
> XMLNAMESPACES() is empty. When I add: "'http://qe.dv.jboss.org/' AS tns" everything works.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 3 months
[JBoss JIRA] (TEIIDDES-2765) View model procedure_response created using SOAP import is missing information in XMLNAMESPACES()
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2765?page=com.atlassian.jira.plu... ]
Matus Makovy updated TEIIDDES-2765:
-----------------------------------
Workaround Description:
Edit transformation SQL like this:
... XMLNAMESPACES(http://qe.dv.jboss.org/' AS tns) ...
Workaround: Workaround Exists
> View model procedure_response created using SOAP import is missing information in XMLNAMESPACES()
> -------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2765
> URL: https://issues.jboss.org/browse/TEIIDDES-2765
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 9.0.5
> Environment: MAC
> Reporter: Matus Makovy
> Priority: Critical
> Attachments: Screen Shot 2016-01-21 at 10.16.55.png
>
>
> Transformation SQL on xxx_response procedures looks like this:
> {code:java}
> CREATE VIRTUAL PROCEDURE
> BEGIN
> SELECT t.* FROM
> XMLTABLE(XMLNAMESPACES() , '/FullCountryInfoResponse/return' PASSING CountriesSOAPServiceView.FullCountryInfo_response.xml_in
> COLUMNS
> continentCode string PATH '/continentCode',
> capitalCity string PATH '/capitalCity',
> currencyIsoCode string PATH '/currencyIsoCode',
> isoCode string PATH '/isoCode',
> name string PATH '/name',
> phoneCode string PATH '/phoneCode') AS t;
> END
> {code}
> XMLNAMESPACES() is empty. When I add: "'http://qe.dv.jboss.org/' AS tns" everything works.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 3 months
[JBoss JIRA] (TEIIDDES-2765) View model procedure_response created using SOAP import is missing information in XMLNAMESPACES()
by Matus Makovy (JIRA)
Matus Makovy created TEIIDDES-2765:
--------------------------------------
Summary: View model procedure_response created using SOAP import is missing information in XMLNAMESPACES()
Key: TEIIDDES-2765
URL: https://issues.jboss.org/browse/TEIIDDES-2765
Project: Teiid Designer
Issue Type: Bug
Affects Versions: 9.0.5
Environment: MAC
Reporter: Matus Makovy
Priority: Critical
Attachments: Screen Shot 2016-01-21 at 10.16.55.png
Transformation SQL on xxx_response procedures looks like this:
{code:java}
CREATE VIRTUAL PROCEDURE
BEGIN
SELECT t.* FROM
XMLTABLE(XMLNAMESPACES() , '/FullCountryInfoResponse/return' PASSING CountriesSOAPServiceView.FullCountryInfo_response.xml_in
COLUMNS
continentCode string PATH '/continentCode',
capitalCity string PATH '/capitalCity',
currencyIsoCode string PATH '/currencyIsoCode',
isoCode string PATH '/isoCode',
name string PATH '/name',
phoneCode string PATH '/phoneCode') AS t;
END
{code}
XMLNAMESPACES() is empty. When I add: "'http://qe.dv.jboss.org/' AS tns" everything works.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 3 months