June 2019 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-5763) GENERATED_KEY returns NULL if used in INSTEAD OF INSERT Triggers in DDL files

by Christoph John (Jira)

[ https://issues.jboss.org/browse/TEIID-5763?page=com.atlassian.jira.plugin... ] Christoph John commented on TEIID-5763: --------------------------------------- Hello Steven, is this something I can get out of the log files? JDBCExecutionFactory.initCapabilities > GENERATED_KEY returns NULL if used in INSTEAD OF INSERT Triggers in DDL files > ----------------------------------------------------------------------------- > > Key: TEIID-5763 > URL: https://issues.jboss.org/browse/TEIID-5763 > Project: Teiid > Issue Type: Bug > Affects Versions: 12.2 > Reporter: Christoph John > Assignee: Steven Hawkins > Priority: Blocker > > The issue arrised in: > https://developer.jboss.org/message/989700#989700 > Following sceanarios are given: > Variant 1: > Table Product(id), primary key = autoincrement; > Table QuicklyAddedProduct, primary key is foreign key on Product.id > Table Diary_SRC > View Diary on Diary_SRC > INSTEAD OF INSERT Trigger on Diary should : > -create new record on Product, > -get autoincremented Product.id of new record, > - create new QuicklyAddedProduct with returned Product.id as primary key > - create new Diary record with QuicklyAddedProduct > { > INSERT a new record on Product; > idProduct = CONVERT(GENERATED_KEY('idProduct'),long); // fails > } > Variant 2: > INSTEAD OF INSERT trigger on Diary should : > - create new QuicklyAddedProduct > - add Quickly added prodcut to Diary > additionally a INSTEAD OF trigger on QuicklyAddedProduct exists which: > - creates new Product record > - uses returned GENERATED_KEY(Product.id) to add record on QuicklyAddedProduct with Product.id as primary key -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDSB-106) Provide ability to dynamically provide the URL query parameters for Rest Calls

by Ramesh Reddy (Jira)

Ramesh Reddy created TEIIDSB-106: ------------------------------------ Summary: Provide ability to dynamically provide the URL query parameters for Rest Calls Key: TEIIDSB-106 URL: https://issues.jboss.org/browse/TEIIDSB-106 Project: Teiid Spring Boot Issue Type: Enhancement Reporter: Ramesh Reddy Assignee: Ramesh Reddy When using the rest based called on @RestConfiguration, headers can be sent as user specific values, however, there is no facility for the URL parameters. -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDSB-105) Modelling a Json entitty with array of "details"

by Ramesh Reddy (Jira)

Ramesh Reddy created TEIIDSB-105: ------------------------------------ Summary: Modelling a Json entitty with array of "details" Key: TEIIDSB-105 URL: https://issues.jboss.org/browse/TEIIDSB-105 Project: Teiid Spring Boot Issue Type: Enhancement Reporter: Ramesh Reddy Assignee: Ramesh Reddy When using the @JsonTable the construct only supports reading the array type of same data types, with mixed type it does not work. For ex: {code} [1, 1, 3] {code} works, but {code} [1, "two", 3.0] {code} does not work. If the user chooses to read it as a string array converting the values to match Teiid semantics it is not possible. However, when it is created as {code} { id: 1, desc: "two", weight: 3.0} {code} can be read an entity. The array form could also be modeled as an entity with single parameter as `string[]` -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5763) GENERATED_KEY returns NULL if used in INSTEAD OF INSERT Triggers in DDL files

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5763?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-5763: --------------------------------------- > Is there something I can debug to ensure that your fix is running as expected? You can see the test, which almost exactly like what is described from the forum post: https://github.com/teiid/teiid/blob/8af79d55602ef3619d0d2b7afc405c1e0d089... Before the fix, it would have returned null. > Or might there be some driver configuration that I should check? You can certainly debug the JDBCUpdateExecution to see if it's capturing the generated keys. Whether or not it attempts to get the keys will be determined in JDBCExecutionFactory.initCapabilities - it's expecting the driver to return true for DatabaseMetaData.supportsGetGeneratedKeys() > GENERATED_KEY returns NULL if used in INSTEAD OF INSERT Triggers in DDL files > ----------------------------------------------------------------------------- > > Key: TEIID-5763 > URL: https://issues.jboss.org/browse/TEIID-5763 > Project: Teiid > Issue Type: Bug > Affects Versions: 12.2 > Reporter: Christoph John > Assignee: Steven Hawkins > Priority: Blocker > > The issue arrised in: > https://developer.jboss.org/message/989700#989700 > Following sceanarios are given: > Variant 1: > Table Product(id), primary key = autoincrement; > Table QuicklyAddedProduct, primary key is foreign key on Product.id > Table Diary_SRC > View Diary on Diary_SRC > INSTEAD OF INSERT Trigger on Diary should : > -create new record on Product, > -get autoincremented Product.id of new record, > - create new QuicklyAddedProduct with returned Product.id as primary key > - create new Diary record with QuicklyAddedProduct > { > INSERT a new record on Product; > idProduct = CONVERT(GENERATED_KEY('idProduct'),long); // fails > } > Variant 2: > INSTEAD OF INSERT trigger on Diary should : > - create new QuicklyAddedProduct > - add Quickly added prodcut to Diary > additionally a INSTEAD OF trigger on QuicklyAddedProduct exists which: > - creates new Product record > - uses returned GENERATED_KEY(Product.id) to add record on QuicklyAddedProduct with Product.id as primary key -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5763) GENERATED_KEY returns NULL if used in INSTEAD OF INSERT Triggers in DDL files

by Christoph John (Jira)

[ https://issues.jboss.org/browse/TEIID-5763?page=com.atlassian.jira.plugin... ] Christoph John edited comment on TEIID-5763 at 6/11/19 6:09 PM: ---------------------------------------------------------------- Hello Steven, I got Teiid running now with wildfly 17. The keycloak plugin for wildfly 16 also seems to work with Wildfly 17. Unfortunately I am still getting the same error. POST on 'QuicklyAddedProducts' failed; will be repeated automatically - Error: TEIID16016 Insert into QuicklyAddedProducts success, but failed to retrieve auto generated keys from source, thus failed to show result entity; Supply the key values. I tried both variants: vIdProduct = generated_key(); vIdProduct = CONVERT(GENERATED_KEY('idProduct'),long); >From the different flavors I described, I now tested the INSERT Trigger on the QuicklyAddedProducts view. As I mentioned previously, I am not sure where the distinction between the 3 variants is. However, as you mentioned that variant 1 and 3 should work according to your fix, I assume I need variant 2 :) Is there something I can debug to ensure that your fix is running as expected? Or might there be some driver configuration that I should check? was (Author: cjohn001): Hello Steven, I got Teiid running now with wildfly 17. The keycloak plugin for wildfly 16 also seems to work with Wildfly 17. Unfortunately I am still getting the same error. POST on 'QuicklyAddedProducts' failed; will be repeated automatically - Error: TEIID16016 Insert into QuicklyAddedProducts success, but failed to retrieve auto generated keys from source, thus failed to show result entity; Supply the key values. I tried both variants: vIdProduct = generated_key(); vIdProduct = CONVERT(GENERATED_KEY('idProduct'),long); >From the different flavors I described, I now tested the INSERT Trigger on the QuicklyAddedProducts view. As I mentioned previously, I am not sure where the distinction between the 3 variants is. However, as you mentioned that variant 1 and 3 should work according to your fix, I assume I need variant 2 :) Is there something I can debug to ensure that your fix is running as expected? > GENERATED_KEY returns NULL if used in INSTEAD OF INSERT Triggers in DDL files > ----------------------------------------------------------------------------- > > Key: TEIID-5763 > URL: https://issues.jboss.org/browse/TEIID-5763 > Project: Teiid > Issue Type: Bug > Affects Versions: 12.2 > Reporter: Christoph John > Assignee: Steven Hawkins > Priority: Blocker > > The issue arrised in: > https://developer.jboss.org/message/989700#989700 > Following sceanarios are given: > Variant 1: > Table Product(id), primary key = autoincrement; > Table QuicklyAddedProduct, primary key is foreign key on Product.id > Table Diary_SRC > View Diary on Diary_SRC > INSTEAD OF INSERT Trigger on Diary should : > -create new record on Product, > -get autoincremented Product.id of new record, > - create new QuicklyAddedProduct with returned Product.id as primary key > - create new Diary record with QuicklyAddedProduct > { > INSERT a new record on Product; > idProduct = CONVERT(GENERATED_KEY('idProduct'),long); // fails > } > Variant 2: > INSTEAD OF INSERT trigger on Diary should : > - create new QuicklyAddedProduct > - add Quickly added prodcut to Diary > additionally a INSTEAD OF trigger on QuicklyAddedProduct exists which: > - creates new Product record > - uses returned GENERATED_KEY(Product.id) to add record on QuicklyAddedProduct with Product.id as primary key -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5763) GENERATED_KEY returns NULL if used in INSTEAD OF INSERT Triggers in DDL files

by Christoph John (Jira)

[ https://issues.jboss.org/browse/TEIID-5763?page=com.atlassian.jira.plugin... ] Christoph John commented on TEIID-5763: --------------------------------------- Hello Steven, I got Teiid running now with wildfly 17. The keycloak plugin for wildfly 16 also seems to work with Wildfly 17. Unfortunately I am still getting the same error. POST on 'QuicklyAddedProducts' failed; will be repeated automatically - Error: TEIID16016 Insert into QuicklyAddedProducts success, but failed to retrieve auto generated keys from source, thus failed to show result entity; Supply the key values. I tried both variants: vIdProduct = generated_key(); vIdProduct = CONVERT(GENERATED_KEY('idProduct'),long); >From the different flavors I described, I now tested the INSERT Trigger on the QuicklyAddedProducts view. As I mentioned previously, I am not sure where the distinction between the 3 variants is. However, as you mentioned that variant 1 and 3 should work according to your fix, I assume I need variant 2 :) Is there something I can debug to ensure that your fix is running as expected? > GENERATED_KEY returns NULL if used in INSTEAD OF INSERT Triggers in DDL files > ----------------------------------------------------------------------------- > > Key: TEIID-5763 > URL: https://issues.jboss.org/browse/TEIID-5763 > Project: Teiid > Issue Type: Bug > Affects Versions: 12.2 > Reporter: Christoph John > Assignee: Steven Hawkins > Priority: Blocker > > The issue arrised in: > https://developer.jboss.org/message/989700#989700 > Following sceanarios are given: > Variant 1: > Table Product(id), primary key = autoincrement; > Table QuicklyAddedProduct, primary key is foreign key on Product.id > Table Diary_SRC > View Diary on Diary_SRC > INSTEAD OF INSERT Trigger on Diary should : > -create new record on Product, > -get autoincremented Product.id of new record, > - create new QuicklyAddedProduct with returned Product.id as primary key > - create new Diary record with QuicklyAddedProduct > { > INSERT a new record on Product; > idProduct = CONVERT(GENERATED_KEY('idProduct'),long); // fails > } > Variant 2: > INSTEAD OF INSERT trigger on Diary should : > - create new QuicklyAddedProduct > - add Quickly added prodcut to Diary > additionally a INSTEAD OF trigger on QuicklyAddedProduct exists which: > - creates new Product record > - uses returned GENERATED_KEY(Product.id) to add record on QuicklyAddedProduct with Product.id as primary key -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5763) GENERATED_KEY returns NULL if used in INSTEAD OF INSERT Triggers in DDL files

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5763?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-5763: --------------------------------------- There is no change needed for issue 3. There was a key group added to the for each row procedure logic to manually assign the generated key value. > GENERATED_KEY returns NULL if used in INSTEAD OF INSERT Triggers in DDL files > ----------------------------------------------------------------------------- > > Key: TEIID-5763 > URL: https://issues.jboss.org/browse/TEIID-5763 > Project: Teiid > Issue Type: Bug > Affects Versions: 12.2 > Reporter: Christoph John > Assignee: Steven Hawkins > Priority: Blocker > > The issue arrised in: > https://developer.jboss.org/message/989700#989700 > Following sceanarios are given: > Variant 1: > Table Product(id), primary key = autoincrement; > Table QuicklyAddedProduct, primary key is foreign key on Product.id > Table Diary_SRC > View Diary on Diary_SRC > INSTEAD OF INSERT Trigger on Diary should : > -create new record on Product, > -get autoincremented Product.id of new record, > - create new QuicklyAddedProduct with returned Product.id as primary key > - create new Diary record with QuicklyAddedProduct > { > INSERT a new record on Product; > idProduct = CONVERT(GENERATED_KEY('idProduct'),long); // fails > } > Variant 2: > INSTEAD OF INSERT trigger on Diary should : > - create new QuicklyAddedProduct > - add Quickly added prodcut to Diary > additionally a INSTEAD OF trigger on QuicklyAddedProduct exists which: > - creates new Product record > - uses returned GENERATED_KEY(Product.id) to add record on QuicklyAddedProduct with Product.id as primary key -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5764) Refine OpenApi 3.0 Support for OData

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5764?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-5764: ---------------------------------- Component/s: OData > Refine OpenApi 3.0 Support for OData > ------------------------------------ > > Key: TEIID-5764 > URL: https://issues.jboss.org/browse/TEIID-5764 > Project: Teiid > Issue Type: Feature Request > Components: OData > Reporter: Ramesh Reddy > Assignee: Steven Hawkins > Priority: Major > Fix For: 12.3, 12.2.1 > > > Support OpenAPI 3.0 document generation with OData service -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5764) Refine OpenApi 3.0 Support for OData

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5764?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-5764. ----------------------------------- Resolution: Done Added a release note about the default change. > Refine OpenApi 3.0 Support for OData > ------------------------------------ > > Key: TEIID-5764 > URL: https://issues.jboss.org/browse/TEIID-5764 > Project: Teiid > Issue Type: Feature Request > Components: OData > Reporter: Ramesh Reddy > Assignee: Steven Hawkins > Priority: Major > Fix For: 12.3, 12.2.1 > > > Support OpenAPI 3.0 document generation with OData service -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5763) GENERATED_KEY returns NULL if used in INSTEAD OF INSERT Triggers in DDL files

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5763?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-5763: --------------------------------------- The first commit is in. It addresses what is described as issue 1 from the forum post - you can use the generated_key function in any procedure regardless of how the procedure is invoked. I've also added a more convenient generated_key() function that assumes just a single long value being returned. > GENERATED_KEY returns NULL if used in INSTEAD OF INSERT Triggers in DDL files > ----------------------------------------------------------------------------- > > Key: TEIID-5763 > URL: https://issues.jboss.org/browse/TEIID-5763 > Project: Teiid > Issue Type: Bug > Affects Versions: 12.2 > Reporter: Christoph John > Assignee: Steven Hawkins > Priority: Blocker > > The issue arrised in: > https://developer.jboss.org/message/989700#989700 > Following sceanarios are given: > Variant 1: > Table Product(id), primary key = autoincrement; > Table QuicklyAddedProduct, primary key is foreign key on Product.id > Table Diary_SRC > View Diary on Diary_SRC > INSTEAD OF INSERT Trigger on Diary should : > -create new record on Product, > -get autoincremented Product.id of new record, > - create new QuicklyAddedProduct with returned Product.id as primary key > - create new Diary record with QuicklyAddedProduct > { > INSERT a new record on Product; > idProduct = CONVERT(GENERATED_KEY('idProduct'),long); // fails > } > Variant 2: > INSTEAD OF INSERT trigger on Diary should : > - create new QuicklyAddedProduct > - add Quickly added prodcut to Diary > additionally a INSTEAD OF trigger on QuicklyAddedProduct exists which: > - creates new Product record > - uses returned GENERATED_KEY(Product.id) to add record on QuicklyAddedProduct with Product.id as primary key -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 6 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues June 2019