[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
> …
[View More]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)
[View Less]
5 years, 11 months
[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 …
[View More]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)
[View Less]
5 years, 11 months
[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 …
[View More]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)
[View Less]
5 years, 11 months