May 2015 - teiid-designer-issues - Jboss List Archives

[JBoss JIRA] (TEIIDDES-2525) Reproducing 'Import Data from REST Services' from documentation not working

by Daan Creemers (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2525?page=com.atlassian.jira.plu... ] Daan Creemers updated TEIIDDES-2525: ------------------------------------ Summary: Reproducing 'Import Data from REST Services' from documentation not working (was: Documentation 'Import Data from REST Services' not working) > Reproducing 'Import Data from REST Services' from documentation not working > --------------------------------------------------------------------------- > > Key: TEIIDDES-2525 > URL: https://issues.jboss.org/browse/TEIIDDES-2525 > Project: Teiid Designer > Issue Type: Bug > Components: Documentation > Affects Versions: 9.0.1, 9.0.2 Beta2 > Environment: Windows 7, JBoss Developer Studio 8.1 > Reporter: Daan Creemers > > Reproducing the steps of the documentation 'Import Data from REST Services' (https://access.redhat.com/documentation/en-US/Red_Hat_JBoss_Data_Virtuali...) does not work. The documentation is saying you should select 'REST Web Services URL' when choosing a Connection Profile Type for a new Connection Profile, but this type is not available. Only 'XML File URL Source' is available. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2525) Documentation 'Import Data from REST Services' not working

by Daan Creemers (JIRA)

Daan Creemers created TEIIDDES-2525: --------------------------------------- Summary: Documentation 'Import Data from REST Services' not working Key: TEIIDDES-2525 URL: https://issues.jboss.org/browse/TEIIDDES-2525 Project: Teiid Designer Issue Type: Bug Components: Documentation Affects Versions: 9.0.1, 9.0.2 Beta2 Environment: Windows 7, JBoss Developer Studio 8.1 Reporter: Daan Creemers Reproducing the steps of the documentation 'Import Data from REST Services' (https://access.redhat.com/documentation/en-US/Red_Hat_JBoss_Data_Virtuali...) does not work. The documentation is saying you should select 'REST Web Services URL' when choosing a Connection Profile Type for a new Connection Profile, but this type is not available. Only 'XML File URL Source' is available. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 5 months

1
0
0 / 0

[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

1
0
0 / 0

[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

1
0
0 / 0

[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

1
0
0 / 0

[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

1
0
0 / 0

[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

1
0
0 / 0

[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

1
0
0 / 0

[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

1
0
0 / 0

[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

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues May 2015