May 2017 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4912) DDL VDB doesn't support CREATE GLOBAL TEMPORARY TABLE

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4912?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4912: --------------------------------------- The ddl is not complete. There is some boilerplate that is needed for SQL compliance, and you still need to create the table as part of a schema: CREATE DATABASE Portfolio; USE DATABASE Portfolio; CREATE VIRTUAL SCHEMA Sample; SET SCHEMA Sample; CREATE GLOBAL TEMPORARY TABLE GTEMP (id SERIAL, name string, PRIMARY KEY (id)) OPTIONS (UPDATABLE 'true'); > Also, is there a validate api to validate the ddl like xml validation? Nothing concise yet. The analogous logic is in VDBParserDeployer.parseVDBDDL > DDL VDB doesn't support CREATE GLOBAL TEMPORARY TABLE > ----------------------------------------------------- > > Key: TEIID-4912 > URL: https://issues.jboss.org/browse/TEIID-4912 > Project: Teiid > Issue Type: Quality Risk > Affects Versions: 9.3 > Reporter: Kylin Soong > Assignee: Steven Hawkins > Fix For: 10.0 > > > I tried to deploy VDB via ddl via embedded server, my ddl looks > {code} > CREATE DATABASE Portfolio; > CREATE GLOBAL TEMPORARY TABLE GTEMP (id SERIAL, name string, PRIMARY KEY (id)) OPTIONS (UPDATABLE 'true'); > {code} > But the deployment failed with trace: > {code} > Exception in thread "main" org.teiid.metadata.ParseException: TEIID31259 In the statement ending with token GTEMP on line 2 column 31 the ddl is not valid: TEIID31246 No database in context; Try using "create database ..." or "use database ..." first. > at org.teiid.query.parser.QueryParser.parseDDL(QueryParser.java:567) > at org.teiid.metadatastore.DeploymentBasedDatabaseStore.getVDBMetadata(DeploymentBasedDatabaseStore.java:79) > at org.teiid.runtime.EmbeddedServer.deployVDB(EmbeddedServer.java:738) > at org.teiid.test.teiid4911.TEIID4911.main(TEIID4911.java:32) > Caused by: org.teiid.metadata.MetadataException: TEIID31246 No database in context; Try using "create database ..." or "use database ..." first. > at org.teiid.query.metadata.DatabaseStore.getCurrentDatabase(DatabaseStore.java:405) > at org.teiid.query.metadata.DatabaseStore.createMF(DatabaseStore.java:844) > at org.teiid.query.parser.SQLParser.createTable(SQLParser.java:14002) > at org.teiid.query.parser.SQLParser.ddlStmt(SQLParser.java:12596) > at org.teiid.query.parser.SQLParser.parseMetadata(SQLParser.java:12577) > at org.teiid.query.parser.QueryParser.parseDDL(QueryParser.java:561) > ... 3 more > {code} -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4910) Update build to utilize a maven docker plugin

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4910?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4910: --------------------------------------- It can go in whenever. The dockerfile needed an update to Java 8 anyway, so it seemed appropriate to look at updating the whole thing. It could be the java version, but I tried the 9.2.2 image on the latest minishift and it fails to start. > Update build to utilize a maven docker plugin > --------------------------------------------- > > Key: TEIID-4910 > URL: https://issues.jboss.org/browse/TEIID-4910 > Project: Teiid > Issue Type: Task > Components: Build/Kits > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.3 > > > We need to automate creating and pushing the docker image. It also needs updated to use java 8. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4901) Add parallel source query handling for when IN criteria values exceed MaxInCriteriaSize for translator

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4901?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-4901: ------------------------------------ I'll remove the test from the other issue and retry, so that I don't include anything not applicable to the actual change. > Add parallel source query handling for when IN criteria values exceed MaxInCriteriaSize for translator > ------------------------------------------------------------------------------------------------------ > > Key: TEIID-4901 > URL: https://issues.jboss.org/browse/TEIID-4901 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Affects Versions: 8.12.10.6_3 > Reporter: Marc Shirley > Assignee: Steven Hawkins > Fix For: 9.3, 8.12.x-6.4, 8.12.11.6_3 > > > Add the capability to split an independent accessnode into multiple parallel source queries when the number of IN criteria values exceed the translator's MaxInCriteriaSize value. This would be similar handling to what we perform on the dependent side of a dependent join when the number of values exceed the size. > The background for this request is regarding input to an SAP gateway source which has a MaxInCriteriaSize of 3 due to URL length restrictions. Currently, if 4 values are submitted the full result set is returned to be processed within the Teiid engine. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4884) Google spreadsheet throws Error when getting batch 401:Unauthorized

by Lucie Fabrikova (JIRA)

[ https://issues.jboss.org/browse/TEIID-4884?page=com.atlassian.jira.plugin... ] Lucie Fabrikova commented on TEIID-4884: ---------------------------------------- I haven't observed any specific pattern which would lead to this issue, I will try to perform more testing. > Google spreadsheet throws Error when getting batch 401:Unauthorized > ------------------------------------------------------------------- > > Key: TEIID-4884 > URL: https://issues.jboss.org/browse/TEIID-4884 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 9.3 > Reporter: Lucie Fabrikova > Assignee: Steven Hawkins > Fix For: 9.3 > > Attachments: gs-http401 > > > It seems that after executing a larger load of queries following error occurs: "Error when getting batch 401:Unauthorized". -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4552) Missing support for connection to Facebook via OAuth 2

by Lucie Fabrikova (JIRA)

[ https://issues.jboss.org/browse/TEIID-4552?page=com.atlassian.jira.plugin... ] Lucie Fabrikova updated TEIID-4552: ----------------------------------- Attachment: error_facebook_null > Missing support for connection to Facebook via OAuth 2 > ------------------------------------------------------ > > Key: TEIID-4552 > URL: https://issues.jboss.org/browse/TEIID-4552 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Affects Versions: 8.12.5 > Reporter: Lucie Fabrikova > Assignee: Kylin Soong > Fix For: 9.3 > > Attachments: error_facebook_null, facebook3-vdb.xml, query, server.log, standalone.xml, teiid-oauth-util.sh-output > > > I would like to connect to facebook resource adapter and configure OAuth 2 security domain for it; I used teiid-oauth-util.sh to generate the security domain (see attachment). Facebook doesn't support refresh tokens and in the generated code is refresh token's value "null". > If I try to execute VDB with source pointing to such resource adapter I get error: > ERROR [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue13) Connector worker process failed for atomic-request=Gapuea1/NRcn.6.3.0: org.apache.cxf.rs.security.oauth2.provider.OAuthServiceException > > (see server.log, facebook-vdb.xml, standalone.xml) -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4552) Missing support for connection to Facebook via OAuth 2

by Lucie Fabrikova (JIRA)

[ https://issues.jboss.org/browse/TEIID-4552?page=com.atlassian.jira.plugin... ] Lucie Fabrikova commented on TEIID-4552: ---------------------------------------- I am sorry for late response, generated access token is not null and works correctly e.g. directly in web browser (https://graph.facebook.com/v2.7/myUserId?access_token=myGeneratedAT) However I have difficulties with using the generated security domain for facebook resource adapter. If I deploy vdb like the one attached and execute query like: call facebook.invokeHTTP(endpoint=>'https://graph.facebook.com/v2.7/myUserId/feed?access_token=myGeneratedAT&...', action=>'POST'), attached error is thrown. I generated access token with teiid-oauth-util.sh in teiid-9.3.0.Beta3, urls are left default, scope user_posts. (If I removed from resource adapter definition the SecurityType config-property and security-domain, I can execute the query correctly.) > Missing support for connection to Facebook via OAuth 2 > ------------------------------------------------------ > > Key: TEIID-4552 > URL: https://issues.jboss.org/browse/TEIID-4552 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Affects Versions: 8.12.5 > Reporter: Lucie Fabrikova > Assignee: Kylin Soong > Fix For: 9.3 > > Attachments: facebook3-vdb.xml, query, server.log, standalone.xml, teiid-oauth-util.sh-output > > > I would like to connect to facebook resource adapter and configure OAuth 2 security domain for it; I used teiid-oauth-util.sh to generate the security domain (see attachment). Facebook doesn't support refresh tokens and in the generated code is refresh token's value "null". > If I try to execute VDB with source pointing to such resource adapter I get error: > ERROR [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue13) Connector worker process failed for atomic-request=Gapuea1/NRcn.6.3.0: org.apache.cxf.rs.security.oauth2.provider.OAuthServiceException > > (see server.log, facebook-vdb.xml, standalone.xml) -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4912) DDL VDB doesn't support CREATE GLOBAL TEMPORARY TABLE

by Kylin Soong (JIRA)

[ https://issues.jboss.org/browse/TEIID-4912?page=com.atlassian.jira.plugin... ] Kylin Soong commented on TEIID-4912: ------------------------------------ Also, is there a validate api to validate the ddl like xml validation? {code} VDBMetadataParser.validate(content); {code} > DDL VDB doesn't support CREATE GLOBAL TEMPORARY TABLE > ----------------------------------------------------- > > Key: TEIID-4912 > URL: https://issues.jboss.org/browse/TEIID-4912 > Project: Teiid > Issue Type: Quality Risk > Affects Versions: 9.3 > Reporter: Kylin Soong > Assignee: Steven Hawkins > Fix For: 10.0 > > > I tried to deploy VDB via ddl via embedded server, my ddl looks > {code} > CREATE DATABASE Portfolio; > CREATE GLOBAL TEMPORARY TABLE GTEMP (id SERIAL, name string, PRIMARY KEY (id)) OPTIONS (UPDATABLE 'true'); > {code} > But the deployment failed with trace: > {code} > Exception in thread "main" org.teiid.metadata.ParseException: TEIID31259 In the statement ending with token GTEMP on line 2 column 31 the ddl is not valid: TEIID31246 No database in context; Try using "create database ..." or "use database ..." first. > at org.teiid.query.parser.QueryParser.parseDDL(QueryParser.java:567) > at org.teiid.metadatastore.DeploymentBasedDatabaseStore.getVDBMetadata(DeploymentBasedDatabaseStore.java:79) > at org.teiid.runtime.EmbeddedServer.deployVDB(EmbeddedServer.java:738) > at org.teiid.test.teiid4911.TEIID4911.main(TEIID4911.java:32) > Caused by: org.teiid.metadata.MetadataException: TEIID31246 No database in context; Try using "create database ..." or "use database ..." first. > at org.teiid.query.metadata.DatabaseStore.getCurrentDatabase(DatabaseStore.java:405) > at org.teiid.query.metadata.DatabaseStore.createMF(DatabaseStore.java:844) > at org.teiid.query.parser.SQLParser.createTable(SQLParser.java:14002) > at org.teiid.query.parser.SQLParser.ddlStmt(SQLParser.java:12596) > at org.teiid.query.parser.SQLParser.parseMetadata(SQLParser.java:12577) > at org.teiid.query.parser.QueryParser.parseDDL(QueryParser.java:561) > ... 3 more > {code} -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4912) DDL VDB doesn't support CREATE GLOBAL TEMPORARY TABLE

by Kylin Soong (JIRA)

[ https://issues.jboss.org/browse/TEIID-4912?page=com.atlassian.jira.plugin... ] Kylin Soong commented on TEIID-4912: ------------------------------------ Why I has this kinds of requirements? because, as per my thought, the translator/connector are auto-detected and setup automatically, so the only left is create a virtual database, and create Views, Tables, etc. If deploy with xml as bellow, it works fine. {code} <vdb name="Portfolio" version="1"> <model name="Sample" type="VIRTUAL"> <metadata type="DDL"><![CDATA[ CREATE GLOBAL TEMPORARY TABLE GTEMP (id SERIAL, name string, PRIMARY KEY (id)) OPTIONS (UPDATABLE 'true'); ]]> </metadata> </model> </vdb> {code} > DDL VDB doesn't support CREATE GLOBAL TEMPORARY TABLE > ----------------------------------------------------- > > Key: TEIID-4912 > URL: https://issues.jboss.org/browse/TEIID-4912 > Project: Teiid > Issue Type: Quality Risk > Affects Versions: 9.3 > Reporter: Kylin Soong > Assignee: Steven Hawkins > Fix For: 10.0 > > > I tried to deploy VDB via ddl via embedded server, my ddl looks > {code} > CREATE DATABASE Portfolio; > CREATE GLOBAL TEMPORARY TABLE GTEMP (id SERIAL, name string, PRIMARY KEY (id)) OPTIONS (UPDATABLE 'true'); > {code} > But the deployment failed with trace: > {code} > Exception in thread "main" org.teiid.metadata.ParseException: TEIID31259 In the statement ending with token GTEMP on line 2 column 31 the ddl is not valid: TEIID31246 No database in context; Try using "create database ..." or "use database ..." first. > at org.teiid.query.parser.QueryParser.parseDDL(QueryParser.java:567) > at org.teiid.metadatastore.DeploymentBasedDatabaseStore.getVDBMetadata(DeploymentBasedDatabaseStore.java:79) > at org.teiid.runtime.EmbeddedServer.deployVDB(EmbeddedServer.java:738) > at org.teiid.test.teiid4911.TEIID4911.main(TEIID4911.java:32) > Caused by: org.teiid.metadata.MetadataException: TEIID31246 No database in context; Try using "create database ..." or "use database ..." first. > at org.teiid.query.metadata.DatabaseStore.getCurrentDatabase(DatabaseStore.java:405) > at org.teiid.query.metadata.DatabaseStore.createMF(DatabaseStore.java:844) > at org.teiid.query.parser.SQLParser.createTable(SQLParser.java:14002) > at org.teiid.query.parser.SQLParser.ddlStmt(SQLParser.java:12596) > at org.teiid.query.parser.SQLParser.parseMetadata(SQLParser.java:12577) > at org.teiid.query.parser.QueryParser.parseDDL(QueryParser.java:561) > ... 3 more > {code} -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4912) DDL VDB doesn't support CREATE GLOBAL TEMPORARY TABLE

by Kylin Soong (JIRA)

Kylin Soong created TEIID-4912: ---------------------------------- Summary: DDL VDB doesn't support CREATE GLOBAL TEMPORARY TABLE Key: TEIID-4912 URL: https://issues.jboss.org/browse/TEIID-4912 Project: Teiid Issue Type: Quality Risk Affects Versions: 9.3 Reporter: Kylin Soong Assignee: Steven Hawkins Fix For: 10.0 I tried to deploy VDB via ddl via embedded server, my ddl looks {code} CREATE DATABASE Portfolio; CREATE GLOBAL TEMPORARY TABLE GTEMP (id SERIAL, name string, PRIMARY KEY (id)) OPTIONS (UPDATABLE 'true'); {code} But the deployment failed with trace: {code} Exception in thread "main" org.teiid.metadata.ParseException: TEIID31259 In the statement ending with token GTEMP on line 2 column 31 the ddl is not valid: TEIID31246 No database in context; Try using "create database ..." or "use database ..." first. at org.teiid.query.parser.QueryParser.parseDDL(QueryParser.java:567) at org.teiid.metadatastore.DeploymentBasedDatabaseStore.getVDBMetadata(DeploymentBasedDatabaseStore.java:79) at org.teiid.runtime.EmbeddedServer.deployVDB(EmbeddedServer.java:738) at org.teiid.test.teiid4911.TEIID4911.main(TEIID4911.java:32) Caused by: org.teiid.metadata.MetadataException: TEIID31246 No database in context; Try using "create database ..." or "use database ..." first. at org.teiid.query.metadata.DatabaseStore.getCurrentDatabase(DatabaseStore.java:405) at org.teiid.query.metadata.DatabaseStore.createMF(DatabaseStore.java:844) at org.teiid.query.parser.SQLParser.createTable(SQLParser.java:14002) at org.teiid.query.parser.SQLParser.ddlStmt(SQLParser.java:12596) at org.teiid.query.parser.SQLParser.parseMetadata(SQLParser.java:12577) at org.teiid.query.parser.QueryParser.parseDDL(QueryParser.java:561) ... 3 more {code} -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4911) Teiid embedded support Spring boot

by Kylin Soong (JIRA)

Kylin Soong created TEIID-4911: ---------------------------------- Summary: Teiid embedded support Spring boot Key: TEIID-4911 URL: https://issues.jboss.org/browse/TEIID-4911 Project: Teiid Issue Type: Sub-task Reporter: Kylin Soong Assignee: Kylin Soong Fix For: 10.0 -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 10 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 May 2017