April 2019 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-5724) Issues with Informix Date/Time types

by Johnathon Lee (Jira)

[ https://issues.jboss.org/browse/TEIID-5724?page=com.atlassian.jira.plugin... ] Johnathon Lee updated TEIID-5724: --------------------------------- Fix Version/s: 8.12.18.6_4 > Issues with Informix Date/Time types > ------------------------------------ > > Key: TEIID-5724 > URL: https://issues.jboss.org/browse/TEIID-5724 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Major > Fix For: 12.2, 11.2.3, 8.12.18.6_4, 12.1.1 > > > Informix date/time issues include: > Timestamp/Time are mapped to the same conversion - datetime hour to second > The Timestamp mapping needs to be fully specified - datetime year to fraction(5), not just datetime > Usage of the getXXX Resultset methods passing a Calendar result in odd behavior as Informix modifies that Calendar. -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5730) DDLStringVisitor writes the Namesspaces outside the Database scope

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5730?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-5730: ---------------------------------- Fix Version/s: 12.1.1 > DDLStringVisitor writes the Namesspaces outside the Database scope > ------------------------------------------------------------------ > > Key: TEIID-5730 > URL: https://issues.jboss.org/browse/TEIID-5730 > Project: Teiid > Issue Type: Bug > Components: VDB > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Priority: Major > Fix For: 12.2, 12.1.1 > > > When `Database` object is being serialized to DDL form using the DDLStringVisitor it adds NAMESPACE declarations before the `CREATE DATABASE` statement. It should be after it. -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIIDSB-81) Support Keycloak based OpenID authentication for pg/jdbc

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIIDSB-81?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIIDSB-81: --------------------------------------- This could be done with Spring JAAS integration to use the DirectAccessGrantLoginModule. For now this will use the none-JAAS approach. The code in KeycloakDirectAccessGrantAuthenticationProvider is mostly from that login module - there's no explicit handling there or here for active refresh / invalidation, so for now we're just concerned with the initial authentication. It extends from the KeycloakAuthenticationProvider to create the same mapped token authentication result as the OData case. I had a hard time wiring the AuthenticationManager. There seem to be some existing spring issues about that (https://github.com/spring-projects/spring-security-oauth2-boot/issues/30). I ended up using the post processor. The db security can be used in conjunction with or apart from the odata security. When odata is also included, however I see that hibernate validator is part of spring-boot-starter-web and is trying to do something against the default teiid connection pool. With db security this now fails as there is no identity associated. > Support Keycloak based OpenID authentication for pg/jdbc > -------------------------------------------------------- > > Key: TEIIDSB-81 > URL: https://issues.jboss.org/browse/TEIIDSB-81 > Project: Teiid Spring Boot > Issue Type: Feature Request > Reporter: Ramesh Reddy > Assignee: Steven Hawkins > Priority: Major > Fix For: 1.1.0 > > > Support authentication for pg/jdbc through keycloak/rh-sso. Needs to use the authorization paradigm as TEIIDSB-63. -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIIDSB-81) Support Keycloak based OpenID authentication for pg/jdbc

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIIDSB-81?page=com.atlassian.jira.plugin... ] Work on TEIIDSB-81 started by Steven Hawkins. --------------------------------------------- > Support Keycloak based OpenID authentication for pg/jdbc > -------------------------------------------------------- > > Key: TEIIDSB-81 > URL: https://issues.jboss.org/browse/TEIIDSB-81 > Project: Teiid Spring Boot > Issue Type: Feature Request > Reporter: Ramesh Reddy > Assignee: Steven Hawkins > Priority: Major > Fix For: 1.1.0 > > > Support authentication for pg/jdbc through keycloak/rh-sso. Needs to use the authorization paradigm as TEIIDSB-63. -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5730) DDLStringVisitor writes the Namesspaces outside the Database scope

by Ramesh Reddy (Jira)

[ https://issues.jboss.org/browse/TEIID-5730?page=com.atlassian.jira.plugin... ] Ramesh Reddy resolved TEIID-5730. --------------------------------- Resolution: Done corrected the DDL generation. > DDLStringVisitor writes the Namesspaces outside the Database scope > ------------------------------------------------------------------ > > Key: TEIID-5730 > URL: https://issues.jboss.org/browse/TEIID-5730 > Project: Teiid > Issue Type: Bug > Components: VDB > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Priority: Major > Fix For: 12.2 > > > When `Database` object is being serialized to DDL form using the DDLStringVisitor it adds NAMESPACE declarations before the `CREATE DATABASE` statement. It should be after it. -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5730) DDLStringVisitor writes the Namesspaces outside the Database scope

by Ramesh Reddy (Jira)

Ramesh Reddy created TEIID-5730: ----------------------------------- Summary: DDLStringVisitor writes the Namesspaces outside the Database scope Key: TEIID-5730 URL: https://issues.jboss.org/browse/TEIID-5730 Project: Teiid Issue Type: Bug Components: VDB Reporter: Ramesh Reddy Assignee: Ramesh Reddy Fix For: 12.2 When `Database` object is being serialized to DDL form using the DDLStringVisitor it adds NAMESPACE declarations before the `CREATE DATABASE` statement. It should be after it. -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5725) Please improve documentation on definition of stored procedures, virtual functions and virtual procedures

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5725?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-5725: ---------------------------------- Fix Version/s: 12.2 > Please improve documentation on definition of stored procedures, virtual functions and virtual procedures > --------------------------------------------------------------------------------------------------------- > > Key: TEIID-5725 > URL: https://issues.jboss.org/browse/TEIID-5725 > Project: Teiid > Issue Type: Enhancement > Components: Documentation > Reporter: Christoph John > Assignee: Steven Hawkins > Priority: Critical > Fix For: 12.2 > > > I refer to the discussion with Ramesh in > https://developer.jboss.org/message/989048#989048 and would like to ask for a more detailed explanation on how to write virtual procedures and functions. > -Especially, how are OUT and INOUT params set and how can they be obtained via odata. > - How is the return value of a virtual function set? > - How are collections and arrays of collections returned? -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5729) Introduce mechanism or option to allow for mapping of side effect free Teiid procedures to ODATA functions, and actions if procedure has side effects

by Christoph John (Jira)

[ https://issues.jboss.org/browse/TEIID-5729?page=com.atlassian.jira.plugin... ] Christoph John updated TEIID-5729: ---------------------------------- Summary: Introduce mechanism or option to allow for mapping of side effect free Teiid procedures to ODATA functions, and actions if procedure has side effects (was: Introduce mechanism or option to allow for mapping of side effect free Teiid procedures to ODATA actions) > Introduce mechanism or option to allow for mapping of side effect free Teiid procedures to ODATA functions, and actions if procedure has side effects > ----------------------------------------------------------------------------------------------------------------------------------------------------- > > Key: TEIID-5729 > URL: https://issues.jboss.org/browse/TEIID-5729 > Project: Teiid > Issue Type: Enhancement > Reporter: Christoph John > Assignee: Steven Hawkins > Priority: Major > > This is a follow up regarding https://issues.jboss.org/browse/TEIID-5725 > As discussed there, Teiid currently does not map virtual procedures and functions to odata functions and procedures according to the notion of "side effect free" > Please introduce a mechanism to allow for a mapping according to adequate odata semantics. -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5729) Introduce mechanism or option to allow for mapping of side effect free Teiid procedures to ODATA actions

by Christoph John (Jira)

Christoph John created TEIID-5729: ------------------------------------- Summary: Introduce mechanism or option to allow for mapping of side effect free Teiid procedures to ODATA actions Key: TEIID-5729 URL: https://issues.jboss.org/browse/TEIID-5729 Project: Teiid Issue Type: Enhancement Reporter: Christoph John Assignee: Steven Hawkins This is a follow up regarding https://issues.jboss.org/browse/TEIID-5725 As discussed there, Teiid currently does not map virtual procedures and functions to odata functions and procedures according to the notion of "side effect free" Please introduce a mechanism to allow for a mapping according to adequate odata semantics. -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5725) Please improve documentation on definition of stored procedures, virtual functions and virtual procedures

by Christoph John (Jira)

[ https://issues.jboss.org/browse/TEIID-5725?page=com.atlassian.jira.plugin... ] Christoph John commented on TEIID-5725: --------------------------------------- >>Another thing to consider is if you even need an atomic block. Are you worried about a competing update to NutritionGoal in between the select and update? Yes, this is the situation I would like to safeguard. >> Yes that is the workaround in this case if you want it as an action. More than likely though we'd want the semantics of "side effect free" to be represented rather than documenting this as a corner case. Can you log an issue about this? I will do that. >>You could combine both of the selects, and you may find it easier to read using a loop rather than a lot of scalar subqueries: Thanks for the code improvement > Please improve documentation on definition of stored procedures, virtual functions and virtual procedures > --------------------------------------------------------------------------------------------------------- > > Key: TEIID-5725 > URL: https://issues.jboss.org/browse/TEIID-5725 > Project: Teiid > Issue Type: Enhancement > Components: Documentation > Reporter: Christoph John > Assignee: Steven Hawkins > Priority: Critical > > I refer to the discussion with Ramesh in > https://developer.jboss.org/message/989048#989048 and would like to ask for a more detailed explanation on how to write virtual procedures and functions. > -Especially, how are OUT and INOUT params set and how can they be obtained via odata. > - How is the return value of a virtual function set? > - How are collections and arrays of collections returned? -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 8 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues April 2019