December 2014 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3251) Support OAuth 1.0 & OAuth 2.0 Authorization with Web Service resource-adapter

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-3251?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-3251: ------------------------------------- OAuth specification can be found in [http://oauth.org], CXF does have the OAuth support. The workflow between OAuth 1.0a and OAuth 2 seems to be different, and may require different implementations. I am considering writing a OAuthLoginModule that can be used as security-domain for a data source. In this case, LoginModule will inject a special private credential that will help create the authorization code in all the web service requests. Typically OAuth flow requires a user participation in logging on to the website and accepting/granting authorization to the third party vendor like Teiid. The approval process can be different for different web sites, so automating this seems to highly customized. I suggest, we provide a standalone utility to help guide the user with the flow of OAuth granting process, where this utility can collect necessary information from user and direct them through authentication process. Based on the information this will provide the LoginModule XML for standalone.xml file. For users, who want to automate or use this in "delegate" fashion, LoginModule can be extended to provide the same information that is gathered in manual step. > Support OAuth 1.0 & OAuth 2.0 Authorization with Web Service resource-adapter > ----------------------------------------------------------------------------- > > Key: TEIID-3251 > URL: https://issues.jboss.org/browse/TEIID-3251 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Fix For: 8.10 > > > Support OAuth 1.0a and OAuth 2.0 based authorization with Web Service resource adapters. This will also enable to support sources like Twitter, FaceBook easily in Teiid. > Google Spread Sheet does it own OAuth right now, thus requires a resource adapter. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3251) Support OAuth 1.0 & OAuth 2.0 Authorization with Web Service resource-adapter

by Ramesh Reddy (JIRA)

Ramesh Reddy created TEIID-3251: ----------------------------------- Summary: Support OAuth 1.0 & OAuth 2.0 Authorization with Web Service resource-adapter Key: TEIID-3251 URL: https://issues.jboss.org/browse/TEIID-3251 Project: Teiid Issue Type: Feature Request Components: Misc. Connectors Reporter: Ramesh Reddy Assignee: Ramesh Reddy Fix For: 8.10 Support OAuth 1.0a and OAuth 2.0 based authorization with Web Service resource adapters. This will also enable to support sources like Twitter, FaceBook easily in Teiid. Google Spread Sheet does it own OAuth right now, thus requires a resource adapter. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3250) Rewritten unknown expression in select becomes false

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3250?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3250. ----------------------------------- Resolution: Done Changed the rewrite to use the three value method instead of just true/false. > Rewritten unknown expression in select becomes false > ---------------------------------------------------- > > Key: TEIID-3250 > URL: https://issues.jboss.org/browse/TEIID-3250 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.0 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.10 > > > select 1 = null > will be rewritten as > select false > it should instead be > select null -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3250) Rewritten unknown expression in select becomes false

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-3250: ------------------------------------- Summary: Rewritten unknown expression in select becomes false Key: TEIID-3250 URL: https://issues.jboss.org/browse/TEIID-3250 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 8.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.10 select 1 = null will be rewritten as select false it should instead be select null -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3249) XMLCOMMENT missing validation

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-3249: ------------------------------------- Summary: XMLCOMMENT missing validation Key: TEIID-3249 URL: https://issues.jboss.org/browse/TEIID-3249 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.7 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Minor Fix For: 8.10 XMLCOMMENT should check if the string contains -- or ends with - to ensure that the comment content is valid. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3248) Null handling in XMLQUERY and XMLTABLE

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-3248: ------------------------------------- Summary: Null handling in XMLQUERY and XMLTABLE Key: TEIID-3248 URL: https://issues.jboss.org/browse/TEIID-3248 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.7 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.10 Null handling in XMLQUERY and XMLTABLE is not correct - both are currently exceptions. A null context item in XMLQUERY should result in an UNKNOWN result while XMLTABLE should have no result rows. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3216) Implement INSERT, UPDATE and DELETE support for google-spreadsheet connector

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3216?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3216: --------------------------------------- > I believe expressions can be used as update values. For example, these queries works: Those work because the values are pre-evaluated or have a compensating procedure created, since they use unsupported constructs for the source. An expression using one of the supported functions - YEAR(col) - should get pushed and should fail in SpreadSheetCriteriaVisitor.getStringValue. > You say that "LIKE" limitation could be addressed with capabilities. How can I disable "LIKE" capability for update or delete statements? That would require an enhancement. We'd have to create a compensating procedure to first perform a select with the like criteria, then process the update/delete against the rows. > is there anything else I should do regarding this jira? As long as it seems like that we're in a good initial state, we can resolve this one and open new ones as needed. > Implement INSERT, UPDATE and DELETE support for google-spreadsheet connector > ---------------------------------------------------------------------------- > > Key: TEIID-3216 > URL: https://issues.jboss.org/browse/TEIID-3216 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Reporter: Filip Elias > Assignee: Filip Elias > Fix For: 8.10 > > > Current plan is to use list-based feed of the Google Data API[1]. > There are three known issues: > performance - to delete/update 100 rows Teiid must generate 100 http requests > consistency - user wants to update 50 rows. After the 10th row is updated the connection could fail which would cause that 10 rows would be updated and 40 wouldn't. > headers - update, delete and and insert statements will be supported only for the spreadsheets that have a header for each column (headers are in the first row of a spreadsheet) > Select statement is implemented using Google Visualisation API, but this API doesn't support updates and doesn't return row numbers. > [1] https://developers.google.com/google-apps/spreadsheets/ -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3216) Implement INSERT, UPDATE and DELETE support for google-spreadsheet connector

by Filip Elias (JIRA)

[ https://issues.jboss.org/browse/TEIID-3216?page=com.atlassian.jira.plugin... ] Filip Elias commented on TEIID-3216: ------------------------------------ Steven, is there anything else I should do regarding this jira? > Implement INSERT, UPDATE and DELETE support for google-spreadsheet connector > ---------------------------------------------------------------------------- > > Key: TEIID-3216 > URL: https://issues.jboss.org/browse/TEIID-3216 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Reporter: Filip Elias > Assignee: Filip Elias > Fix For: 8.10 > > > Current plan is to use list-based feed of the Google Data API[1]. > There are three known issues: > performance - to delete/update 100 rows Teiid must generate 100 http requests > consistency - user wants to update 50 rows. After the 10th row is updated the connection could fail which would cause that 10 rows would be updated and 40 wouldn't. > headers - update, delete and and insert statements will be supported only for the spreadsheets that have a header for each column (headers are in the first row of a spreadsheet) > Select statement is implemented using Google Visualisation API, but this API doesn't support updates and doesn't return row numbers. > [1] https://developers.google.com/google-apps/spreadsheets/ -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3216) Implement INSERT, UPDATE and DELETE support for google-spreadsheet connector

by Filip Elias (JIRA)

[ https://issues.jboss.org/browse/TEIID-3216?page=com.atlassian.jira.plugin... ] Filip Elias commented on TEIID-3216: ------------------------------------ I believe expressions can be used as update values. For example, these queries works: {code}update worksheet set cislo = (cislo +1999) where cislo > 2000 and jmeno = 'Pepik' {code} {code}update worksheet set cislo = (select cislo from worksheet where Jmeno = 'aaa') where cislo =1000{code} You say that "LIKE" limitation could be addressed with capabilities. How can I disable "LIKE" capability for update or delete statements? Characters needing URL encoding are not supported for date/timestamp/time columns. String columns support any characters. > Implement INSERT, UPDATE and DELETE support for google-spreadsheet connector > ---------------------------------------------------------------------------- > > Key: TEIID-3216 > URL: https://issues.jboss.org/browse/TEIID-3216 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Reporter: Filip Elias > Assignee: Filip Elias > Fix For: 8.10 > > > Current plan is to use list-based feed of the Google Data API[1]. > There are three known issues: > performance - to delete/update 100 rows Teiid must generate 100 http requests > consistency - user wants to update 50 rows. After the 10th row is updated the connection could fail which would cause that 10 rows would be updated and 40 wouldn't. > headers - update, delete and and insert statements will be supported only for the spreadsheets that have a header for each column (headers are in the first row of a spreadsheet) > Select statement is implemented using Google Visualisation API, but this API doesn't support updates and doesn't return row numbers. > [1] https://developers.google.com/google-apps/spreadsheets/ -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-1091) Add remaining SQL/XML functions

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-1091?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-1091: --------------------------------------- It looks like we should add xmltext, xmlcast, and xmlexists. xmlroot is oracle specific, and xmliterate from the spec doesn't seem to be commonly implemented. > Add remaining SQL/XML functions > ------------------------------- > > Key: TEIID-1091 > URL: https://issues.jboss.org/browse/TEIID-1091 > Project: Teiid > Issue Type: Sub-task > Components: Query Engine > Affects Versions: 7.1 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.10 > > > We should add the remaining functions, xmlparse, xmlserialize, xmlroot, etc. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years, 3 months

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues December 2014