[JBoss JIRA] (TEIIDDES-2745) Extension properties not imported from dynamic VDB
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2745?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2745:
-----------------------------------
Component/s: Patch Release
> Extension properties not imported from dynamic VDB
> --------------------------------------------------
>
> Key: TEIIDDES-2745
> URL: https://issues.jboss.org/browse/TEIIDDES-2745
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dynamic VDBs, Patch Release
> Affects Versions: 9.0.4
> Reporter: Andrej Šmigala
> Assignee: Barry LaFond
> Fix For: 9.2.1
>
>
> When importing a dynamic VDB containing models with extension properties, the properties are not imported.
> {code:xml}
> <?xml version="1.0" encoding="UTF-8"?>
> <vdb name="MatViewsVdb" version="1">
> <description>For testing of materialized views</description>
>
> <model name="Source">
> <source name="Source" translator-name="h2-override"
> connection-jndi-name="java:/mat-views-ds" />
> <metadata type="DDL"><![CDATA[
>
> CREATE FOREIGN TABLE customers (
> id integer,
> name string(4000),
> address string(4000),
> CONSTRAINT PK_ID PRIMARY KEY(id)
> ) OPTIONS(NAMEINSOURCE 'customer')
>
> CREATE FOREIGN TABLE orders (
> id integer,
> customer_id integer,
> amount integer,
> CONSTRAINT PK_ID PRIMARY KEY(id),
> CONSTRAINT FK_CUST FOREIGN KEY(customer_id) REFERENCES customers(id)
> ) OPTIONS(NAMEINSOURCE 'order')
> ]]>
> </metadata>
> </model>
>
> <!-- TODO: change the CONVERTs to integer once TEIIDDES-2737 is resolved -->
> <model name="ViewModel" type="VIRTUAL">
> <metadata type="DDL"><![CDATA[
> CREATE VIEW internal_short_ttl (
> customer_id integer NOT NULL,
> total_amount integer
> ) OPTIONS (MATERIALIZED 'TRUE',
> "teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'execute Source.native(''INSERT INTO check_table(id,before_load) VALUES (''internal_short_ttl'',1) ON DUPLICATE KEY UPDATE before_load=before_load+1;'');',
> "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'execute Source.native(''INSERT INTO check_table(id,after_load) VALUES (''internal_short_ttl'',1) ON DUPLICATE KEY UPDATE after_load=after_load+1;'')'
> )
> AS /*+ cache(ttl:100)*/SELECT c.id AS customer_id, CONVERT(SUM(o.amount),biginteger) AS total_amount FROM customers c INNER JOIN orders o ON c.id = o.customer_id GROUP BY c.id;
>
> CREATE VIEW internal_long_ttl (
> customer_id integer PRIMARY KEY,
> total_amount integer
> ) OPTIONS (MATERIALIZED 'TRUE', UPDATABLE 'FALSE')
> AS /*+ cache(ttl:1000 updatable)*/ SELECT c.id AS customer_id, CONVERT(SUM(o.amount),biginteger) AS total_amount FROM customers c INNER JOIN orders o ON c.id = o.customer_id GROUP BY c.id;
>
> CREATE VIEW external_long_ttl (
> customer_id integer NOT NULL,
> total_amount integer
> ) OPTIONS (MATERIALIZED 'TRUE', UPDATABLE 'FALSE',
> MATERIALIZED_TABLE 'Source.DB.PUBLIC.MAT_VIEW',
> "teiid_rel:ALLOW_MATVIEW_MANAGEMENT" 'true',
> "teiid_rel:MATVIEW_STATUS_TABLE" 'Source.DB.PUBLIC.STATUS',
> "teiid_rel:ON_VDB_START_SCRIPT" 'exec Source.native(''MERGE INTO check_table(id,vdb_create) KEY(id) VALUES (''''external_long_ttl'''',COALESCE((SELECT vdb_create from check_table WHERE id=''''external_long_ttl''''),0)+1)'');',
> "teiid_rel:ON_VDB_DROP_SCRIPT" 'exec Source.native(''MERGE INTO check_table(id,vdb_drop) KEY(id) VALUES (''''external_long_ttl'''',COALESCE((SELECT vdb_drop from check_table WHERE id=''''external_long_ttl''''),0)+1)'');',
> "teiid_rel:MATVIEW_LOAD_SCRIPT" 'INSERT INTO mat_view_stage(customer_id,total_amount) SELECT c.id AS customer_id, CONVERT(SUM(o.amount),integer) AS total_amount FROM customers c INNER JOIN orders o ON c.id = o.customer_id GROUP BY c.id;',
> "teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'execute Source.native(''truncate table mat_view_stage'');exec Source.native(''MERGE INTO check_table(id,before_load) KEY(id) VALUES (''''external_long_ttl'''',COALESCE((SELECT before_load from check_table WHERE id=''''external_long_ttl''''),0)+1)'');',
> "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'exec Source.native(''ALTER TABLE mat_view_stage RENAME TO mat_view_temp'');exec Source.native(''ALTER TABLE mat_view RENAME TO mat_view_stage'');exec Source.native(''ALTER TABLE mat_view_temp RENAME TO mat_view'');exec Source.native(''MERGE INTO check_table(id,after_load) KEY(id) VALUES (''''external_long_ttl'''',COALESCE((SELECT after_load from check_table WHERE id=''''external_long_ttl''''),0)+1)'');',
> "teiid_rel:MATVIEW_ONERROR_ACTION" 'THROW_EXCEPTION',
> "teiid_rel:MATVIEW_TTL" 2000)
> AS SELECT c.id AS customer_id, CONVERT(SUM(o.amount),biginteger) AS total_amount FROM customers c INNER JOIN orders o ON c.id = o.customer_id GROUP BY c.id;
> ]]>
> </metadata>
> </model>
> <translator name="h2-override" type="h2">
> <property name="SupportsDirectQueryProcedure" value="true" />
> </translator>
> </vdb>
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years
[JBoss JIRA] (TEIIDDES-2722) User Defined properties are exported in each model in Dynamic VDB
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2722?page=com.atlassian.jira.plu... ]
RH Bugzilla Integration commented on TEIIDDES-2722:
---------------------------------------------------
Barry LaFond <blafond(a)redhat.com> changed the Status of [bug 1279911|https://bugzilla.redhat.com/show_bug.cgi?id=1279911] from NEW to CLOSED
> User Defined properties are exported in each model in Dynamic VDB
> -----------------------------------------------------------------
>
> Key: TEIIDDES-2722
> URL: https://issues.jboss.org/browse/TEIIDDES-2722
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export, VDB & Execution
> Affects Versions: 9.0.4
> Reporter: Andrej Šmigala
> Assignee: Barry LaFond
> Priority: Minor
> Fix For: 10.0
>
> Attachments: CustomPropertyProject.zip
>
>
> When exporting a VDB with user defined properties, the properties are added to each model in the resulting -vdb.xml. It would make more sense to include them once in the vdb root.
> Current -vdb.xml
> {code:xml}
> <?xml version="1.0" encoding="UTF-8" standalone="no"?>
> <vdb name="CustomPropertyVdb" version="1">
> <description />
> <property name="validationDateTime" value="Tue Nov 10 13:51:23 CET 2015" />
> <property name="validationVersion" value="8.7.1" />
> <model name="ViewModel2" type="VIRTUAL">
> <property name="lib" value="test" />
> <property name="myCustomProperty" value="someValue" />
> <metadata type="DDL"><![CDATA[ ... ]]></metadata>
> </model>
> <model name="ViewModel" type="VIRTUAL">
> <property name="lib" value="test" />
> <property name="myCustomProperty" value="someValue" />
> <metadata type="DDL"><![CDATA[ ... ]]></metadata>
> </model>
> </vdb>
> {code}
> Expected -vdb.xml
> {code:xml}
> <?xml version="1.0" encoding="UTF-8" standalone="no"?>
> <vdb name="CustomPropertyVdb" version="1">
> <description />
> <property name="validationDateTime" value="Tue Nov 10 13:51:23 CET 2015" />
> <property name="validationVersion" value="8.7.1" />
> <property name="lib" value="test" />
> <property name="myCustomProperty" value="someValue" />
> <model name="ViewModel2" type="VIRTUAL">
> <metadata type="DDL"><![CDATA[ ... ]]></metadata>
> </model>
> <model name="ViewModel" type="VIRTUAL">
> <metadata type="DDL"><![CDATA[ ... ]]></metadata>
> </model>
> </vdb>
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years
[JBoss JIRA] (TEIIDDES-2725) Transformation sql is not correct when using REST import with URL attributes
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2725?page=com.atlassian.jira.plu... ]
RH Bugzilla Integration commented on TEIIDDES-2725:
---------------------------------------------------
Barry LaFond <blafond(a)redhat.com> changed the Status of [bug 1281439|https://bugzilla.redhat.com/show_bug.cgi?id=1281439] from NEW to CLOSED
> Transformation sql is not correct when using REST import with URL attributes
> ----------------------------------------------------------------------------
>
> Key: TEIIDDES-2725
> URL: https://issues.jboss.org/browse/TEIIDDES-2725
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export, Patch Release
> Affects Versions: 9.0.4
> Reporter: Matus Makovy
> Assignee: Ted Jones
> Fix For: 9.2.1
>
> Attachments: Screen Shot 2015-11-12 at 14.55.52.png, Screen Shot 2015-11-12 at 15.22.59.png
>
>
> When you use connection parameters in REST connection profile definition, the resulting transformation SQL generated during import from this CP is malformed.
> ViewModel.getCases.query AS query, *+|| '/' || ViewModel.getCases.query+* ViewModel.getCases.newSearch AS newSearch *+|| '/' || ViewModel.getCases.newSearch+*
> SQL without the bold/underlined parts works. (I mean underlined/bold parts in this bug Description, not in screenshot)
> See attached screenshots
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years
[JBoss JIRA] (TEIIDDES-2710) WS Create Operation Wizard - Creating a method with no input message
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2710?page=com.atlassian.jira.plu... ]
RH Bugzilla Integration commented on TEIIDDES-2710:
---------------------------------------------------
Barry LaFond <blafond(a)redhat.com> changed the Status of [bug 1278289|https://bugzilla.redhat.com/show_bug.cgi?id=1278289] from NEW to CLOSED
> WS Create Operation Wizard - Creating a method with no input message
> --------------------------------------------------------------------
>
> Key: TEIIDDES-2710
> URL: https://issues.jboss.org/browse/TEIIDDES-2710
> Project: Teiid Designer
> Issue Type: Bug
> Components: Patch Release, Web Services Support
> Affects Versions: 9.0.4
> Reporter: Matus Makovy
> Assignee: Barry LaFond
> Fix For: 9.2.1
>
> Attachments: create-operation-dialog.png
>
>
> Coppied from BZ:
> Description of problem:
> Web service model , create operation model does not allow to create operations without input or output. Indeed it's possible to ignore warning messages and create the operation anyway. In that case wizard puts nameless and typeless messages in the schema and requires removing messages from the schema with an alternate editor.
> Version-Release number of selected component (if applicable):
>
> TD 9.0.3.Finalv2015
> How reproducible:
> Try to create a new operation in web service model
> Steps to Reproduce:
> 1. Pick one the interfaces that you have in wsdl
> 2. Create a new operation, give it a name
> 3. Try to get rid of input message, remove it's name and create
> Actual results:
> Malformed view schema
> Expected results:
> create the operation without the undesired message type
> Additional info:
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years
[JBoss JIRA] (TEIIDDES-2711) WS Create Operation - Wrong Label Name For Output Message
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2711?page=com.atlassian.jira.plu... ]
RH Bugzilla Integration commented on TEIIDDES-2711:
---------------------------------------------------
Barry LaFond <blafond(a)redhat.com> changed the Status of [bug 1278285|https://bugzilla.redhat.com/show_bug.cgi?id=1278285] from NEW to CLOSED
> WS Create Operation - Wrong Label Name For Output Message
> ---------------------------------------------------------
>
> Key: TEIIDDES-2711
> URL: https://issues.jboss.org/browse/TEIIDDES-2711
> Project: Teiid Designer
> Issue Type: Bug
> Components: Web Services Support
> Affects Versions: 9.0.4
> Reporter: Matus Makovy
> Assignee: Matus Makovy
> Priority: Minor
> Fix For: 9.2.1
>
> Attachments: Selection_030.png
>
>
> Coppied from BZ:
> Description of problem:
> "Input Message" label is used for both input message and output message
> Version-Release number of selected component (if applicable):
> Teiid Designer 9.0.3.Final-v205 (latest on the customer portal)
> How reproducible:
> Steps to Reproduce:
> 1. Open a webservice model,
> 2. Select one of the interfaces, right click on it and choose create operation from the menu
> See attached screenshot
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years
[JBoss JIRA] (TEIIDDES-2713) UDF jar not referenced in exported dynamic VDB
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2713?page=com.atlassian.jira.plu... ]
RH Bugzilla Integration commented on TEIIDDES-2713:
---------------------------------------------------
Barry LaFond <blafond(a)redhat.com> changed the Status of [bug 1278488|https://bugzilla.redhat.com/show_bug.cgi?id=1278488] from NEW to CLOSED
> 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)
9 years
[JBoss JIRA] (TEIIDDES-2719) DDL for UDF in exported dynamic VDB contains RETURN parameter
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2719?page=com.atlassian.jira.plu... ]
RH Bugzilla Integration commented on TEIIDDES-2719:
---------------------------------------------------
Barry LaFond <blafond(a)redhat.com> changed the Status of [bug 1279494|https://bugzilla.redhat.com/show_bug.cgi?id=1279494] from NEW to CLOSED
> DDL for UDF in exported dynamic VDB contains RETURN parameter
> -------------------------------------------------------------
>
> Key: TEIIDDES-2719
> URL: https://issues.jboss.org/browse/TEIIDDES-2719
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dynamic VDBs, Import/Export, Patch Release
> Affects Versions: 9.2
> Reporter: Andrej Šmigala
> Assignee: Barry LaFond
> Fix For: 9.2.1
>
> Attachments: UdfProject.zip
>
>
> When exporting VDB with a UDF, the resulting DDL contains the RETURN parameter in the parameters list. According to the [Teiid docs|https://docs.jboss.org/author/display/teiid87final/Support+for+User-...], the return parameter should not be specified.
> Generated DDL:
> {code:sql}
> CREATE VIRTUAL FUNCTION concatNull (stringLeft string(4000), stringRight string(4000), result string(4000)) RETURNS string
> ) OPTIONS("FUNCTION-CATEGORY" 'MY_TESTING_FUNCTION_CATEGORY', JAVA_CLASS 'userdefinedfunctions.MyConcatNull', JAVA_METHOD 'myConcatNull')
> {code}
> Expected DDL:
> {code:sql}
> CREATE VIRTUAL FUNCTION concatNull (stringLeft string(4000), stringRight string(4000)) RETURNS string
> OPTIONS("FUNCTION-CATEGORY" 'MY_TESTING_FUNCTION_CATEGORY', JAVA_CLASS 'userdefinedfunctions.MyConcatNull', JAVA_METHOD 'myConcatNull')
> {code}
> (note that the generated DDL also contains an unrelated syntax error due to TEIIDDES-2697)
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years
[JBoss JIRA] (TEIIDDES-2709) REST WAR Generation - Index.html contains wrong View name in url
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2709?page=com.atlassian.jira.plu... ]
RH Bugzilla Integration commented on TEIIDDES-2709:
---------------------------------------------------
Barry LaFond <blafond(a)redhat.com> changed the Status of [bug 1278199|https://bugzilla.redhat.com/show_bug.cgi?id=1278199] from NEW to CLOSED
> REST WAR Generation - Index.html contains wrong View name in url
> ----------------------------------------------------------------
>
> Key: TEIIDDES-2709
> URL: https://issues.jboss.org/browse/TEIIDDES-2709
> Project: Teiid Designer
> Issue Type: Bug
> Components: Patch Release, Web Services Support
> Affects Versions: 9.0.2
> Reporter: Van Halbert
> Assignee: Ted Jones
> Fix For: 9.2.1
>
>
> In index.html file, url address of rest services having invalid values on subsequent rest war generation.
> Version-Release number of selected component (if applicable):
> JBDS 9.0 GA + Early Access Alpha2 plugins (access.redhat.com)
>
> How reproducible:
>
> In any workspace that contains multiple teiid projects (or single project with multiple views)
> Actual results:
> Wrongly generated index.html file in WAR file
> Expected results:
> index.html has proper url
>
> Additional info:
> ,I think the view model name is saved in a session value in Eclipse.
> IDE restart is required for proper generation
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years