[JBoss JIRA] (TEIIDDES-2524) Enable DDL importer to import Teiid CREATE VIRTUAL PROCEDURE DDL
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2524?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2524:
-----------------------------------
Attachment: TEIIDDES-2524_work_in_progress.zip
> Enable DDL importer to import Teiid CREATE VIRTUAL PROCEDURE DDL
> ----------------------------------------------------------------
>
> Key: TEIIDDES-2524
> URL: https://issues.jboss.org/browse/TEIIDDES-2524
> Project: Teiid Designer
> Issue Type: Enhancement
> Components: Import/Export
> Reporter: Barry LaFond
> Fix For: 9.2, 9.0.3
>
> Attachments: TEIIDDES-2524_work_in_progress.zip
>
>
> in 9.1, we've added ability to set SQL for imported *CREATE VIEW ....* ddl via ddl importer.
> for 9.2 we'll add ability to import *CREATE VIRTUAL PROCEDURE...* ddl.
> This case is a little more complex since the SQL defined in a procedure transformation will include just the BEGIN .... END part of the SQL, so there's an additional step required to extract the relevant SQL string and apply it to the transformation
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 5 months
[JBoss JIRA] (TEIIDDES-2482) Enable DDL Importer to import Teiid DDL CREATE VIEW statements to capture and set SQL expression in view model
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2482?page=com.atlassian.jira.plu... ]
Barry LaFond resolved TEIIDDES-2482.
------------------------------------
Resolution: Done
Resolving this issue and logged TEIIDDES-2524 to handle the virtual procedure case described in the previous comment
> Enable DDL Importer to import Teiid DDL CREATE VIEW statements to capture and set SQL expression in view model
> --------------------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2482
> URL: https://issues.jboss.org/browse/TEIIDDES-2482
> Project: Teiid Designer
> Issue Type: Enhancement
> Components: Import/Export, Transformations
> Reporter: Barry LaFond
> Assignee: Barry LaFond
> Fix For: 9.1, 9.0.2 Beta1, 9.0.2
>
> Attachments: view_example.ddl
>
>
> Teiid DDL supports CREATE VIEW & CREATE PROCEDURE statements that contain SQL expression. The current DDL Importer does not recognize the SQL expression and will not set that value on a table or procedure when importing to a View model.
> Make the changes necessary to discover the SQL expression and apply to a virtual table/procedure if importing to a View model.
> To Test:
> * Select Designer's simple DDL Importer wizard
> * Make sure *Teiid* dialect is selected
> * Make sure *View* model option is selected
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 5 months
[JBoss JIRA] (TEIIDDES-2524) Enable DDL importer to import Teiid CREATE VIRTUAL PROCEDURE DDL
by Barry LaFond (JIRA)
Barry LaFond created TEIIDDES-2524:
--------------------------------------
Summary: Enable DDL importer to import Teiid CREATE VIRTUAL PROCEDURE DDL
Key: TEIIDDES-2524
URL: https://issues.jboss.org/browse/TEIIDDES-2524
Project: Teiid Designer
Issue Type: Enhancement
Components: Import/Export
Reporter: Barry LaFond
Fix For: 9.2, 9.0.3
in 9.1, we've added ability to set SQL for imported *CREATE VIEW ....* ddl via ddl importer.
for 9.2 we'll add ability to import *CREATE VIRTUAL PROCEDURE...* ddl.
This case is a little more complex since the SQL defined in a procedure transformation will include just the BEGIN .... END part of the SQL, so there's an additional step required to extract the relevant SQL string and apply it to the transformation
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 5 months
[JBoss JIRA] (TEIIDDES-2482) Enable DDL Importer to import Teiid DDL CREATE VIEW statements to capture and set SQL expression in view model
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2482?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2482:
-----------------------------------
Attachment: view_example.ddl
> Enable DDL Importer to import Teiid DDL CREATE VIEW statements to capture and set SQL expression in view model
> --------------------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2482
> URL: https://issues.jboss.org/browse/TEIIDDES-2482
> Project: Teiid Designer
> Issue Type: Enhancement
> Components: Import/Export, Transformations
> Reporter: Barry LaFond
> Assignee: Barry LaFond
> Fix For: 9.1, 9.0.2 Beta1, 9.0.2
>
> Attachments: view_example.ddl
>
>
> Teiid DDL supports CREATE VIEW & CREATE PROCEDURE statements that contain SQL expression. The current DDL Importer does not recognize the SQL expression and will not set that value on a table or procedure when importing to a View model.
> Make the changes necessary to discover the SQL expression and apply to a virtual table/procedure if importing to a View model.
> To Test:
> * Select Designer's simple DDL Importer wizard
> * Make sure *Teiid* dialect is selected
> * Make sure *View* model option is selected
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 5 months
[JBoss JIRA] (TEIIDDES-2482) Enable DDL Importer to import Teiid DDL CREATE VIEW statements to capture and set SQL expression in view model
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2482?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2482:
-----------------------------------
Attachment: (was: view_example.ddl)
> Enable DDL Importer to import Teiid DDL CREATE VIEW statements to capture and set SQL expression in view model
> --------------------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2482
> URL: https://issues.jboss.org/browse/TEIIDDES-2482
> Project: Teiid Designer
> Issue Type: Enhancement
> Components: Import/Export, Transformations
> Reporter: Barry LaFond
> Assignee: Barry LaFond
> Fix For: 9.1, 9.0.2 Beta1, 9.0.2
>
>
> Teiid DDL supports CREATE VIEW & CREATE PROCEDURE statements that contain SQL expression. The current DDL Importer does not recognize the SQL expression and will not set that value on a table or procedure when importing to a View model.
> Make the changes necessary to discover the SQL expression and apply to a virtual table/procedure if importing to a View model.
> To Test:
> * Select Designer's simple DDL Importer wizard
> * Make sure *Teiid* dialect is selected
> * Make sure *View* model option is selected
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 5 months
[JBoss JIRA] (TEIIDDES-2436) StackOverflow Exception Importing VDB via JDBC Importer
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2436?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2436:
-----------------------------------
Fix Version/s: 9.2
9.0.3
(was: 9.1)
(was: 9.0.2)
(was: 9.0.2 Beta1)
> StackOverflow Exception Importing VDB via JDBC Importer
> -------------------------------------------------------
>
> Key: TEIIDDES-2436
> URL: https://issues.jboss.org/browse/TEIIDDES-2436
> Project: Teiid Designer
> Issue Type: Feature Request
> Components: Import/Export
> Affects Versions: 9.0.1
> Reporter: Ted Jones
> Assignee: Barry LaFond
> Priority: Critical
> Fix For: 8.6.2 Beta1, 8.6.2, 9.2, 9.0.3
>
> Attachments: import-vdb.png, JdbcImoprtObjectsPage_TEIIDDES_2436.patch
>
>
> Receiving StackOverflow exception importing a VDB via the JDBC importer using the following steps:
> 1. Import a JDBC source (any source)
> a. On page 3, select "Show Selected Schemas".
> 2. Now try importing a deployed VDB. You will receive a StackOverflow exception.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 5 months
[JBoss JIRA] (TEIIDDES-2402) Web Service Input Variables not shown after opening the model
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2402?page=com.atlassian.jira.plu... ]
Barry LaFond resolved TEIIDDES-2402.
------------------------------------
Resolution: Done
Marking as resolved and added a JIRA (TEIIDDES-2523) to handle the side-issue
> Web Service Input Variables not shown after opening the model
> -------------------------------------------------------------
>
> Key: TEIIDDES-2402
> URL: https://issues.jboss.org/browse/TEIIDDES-2402
> Project: Teiid Designer
> Issue Type: Bug
> Components: Editors, Web Services Support
> Affects Versions: 8.3.4, 9.0.1
> Reporter: Andrej Šmigala
> Assignee: Barry LaFond
> Priority: Minor
> Fix For: 9.1, 8.6.2 Beta1, 9.0.2 Beta1, 9.0.2, 8.6.2
>
> Attachments: WsVariablesProject.zip
>
>
> When opening a Web Service model editor by double-clicking the model in the model explorer, the Input Variables section is empty, even when there are variable declarations in the procedure SQL.
> Trying to add the variables using the Add or Remove variables button results in multiple identical declarations in the procedure SQL.
> When opening the model editor by double clicking the child interface or operation, the input variables are shown as expected.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 5 months
[JBoss JIRA] (TEIIDDES-2523) Add or Remove input variables for WS operation not working correctly
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2523?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2523:
-----------------------------------
Fix Version/s: 9.2
9.0.3
(was: 8.6.2)
(was: 9.1)
(was: 9.0.2)
(was: 9.0.2 Beta1)
(was: 8.6.2 Beta1)
> Add or Remove input variables for WS operation not working correctly
> --------------------------------------------------------------------
>
> Key: TEIIDDES-2523
> URL: https://issues.jboss.org/browse/TEIIDDES-2523
> Project: Teiid Designer
> Issue Type: Bug
> Components: Editors, Web Services Support
> Affects Versions: 8.3.4, 9.0.1
> Reporter: Andrej Šmigala
> Assignee: Barry LaFond
> Priority: Minor
> Fix For: 9.2, 9.0.3
>
> Attachments: WsVariablesProject.zip
>
>
> The variables are now shown after opening the model, however, clicking Add or Remove variables shows the Edit Input Variables editor with all the variables deselected. Selecting some of the variables adds them to the transformation, resulting in invalid SQL.
> New steps to reproduce:
> import the attached project
> double click the OrderCheckingWs in model explorer, the model editor will open
> click Add or Remove variables
> notice all variables are deselected
> select OrderDate, click OK
> save the model, the following validation error is shown:
> ERROR: Variable VARIABLES.IN_OrderDate was previously declared.
> Note that as a user checks/unchecks variables, the SQL transformation is trying to keep pace with the selections and isn't staying in sync. You can end up with multiple/duplicates. Expanding the tree shows that 2 of the 3 variables show as checked. But OrderDate is Not.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 5 months