[JBoss JIRA] (TEIIDDES-2163) REST based importer design is wrong
by Ramesh Reddy (JIRA)
Ramesh Reddy created TEIIDDES-2163:
--------------------------------------
Summary: REST based importer design is wrong
Key: TEIIDDES-2163
URL: https://issues.jboss.org/browse/TEIIDDES-2163
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 8.3.2
Reporter: Ramesh Reddy
Priority: Critical
OK, I tried the REST based import wizard for the first time today since none of WSDL based solutions worked for me for those issues see TEIIDDES-2162
I believe the REST based importer is designed to generate wrong artifacts. It was designed same as XML file, where a given XML file, Teiid designer aids the user to come up with a "view". The difference between a XML file and REST based service is, a REST service will have input parameters. It is the input parameters that makes it a service, otherwise it just a remote URL.
Take for example WSDL based SOAP importer also gets XML as result, but it is designed to produce a procedure to capture the input parameters and return tabular result. REST based service MUST be doing exact same thing.
Teiid invokeHTTP does work with relative and absolute URLs, Teiid even has "querystring" function https://docs.jboss.org/author/display/TEIID/BNF+for+SQL+Grammar#BNFforSQL...
to help build the query parameter part of the URL, then you just need to concat it with the URL to make the whole.
IMO the way we have does not serve any real usecase, like mine where I was trying to read a quotes from REST service
http://ws.cdyne.com/delayedstockquote/delayedstockquote.asmx/GetQuickQuot...
--
This message was sent by Atlassian JIRA
(v6.2.3#6260)
10 years, 8 months
[JBoss JIRA] (TEIIDDES-2153) Create relational model from SOAP WS with Service Mode MESSAGE can't be finished
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2153?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2153:
-----------------------------------
Fix Version/s: 8.3.4
(was: 8.3.3)
> Create relational model from SOAP WS with Service Mode MESSAGE can't be finished
> --------------------------------------------------------------------------------
>
> Key: TEIIDDES-2153
> URL: https://issues.jboss.org/browse/TEIIDDES-2153
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 8.3.2
> Reporter: Matus Makovy
> Assignee: Ted Jones
> Priority: Blocker
> Fix For: 8.5, 8.3.4
>
> Attachments: bug.png
>
>
> Description of problem:
> When I select Service Mode MESSAGE during the proccess of creating the relational model from SOAP WS it gets stuck and can't be finished.
> How reproducible:
> 1. Guides -> Generate relational model from WSDL
> 2. Select some Connection Profile and some Operations
> 3. Select Service Mode: MESSAGE, click Next>
> 4. Leave default settings and click Next> again
> 5. Nothing changes on the window only new error message in the top section of the window is displayed "No columns are defined for the response procedure result set for the operation: ... " and both buttons "Next>" and "Finish" are disabled
> [see attachment]
> JBDS 7.1.1.GA + TeiidDesigner 8.3.2
--
This message was sent by Atlassian JIRA
(v6.2.3#6260)
10 years, 8 months
[JBoss JIRA] (TEIIDDES-2152) Adding source table with quoted name results in wrong generated SQL statement
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2152?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2152:
-----------------------------------
Fix Version/s: 8.3.4
(was: 8.3.3)
> Adding source table with quoted name results in wrong generated SQL statement
> -----------------------------------------------------------------------------
>
> Key: TEIIDDES-2152
> URL: https://issues.jboss.org/browse/TEIIDDES-2152
> Project: Teiid Designer
> Issue Type: Bug
> Components: Transformations
> Affects Versions: 8.5
> Reporter: Barry LaFond
> Assignee: Paul Richardson
> Fix For: 8.5, 8.3.4
>
>
> 1) Created source model with simple table named "My.Quoted.Table" (including quotes
> 2) Created simple virtual table and pasted: SELECT * FROM "My.Quoted.Table"
> 3) Parser returned a command resulting in the SQL: SELECT * FROM My.Quoted."Table"
> Parser should be able to handle quoted names properly. In this case the SQL should have been valid as is.
--
This message was sent by Atlassian JIRA
(v6.2.3#6260)
10 years, 8 months
[JBoss JIRA] (TEIIDDES-2100) Add ability to migrate older models containing table names with "." characters
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2100?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2100:
-----------------------------------
Fix Version/s: 8.3.4
(was: 8.3.3)
> Add ability to migrate older models containing table names with "." characters
> ------------------------------------------------------------------------------
>
> Key: TEIIDDES-2100
> URL: https://issues.jboss.org/browse/TEIIDDES-2100
> Project: Teiid Designer
> Issue Type: Feature Request
> Components: Transformations, Validation
> Affects Versions: 8.4, 8.3.2
> Reporter: Barry LaFond
> Assignee: Barry LaFond
> Fix For: 8.5, 8.3.4
>
> Attachments: BarryProducts.zip, DOTNAMESMODELProjectSet.zip
>
>
> DV 6 tooling (Designer 8.3.x) includes error validation to prevent non-quoted names from being defined and used in SQL.
> Designer needs a mechanism/framework to help users globally fix table names containing the "." delimiter.
> Options:
> # Designer feature/action to "fix" a model
> # simple CLI-based app to apply to a model
> Need to investigate our "rename" logic to see if it can handle the cascade effect of changing table name and fixing dependent SQL
--
This message was sent by Atlassian JIRA
(v6.2.3#6260)
10 years, 8 months
[JBoss JIRA] (TEIIDDES-2160) Merge various fixes from master into 8.3.3
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2160?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2160:
-----------------------------------
Description:
A handful of fixes for 8.5 release have been requested to be back-ported and applied to next 8.3 release, namely, 8.3
*Candidates*
* TEIIDDES-xxxx (none)
*Completed Upstream*
* TEIIDDES-2138 Restrict "New VDB" wizard's "Add model" to the current project (work around exists, suggest push to 8.3.4)
* TEIIDDES-2154 Preview VDB is not updated after adding or modifying a translator override (no bz, suggest push to 8.3.4)
* TEIIDDES-2156 Building Vdbs in eclipse should not throw runtime exceptions
*Merged*
* TEIIDDES-1901 Teiid Connection Importer is using the pool-name instead of jndi name
* TEIIDDES-1945 fixed via TEIIDDES-2104 NPE launching Undeploy VDB Action in server view
* TEIIDDES-1961 Create User Defined Wizard Displays The UDF Jar Path In Reverse Order From Entered Text
* TEIIDDES-2061 char[n+] field is truncated by importer
* TEIIDDES-2101 Query resolution fails on procedure that references XmlDocument
* TEIIDDES-2120 unable to reference same name .xsd when saving .vdb
* TEIIDDES-2136 File Source (XML) importer reverses Root patch when typed (Windows)
* TEIIDDES-2155 Generating WS From Source Procedure Fails when Direction Type for Column is RETURN
was:
A handful of fixes for 8.5 release have been requested to be back-ported and applied to next 8.3 release, namely, 8.3
*Candidates*
* TEIIDDES-2100 Add ability to migrate older models containing table names with "." characters
* TEIIDDES-2153 Create relational model from SOAP WS with Service Mode MESSAGE can't be finished
*Completed Upstream*
* TEIIDDES-2138 Restrict "New VDB" wizard's "Add model" to the current project (work around exists, suggest push to 8.3.4)
* TEIIDDES-2154 Preview VDB is not updated after adding or modifying a translator override (no bz, suggest push to 8.3.4)
* TEIIDDES-2156 Building Vdbs in eclipse should not throw runtime exceptions
*Merged*
* TEIIDDES-1901 Teiid Connection Importer is using the pool-name instead of jndi name
* TEIIDDES-1945 fixed via TEIIDDES-2104 NPE launching Undeploy VDB Action in server view
* TEIIDDES-1961 Create User Defined Wizard Displays The UDF Jar Path In Reverse Order From Entered Text
* TEIIDDES-2061 char[n+] field is truncated by importer
* TEIIDDES-2101 Query resolution fails on procedure that references XmlDocument
* TEIIDDES-2120 unable to reference same name .xsd when saving .vdb
* TEIIDDES-2136 File Source (XML) importer reverses Root patch when typed (Windows)
* TEIIDDES-2155 Generating WS From Source Procedure Fails when Direction Type for Column is RETURN
> Merge various fixes from master into 8.3.3
> ------------------------------------------
>
> Key: TEIIDDES-2160
> URL: https://issues.jboss.org/browse/TEIIDDES-2160
> Project: Teiid Designer
> Issue Type: Task
> Components: Build, Release Work
> Affects Versions: 8.3.3
> Reporter: Barry LaFond
> Assignee: Johnathon Lee
> Priority: Blocker
> Fix For: 8.3.3
>
>
> A handful of fixes for 8.5 release have been requested to be back-ported and applied to next 8.3 release, namely, 8.3
> *Candidates*
> * TEIIDDES-xxxx (none)
> *Completed Upstream*
> * TEIIDDES-2138 Restrict "New VDB" wizard's "Add model" to the current project (work around exists, suggest push to 8.3.4)
> * TEIIDDES-2154 Preview VDB is not updated after adding or modifying a translator override (no bz, suggest push to 8.3.4)
> * TEIIDDES-2156 Building Vdbs in eclipse should not throw runtime exceptions
> *Merged*
> * TEIIDDES-1901 Teiid Connection Importer is using the pool-name instead of jndi name
> * TEIIDDES-1945 fixed via TEIIDDES-2104 NPE launching Undeploy VDB Action in server view
> * TEIIDDES-1961 Create User Defined Wizard Displays The UDF Jar Path In Reverse Order From Entered Text
> * TEIIDDES-2061 char[n+] field is truncated by importer
> * TEIIDDES-2101 Query resolution fails on procedure that references XmlDocument
> * TEIIDDES-2120 unable to reference same name .xsd when saving .vdb
> * TEIIDDES-2136 File Source (XML) importer reverses Root patch when typed (Windows)
> * TEIIDDES-2155 Generating WS From Source Procedure Fails when Direction Type for Column is RETURN
--
This message was sent by Atlassian JIRA
(v6.2.3#6260)
10 years, 8 months
[JBoss JIRA] (TEIIDDES-2161) Merge various fixes from master into 8.3.4
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2161?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2161:
-----------------------------------
Fix Version/s: 8.3.4
> Merge various fixes from master into 8.3.4
> ------------------------------------------
>
> Key: TEIIDDES-2161
> URL: https://issues.jboss.org/browse/TEIIDDES-2161
> Project: Teiid Designer
> Issue Type: Task
> Reporter: Barry LaFond
> Fix For: 8.3.4
>
>
> *Candidates*
> * TEIIDDES-2100 Add ability to migrate older models containing table names with "." characters
> * TEIIDDES-2152 Adding source table with quoted name results in wrong generated SQL statement
> * TEIIDDES-2153 Create relational model from SOAP WS with Service Mode MESSAGE can't be finished
> *Completed Upstream*
> * TEIIDDES-2138 Restrict "New VDB" wizard's "Add model" to the current project (work around exists, suggest push to 8.3.4)
> * TEIIDDES-2154 Preview VDB is not updated after adding or modifying a translator override (no bz, suggest push to 8.3.4)
> * TEIIDDES-2156 Building Vdbs in eclipse should not throw runtime exceptions
--
This message was sent by Atlassian JIRA
(v6.2.3#6260)
10 years, 8 months
[JBoss JIRA] (TEIIDDES-2161) Merge various fixes from master into 8.3.4
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2161?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2161:
-----------------------------------
Description:
*Candidates*
* TEIIDDES-2100 Add ability to migrate older models containing table names with "." characters
* TEIIDDES-2152 Adding source table with quoted name results in wrong generated SQL statement
* TEIIDDES-2153 Create relational model from SOAP WS with Service Mode MESSAGE can't be finished
*Completed Upstream*
* TEIIDDES-2138 Restrict "New VDB" wizard's "Add model" to the current project (work around exists, suggest push to 8.3.4)
* TEIIDDES-2154 Preview VDB is not updated after adding or modifying a translator override (no bz, suggest push to 8.3.4)
* TEIIDDES-2156 Building Vdbs in eclipse should not throw runtime exceptions
was:xxxx
> Merge various fixes from master into 8.3.4
> ------------------------------------------
>
> Key: TEIIDDES-2161
> URL: https://issues.jboss.org/browse/TEIIDDES-2161
> Project: Teiid Designer
> Issue Type: Task
> Reporter: Barry LaFond
>
> *Candidates*
> * TEIIDDES-2100 Add ability to migrate older models containing table names with "." characters
> * TEIIDDES-2152 Adding source table with quoted name results in wrong generated SQL statement
> * TEIIDDES-2153 Create relational model from SOAP WS with Service Mode MESSAGE can't be finished
> *Completed Upstream*
> * TEIIDDES-2138 Restrict "New VDB" wizard's "Add model" to the current project (work around exists, suggest push to 8.3.4)
> * TEIIDDES-2154 Preview VDB is not updated after adding or modifying a translator override (no bz, suggest push to 8.3.4)
> * TEIIDDES-2156 Building Vdbs in eclipse should not throw runtime exceptions
--
This message was sent by Atlassian JIRA
(v6.2.3#6260)
10 years, 8 months
[JBoss JIRA] (TEIIDDES-2160) Merge various fixes from master into 8.3.3
by Johnathon Lee (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2160?page=com.atlassian.jira.plu... ]
Johnathon Lee updated TEIIDDES-2160:
------------------------------------
Description:
A handful of fixes for 8.5 release have been requested to be back-ported and applied to next 8.3 release, namely, 8.3
*Candidates*
* TEIIDDES-2100 Add ability to migrate older models containing table names with "." characters
* TEIIDDES-2153 Create relational model from SOAP WS with Service Mode MESSAGE can't be finished
*Completed Upstream*
* TEIIDDES-2138 Restrict "New VDB" wizard's "Add model" to the current project (work around exists, suggest push to 8.3.4)
* TEIIDDES-2154 Preview VDB is not updated after adding or modifying a translator override (no bz, suggest push to 8.3.4)
* TEIIDDES-2156 Building Vdbs in eclipse should not throw runtime exceptions
*Merged*
* TEIIDDES-1901 Teiid Connection Importer is using the pool-name instead of jndi name
* TEIIDDES-1945 fixed via TEIIDDES-2104 NPE launching Undeploy VDB Action in server view
* TEIIDDES-1961 Create User Defined Wizard Displays The UDF Jar Path In Reverse Order From Entered Text
* TEIIDDES-2061 char[n+] field is truncated by importer
* TEIIDDES-2101 Query resolution fails on procedure that references XmlDocument
* TEIIDDES-2120 unable to reference same name .xsd when saving .vdb
* TEIIDDES-2136 File Source (XML) importer reverses Root patch when typed (Windows)
* TEIIDDES-2155 Generating WS From Source Procedure Fails when Direction Type for Column is RETURN
was:
A handful of fixes for 8.5 release have been requested to be back-ported and applied to next 8.3 release, namely, 8.3
*Candidates*
* TEIIDDES-2100 Add ability to migrate older models containing table names with "." characters
* TEIIDDES-2153 Create relational model from SOAP WS with Service Mode MESSAGE can't be finished
*Completed Upstream*
* TEIIDDES-2138 Restrict "New VDB" wizard's "Add model" to the current project (work around exists, suggest push to 8.3.4)
* TEIIDDES-2154 Preview VDB is not updated after adding or modifying a translator override (no bz, suggest push to 8.3.4)
* TEIIDDES-2155 Generating WS From Source Procedure Fails when Direction Type for Column is RETURN
* TEIIDDES-2156 Building Vdbs in eclipse should not throw runtime exceptions
*Merged*
* TEIIDDES-1901 Teiid Connection Importer is using the pool-name instead of jndi name
* TEIIDDES-1961 Create User Defined Wizard Displays The UDF Jar Path In Reverse Order From Entered Text
* TEIIDDES-2061 char[n+] field is truncated by importer
* TEIIDDES-1945 fixed via TEIIDDES-2104 NPE launching Undeploy VDB Action in server view
* TEIIDDES-2101 Query resolution fails on procedure that references XmlDocument
* TEIIDDES-2120 unable to reference same name .xsd when saving .vdb
* TEIIDDES-2136 File Source (XML) importer reverses Root patch when typed (Windows)
> Merge various fixes from master into 8.3.3
> ------------------------------------------
>
> Key: TEIIDDES-2160
> URL: https://issues.jboss.org/browse/TEIIDDES-2160
> Project: Teiid Designer
> Issue Type: Task
> Components: Build, Release Work
> Affects Versions: 8.3.3
> Reporter: Barry LaFond
> Assignee: Johnathon Lee
> Priority: Blocker
> Fix For: 8.3.3
>
>
> A handful of fixes for 8.5 release have been requested to be back-ported and applied to next 8.3 release, namely, 8.3
> *Candidates*
> * TEIIDDES-2100 Add ability to migrate older models containing table names with "." characters
> * TEIIDDES-2153 Create relational model from SOAP WS with Service Mode MESSAGE can't be finished
> *Completed Upstream*
> * TEIIDDES-2138 Restrict "New VDB" wizard's "Add model" to the current project (work around exists, suggest push to 8.3.4)
> * TEIIDDES-2154 Preview VDB is not updated after adding or modifying a translator override (no bz, suggest push to 8.3.4)
> * TEIIDDES-2156 Building Vdbs in eclipse should not throw runtime exceptions
> *Merged*
> * TEIIDDES-1901 Teiid Connection Importer is using the pool-name instead of jndi name
> * TEIIDDES-1945 fixed via TEIIDDES-2104 NPE launching Undeploy VDB Action in server view
> * TEIIDDES-1961 Create User Defined Wizard Displays The UDF Jar Path In Reverse Order From Entered Text
> * TEIIDDES-2061 char[n+] field is truncated by importer
> * TEIIDDES-2101 Query resolution fails on procedure that references XmlDocument
> * TEIIDDES-2120 unable to reference same name .xsd when saving .vdb
> * TEIIDDES-2136 File Source (XML) importer reverses Root patch when typed (Windows)
> * TEIIDDES-2155 Generating WS From Source Procedure Fails when Direction Type for Column is RETURN
--
This message was sent by Atlassian JIRA
(v6.2.3#6260)
10 years, 8 months