[JBoss JIRA] (TEIID-3191) Teiid global temporary table error with first invocation
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3191?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3191:
---------------------------------------
Yes, that reproduces it. There is an issue with having the primary key.
> Teiid global temporary table error with first invocation
> --------------------------------------------------------
>
> Key: TEIID-3191
> URL: https://issues.jboss.org/browse/TEIID-3191
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.7.1
> Reporter: Jan Stastny
> Assignee: Steven Hawkins
> Attachments: nativeSQL.vdb
>
>
> When working with global temporary table in teiid an error occurs while accessing the temp table for the first time.
> Error: org.teiid.metadata.Column cannot be cast to org.teiid.query.metadata.TempMetadataID
> All the following invocations of the global temporary table run fine.
> Global temporary table is defined through Teiid designer within my vdb.
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
10 years, 1 month
[JBoss JIRA] (TEIID-3191) Teiid global temporary table error with first invocation
by Jan Stastny (JIRA)
[ https://issues.jboss.org/browse/TEIID-3191?page=com.atlassian.jira.plugin... ]
Jan Stastny updated TEIID-3191:
-------------------------------
Attachment: nativeSQL.vdb
The vdb serves to test temporary table functionality.
In the source model there is native procedure to run native queries.
In the view model there is definition of global_temp_table.
> Teiid global temporary table error with first invocation
> --------------------------------------------------------
>
> Key: TEIID-3191
> URL: https://issues.jboss.org/browse/TEIID-3191
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.7.1
> Reporter: Jan Stastny
> Assignee: Steven Hawkins
> Attachments: nativeSQL.vdb
>
>
> When working with global temporary table in teiid an error occurs while accessing the temp table for the first time.
> Error: org.teiid.metadata.Column cannot be cast to org.teiid.query.metadata.TempMetadataID
> All the following invocations of the global temporary table run fine.
> Global temporary table is defined through Teiid designer within my vdb.
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
10 years, 1 month
[JBoss JIRA] (TEIID-2819) Use Oauth SAML Bearer Assertion Flow
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-2819?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-2819:
-------------------------------------
SAML implementation on server/client web application is defined here [http://cxf.apache.org/docs/jax-rs-saml.html] TODO: write a sample application for testing
In OAuth2, the client application typically need to register first with source (ex: google, twitter, salesforce), then they provide a "client_id" representing the registered application and "secret_key" to be used. Then when user wanting to gain access to SP, can use "client_id" and "secret_key" to get a "authorization code", using a their credentials. For different sources, the auth url is different, need to consult their docs. This "authorization code" is specific to a given user. Now, given "authorization code" client can make the calls. I found this [http://oauth.net/] and this library [https://github.com/fernandezpablo85/scribe-java]
One of the ways SAML assertion can be used as "authentication code" is SAML Bearer. Now
The CXF support is defined here [http://cxf.apache.org/docs/jax-rs-oauth2.html] and [http://cxf.apache.org/docs/jaxrs-oauth2-assertions.html]
Basically in SSO scenario, if a user issues query into Teiid who is originally authenticated using "SAML" (may be through odata, or some other upstream app) then that SAML assertion can be used as "authorization code" to gain access to a OAuth2 application. Using the "authorization code", OAuth2 IDP can provide the "access-token" that can be used in the http header to issue the final query back to source.
Now the question is how this needs to be done in Teiid?
1) Need to build a JAAS login module to handle general OAuth2 calls to resources like google, twitter, fb etc.
2) The based on the previous subject in context the check for SAML assertions?
> Use Oauth SAML Bearer Assertion Flow
> ------------------------------------
>
> Key: TEIID-2819
> URL: https://issues.jboss.org/browse/TEIID-2819
> Project: Teiid
> Issue Type: Feature Request
> Components: Server
> Reporter: Van Halbert
> Assignee: Ramesh Reddy
>
> I can secure my mobile and cloud applications?
> Consider doing SAML first and Oauth later – the use cases are the same, the implementation is different
> Link - https://help.salesforce.com/apex/HTViewHelpDoc?id=remoteaccess_oauth_SAML...
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
10 years, 1 month
[JBoss JIRA] (TEIID-3191) Teiid global temporary table error with first invocation
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3191?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3191:
---------------------------------------
I can't reproduce this using a dynamic vdb. Can you provide the designer vdb?
> Teiid global temporary table error with first invocation
> --------------------------------------------------------
>
> Key: TEIID-3191
> URL: https://issues.jboss.org/browse/TEIID-3191
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.7.1
> Reporter: Jan Stastny
> Assignee: Steven Hawkins
>
> When working with global temporary table in teiid an error occurs while accessing the temp table for the first time.
> Error: org.teiid.metadata.Column cannot be cast to org.teiid.query.metadata.TempMetadataID
> All the following invocations of the global temporary table run fine.
> Global temporary table is defined through Teiid designer within my vdb.
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
10 years, 1 month
[JBoss JIRA] (TEIID-3191) Teiid global temporary table error with first invocation
by Jan Stastny (JIRA)
Jan Stastny created TEIID-3191:
----------------------------------
Summary: Teiid global temporary table error with first invocation
Key: TEIID-3191
URL: https://issues.jboss.org/browse/TEIID-3191
Project: Teiid
Issue Type: Bug
Affects Versions: 8.7.1
Reporter: Jan Stastny
Assignee: Steven Hawkins
When working with global temporary table in teiid an error occurs while accessing the temp table for the first time.
Error: org.teiid.metadata.Column cannot be cast to org.teiid.query.metadata.TempMetadataID
All the following invocations of the global temporary table run fine.
Global temporary table is defined through Teiid designer within my vdb.
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
10 years, 1 month
[JBoss JIRA] (TEIID-3177) Enforce SSL connections over ODBC when Encryption Mode is enabled
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3177?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3177:
---------------------------------------
To keep this from being a behavioral change by default, the initial setting for the pg transport is now disabled rather than login. This is highlighted in the docs.
> Enforce SSL connections over ODBC when Encryption Mode is enabled
> -----------------------------------------------------------------
>
> Key: TEIID-3177
> URL: https://issues.jboss.org/browse/TEIID-3177
> Project: Teiid
> Issue Type: Feature Request
> Components: ODBC
> Affects Versions: 8.8
> Reporter: Cristiano Nicolai
> Assignee: Steven Hawkins
> Priority: Critical
> Fix For: 8.9
>
>
> When connecting via ODBC transport, even if the encryption mode is set to enabled is still possible to establish non ssl connections. This allows clients to connect via insecure method. We would like that the Teiid transport could reject connections if they are not properly set up using SSL transport.
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
10 years, 1 month