[JBoss JIRA] Updated: (TEIIDDES-392) WSDL into Relational Model Importer should to support basic auth for HTTP WSDL URIs.
by John Doyle (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-392?page=com.atlassian.jira.plug... ]
John Doyle updated TEIIDDES-392:
--------------------------------
Summary: WSDL into Relational Model Importer should to support basic auth for HTTP WSDL URIs. (was: SAP WSDL URLs do not validate with the SOAP-Relational importer.)
Assignee: (was: John Doyle)
Affects Version/s: 6.0.0
7.3
Description: The SOAP-Relational importer can import WSDLs from URLs or the file system. WSDLs offered by SAP Netweaver via URSs do not validate because SAP requires HTTP basic auth to get the WSDL. The importer should support this and the new Web Service connection profile should provide the credentials. (was: The SOAP-Relational importer can import WSDLs from URLs or the file system. WSDLs offered by SAP Netweaver via URSs do not validate.)
> WSDL into Relational Model Importer should to support basic auth for HTTP WSDL URIs.
> --------------------------------------------------------------------------------------
>
> Key: TEIIDDES-392
> URL: https://issues.jboss.org/browse/TEIIDDES-392
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Affects Versions: 6.0.0, 7.3
> Reporter: John Doyle
>
> The SOAP-Relational importer can import WSDLs from URLs or the file system. WSDLs offered by SAP Netweaver via URSs do not validate because SAP requires HTTP basic auth to get the WSDL. The importer should support this and the new Web Service connection profile should provide the credentials.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
15 years, 2 months
[JBoss JIRA] Updated: (TEIIDDES-293) WSDL to Relational Model Importer: WSDL imports into model with incorredt types and column names.
by John Doyle (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-293?page=com.atlassian.jira.plug... ]
John Doyle updated TEIIDDES-293:
--------------------------------
Summary: WSDL to Relational Model Importer: WSDL imports into model with incorredt types and column names. (was: WSDL to Relational Importer: WSDL causes NPE when generating model.)
Affects Version/s: 7.2
7.3
Component/s: (was: Import/Export)
I retested this in JBDS 4.0.0 (aka Designer 7.1.1) and it no longer produces an NPE, and our new XML modeling technique should be able to handle request of arbitrary complexity. However, this WSDL produces a model that uses incorrect data types in the XMLTABLE fuctions.
int rather than integer
datetime rather than timestamp
Also, some of the columns that get their names qualified do not get the name qualified in the XMLTABLE function. For instance the column on the procedure is precision_, but the XMLTABLE function contains precision.
> WSDL to Relational Model Importer: WSDL imports into model with incorredt types and column names.
> -------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-293
> URL: https://issues.jboss.org/browse/TEIIDDES-293
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 7.1, 7.2, 7.3
> Reporter: John Doyle
> Assignee: John Doyle
> Labels: wsdltorelational
> Attachments: TmsWebService.wsdl
>
>
> The attached WSDL causes an NPE when the model objects are being created.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
15 years, 2 months
[JBoss JIRA] Moved: (TEIIDDES-881) Teiid Designer admin connections should be based on a configurable runtime.
by John Doyle (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-881?page=com.atlassian.jira.plug... ]
John Doyle moved JBIDE-7225 to TEIIDDES-881:
--------------------------------------------
Project: Teiid Designer (was: Tools (JBoss Tools))
Key: TEIIDDES-881 (was: JBIDE-7225)
Affects Version/s: 7.2
7.1.1
7.3
(was: 3.2.0.M2)
Component/s: VDB & Execution
(was: teiid)
Fix Version/s: (was: LATER)
> Teiid Designer admin connections should be based on a configurable runtime.
> ---------------------------------------------------------------------------
>
> Key: TEIIDDES-881
> URL: https://issues.jboss.org/browse/TEIIDDES-881
> Project: Teiid Designer
> Issue Type: Feature Request
> Components: VDB & Execution
> Affects Versions: 7.2, 7.1.1, 7.3
> Reporter: John Doyle
> Assignee: John Doyle
> Original Estimate: 0 minutes
> Remaining Estimate: 0 minutes
>
> The admin and preview connections for Teiid Designer rely on paths that specify plugin + version. Updates to the tooling therefore break existing connections when the version changes. We should instead rely on a user configurable runtime configuration like other JBoss runtimes.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
15 years, 2 months
[JBoss JIRA] Commented: (TEIIDDES-880) Execution Plan for a query executed in Teiid is hard to find in JBDS
by John Doyle (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-880?page=com.atlassian.jira.plug... ]
John Doyle commented on TEIIDDES-880:
-------------------------------------
DTP has two separate implemtations for fetching the plan and executing the query. Teiid does not make this distinction. My initial investigation into this JIRA leads me to think that we need to stop using the DTP supplied BaseExplainAction and CallableSQLResultRunnable as our implemetation and roll our own implementation that handles both concerns in a single execution.
> Execution Plan for a query executed in Teiid is hard to find in JBDS
> --------------------------------------------------------------------
>
> Key: TEIIDDES-880
> URL: https://issues.jboss.org/browse/TEIIDDES-880
> Project: Teiid Designer
> Issue Type: Feature Request
> Components: VDB & Execution
> Affects Versions: 7.1.1, 7.2, 7.3
> Reporter: Ramesh Reddy
>
> Currently viewing of the execution plan is little cumbersome, it is not readily available as it did previous incarnation of the MetaMatrix Designer. Currently, the user needs to right click on the query and select "Teiid_7.1 --> Query Plan" see the query plan.
> When a query is executed, the statement executed has the query already associated with it, so there is no good reason for user to take yet another step before they can see the query plan. It should be automatically populated in the "Execution Plan" tab when the query is executed. Or provide tool bar button on the "SQL Results" panel, that will take user to the "Execution Plan" of the current query. In case of query plan not available this tool bar button could be greyed out.
> Since the query plan is in XML, show it in XML editor (read-only), that will let the user collapse or expand the the nodes to see and understand it, otherwise these are rather long, could be confusing to scroll.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
15 years, 2 months
[JBoss JIRA] Moved: (TEIIDDES-880) Execution Plan for a query executed in Teiid is hard to find in JBDS
by John Doyle (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-880?page=com.atlassian.jira.plug... ]
John Doyle moved JBIDE-7887 to TEIIDDES-880:
--------------------------------------------
Project: Teiid Designer (was: Tools (JBoss Tools))
Key: TEIIDDES-880 (was: JBIDE-7887)
Component/s: VDB & Execution
(was: teiid)
Fix Version/s: (was: 3.2.x)
> Execution Plan for a query executed in Teiid is hard to find in JBDS
> --------------------------------------------------------------------
>
> Key: TEIIDDES-880
> URL: https://issues.jboss.org/browse/TEIIDDES-880
> Project: Teiid Designer
> Issue Type: Feature Request
> Components: VDB & Execution
> Affects Versions: 7.1.1, 7.2, 7.3
> Reporter: Ramesh Reddy
> Assignee: John Doyle
>
> Currently viewing of the execution plan is little cumbersome, it is not readily available as it did previous incarnation of the MetaMatrix Designer. Currently, the user needs to right click on the query and select "Teiid_7.1 --> Query Plan" see the query plan.
> When a query is executed, the statement executed has the query already associated with it, so there is no good reason for user to take yet another step before they can see the query plan. It should be automatically populated in the "Execution Plan" tab when the query is executed. Or provide tool bar button on the "SQL Results" panel, that will take user to the "Execution Plan" of the current query. In case of query plan not available this tool bar button could be greyed out.
> Since the query plan is in XML, show it in XML editor (read-only), that will let the user collapse or expand the the nodes to see and understand it, otherwise these are rather long, could be confusing to scroll.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
15 years, 2 months
[JBoss JIRA] Updated: (TEIIDDES-880) Execution Plan for a query executed in Teiid is hard to find in JBDS
by John Doyle (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-880?page=com.atlassian.jira.plug... ]
John Doyle updated TEIIDDES-880:
--------------------------------
Assignee: (was: John Doyle)
Affects Version/s: 7.2
7.1.1
7.3
> Execution Plan for a query executed in Teiid is hard to find in JBDS
> --------------------------------------------------------------------
>
> Key: TEIIDDES-880
> URL: https://issues.jboss.org/browse/TEIIDDES-880
> Project: Teiid Designer
> Issue Type: Feature Request
> Components: VDB & Execution
> Affects Versions: 7.1.1, 7.2, 7.3
> Reporter: Ramesh Reddy
>
> Currently viewing of the execution plan is little cumbersome, it is not readily available as it did previous incarnation of the MetaMatrix Designer. Currently, the user needs to right click on the query and select "Teiid_7.1 --> Query Plan" see the query plan.
> When a query is executed, the statement executed has the query already associated with it, so there is no good reason for user to take yet another step before they can see the query plan. It should be automatically populated in the "Execution Plan" tab when the query is executed. Or provide tool bar button on the "SQL Results" panel, that will take user to the "Execution Plan" of the current query. In case of query plan not available this tool bar button could be greyed out.
> Since the query plan is in XML, show it in XML editor (read-only), that will let the user collapse or expand the the nodes to see and understand it, otherwise these are rather long, could be confusing to scroll.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
15 years, 2 months