May 2017 - teiid-issues - Jboss List Archives

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

by Kylin Soong (JIRA)

[ https://issues.jboss.org/browse/TEIID-4552?page=com.atlassian.jira.plugin... ] Kylin Soong resolved TEIID-4552. -------------------------------- Resolution: Done > 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-4910) Update build to utilize a maven docker plugin

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4910?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-4910: ------------------------------------- I thought we wanted this 10, I can a look. > 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-4808) Infinispan Cache Resource Adapter: NullPointerException

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4808?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4808: ------------------------------------------------ Debi Rieden <drieden(a)redhat.com> changed the Status of [bug 1431577|https://bugzilla.redhat.com/show_bug.cgi?id=1431577] from NEW to CLOSED > Infinispan Cache Resource Adapter: NullPointerException > ------------------------------------------------------- > > Key: TEIID-4808 > URL: https://issues.jboss.org/browse/TEIID-4808 > Project: Teiid > Issue Type: Bug > Components: JDG Connector > Affects Versions: 8.12.10.6_3 > Reporter: Jan Stastny > Assignee: Van Halbert > Fix For: 9.3, 8.12.x-6.4 > > > There is a NPE when trying to query a local cache via Infinispan Cache translator. > {code} > [31m10:27:43,186 ERROR [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue1) Connector worker process failed for atomic-request=6chGAXrxul8Z.0.3.0: java.lang.NullPointerException > at org.teiid.resource.adapter.infinispan.InfinispanCacheWrapper.getClassRegistry(InfinispanCacheWrapper.java:128) > at org.teiid.resource.adapter.infinispan.InfinispanCacheRAConnection.getClassRegistry(InfinispanCacheRAConnection.java:137) > at org.teiid.translator.object.ObjectExecution.<init>(ObjectExecution.java:195) [translator-object-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1] > at org.teiid.translator.infinispan.cache.InfinispanCacheExecutionFactory$1.<init>(InfinispanCacheExecutionFactory.java:93) [translator-infinispan-cache-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1] > at org.teiid.translator.infinispan.cache.InfinispanCacheExecutionFactory.createResultSetExecution(InfinispanCacheExecutionFactory.java:93) [translator-infinispan-cache-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1] > at org.teiid.translator.infinispan.cache.InfinispanCacheExecutionFactory.createResultSetExecution(InfinispanCacheExecutionFactory.java:51) [translator-infinispan-cache-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1] > at org.teiid.translator.ExecutionFactory.createExecution(ExecutionFactory.java:316) [teiid-api-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1] > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:354) [teiid-engine-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1] > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_111] > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_111] > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_111] > at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_111] > at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) [teiid-engine-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1] > at com.sun.proxy.$Proxy103.execute(Unknown Source) > at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306) [teiid-engine-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1] > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112) [teiid-engine-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1] > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) [teiid-engine-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1] > at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_111] > at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65) [teiid-engine-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1] > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:280) [teiid-engine-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.10.6_3-redhat-1.jar:8.12.10.6_3-redhat-1] > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_111] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_111] > at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_111] > {code} > POJO's module.xml: > {code:xml} > <module xmlns="urn:jboss:module:1.1" name="org.jboss.qe.jdg.pojos"> > <resources> > <resource-root path="jdg-pojos-1.2.jar"/> >  > </resources> > <dependencies> >  > <module name="org.jboss.teiid.resource-adapter.infinispan" slot="6" /> >  > <module name="org.infinispan.client.hotrod" slot="jdg-6.4" optional="true" export="true" /> > <module name="org.infinispan.protostream" slot="jdg-6.4" optional="true" export="true" /> > <module name="org.infinispan.client.hotrod" slot="jdg-6.5" optional="true" export="true" /> > <module name="org.infinispan.protostream" slot="jdg-6.5" optional="true" export="true" /> > <module name="org.infinispan.client.hotrod" slot="jdg-6.6" optional="true" export="true" /> > <module name="org.infinispan.protostream" slot="jdg-6.6" optional="true" export="true" /> > </dependencies> > </module> > {code} > Resource-adapter configuration: > {code:xml} > <resource-adapter id="jdg-ra-ds"> > <module slot="6" id="org.jboss.teiid.resource-adapter.infinispan"/> > <transaction-support>LocalTransaction</transaction-support> > <connection-definitions> > <connection-definition class-name="org.teiid.resource.adapter.infinispan.InfinispanManagedConnectionFactory" jndi-name="java:/infinispanTest" enabled="true" use-java-context="true" pool-name="jdg-ra-ds"> > <config-property name="CacheJndiName"> > java:jboss/infinispan/container/teiid-infinispan-quickstart > </config-property> > <config-property name="Module"> > org.jboss.qe.jdg.pojos > </config-property> > <config-property name="CacheTypeMap"> > local-quickstart-cache:org.jboss.qe.jdg.pojo.SmallA;intKey > </config-property> > </connection-definition> > </connection-definitions> > </resource-adapter> > {code} > Translator: > {code:xml} > <translator name="infinispan-cache" module="org.jboss.teiid.translator.infinispan.cache"/> > {code} -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4866) Enhance SQL Alchemy integration to work with Superset

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4866?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4866. ----------------------------------- Resolution: Done Marking as initially resolved. I had some issues installing superset on fedora, specifically the python cryptography package. Just to have it captured, I used something like: sudo yum install gcc libffi-devel python3-devel openssl-devel redhat-rpm-config gcc-c++ python-devel cyrus-sasl-devel sudo pip install cryptography To then proceed with the superset install. > Enhance SQL Alchemy integration to work with Superset > ----------------------------------------------------- > > Key: TEIID-4866 > URL: https://issues.jboss.org/browse/TEIID-4866 > Project: Teiid > Issue Type: Sub-task > Components: ODBC > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.3 > > > Superset (previously Caravel) integration allows for an expanded set of sources, which was requested https://github.com/airbnb/superset/issues/241 > After some initial testing it looks like we still have some type and other issues to address. -- 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)

Steven Hawkins created TEIID-4910: ------------------------------------- Summary: 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 reassigned TEIID-4901: ---------------------------------- Assignee: Steven Hawkins (was: Van Halbert) > 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 Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4884?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4884: --------------------------------------- Does it work to purge the connection pool? If so, we should be able to workaround this with an appropriate isAlive method on the connection. > 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-4897) Null pointer on ExecutionContext.getSubject().getPrincipals()

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4897?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4897. ----------------------------------- Resolution: Out of Date Resolving as out of date for now. Please reopen if you can reproduce this on a later version. > Null pointer on ExecutionContext.getSubject().getPrincipals() > ------------------------------------------------------------- > > Key: TEIID-4897 > URL: https://issues.jboss.org/browse/TEIID-4897 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.11 > Reporter: Rafael Coutinho > Assignee: Steven Hawkins > Priority: Minor > > Is there any configuration that would avoid my translator to get the user logged into the TEIID connection? > I'm extending the jdbc connector and during a query i want to get the currently logged user as displayed below. > However I always get null for getSubject. > @Override > public ResultSetExecution createResultSetExecution(QueryExpression command, ExecutionContext executionContext, RuntimeMetadata metadata, Connection conn) throws TranslatorException { > try { > System.out.println(executionContext.getSubject()); > System.out.println(executionContext.getSubject().getPrincipals()); > } catch (Exception e) { > System.err.println(e.getMessage()); > } > return new SagenceIonicTranslatorExecution(command, conn, executionContext, this); > } -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4854) Google translator fails to update timestamp value reformatted after update

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4854?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4854: --------------------------------------- Looking at the v4 google apis, this issue will likely still be there. From the docs I don't see a single notion of canonical RAW date/time/timestamp/numeric value. My proposed resolution is to add an import property to turn off automatically marking tables as updatable, and to add a doc note that updates of non-string values may behave unpredictably - as it seems that simply adjusting the locale isn't enough that either the automatic type detection or residual settings from the initial locale affect the values sent from Teiid. > Google translator fails to update timestamp value reformatted after update > -------------------------------------------------------------------------- > > Key: TEIID-4854 > URL: https://issues.jboss.org/browse/TEIID-4854 > Project: Teiid > Issue Type: Bug > Affects Versions: 9.3, 8.12.10.6_3 > Reporter: Lucie Fabrikova > Assignee: Steven Hawkins > Fix For: 9.3 > > Attachments: gs-reformatted-timestamp.log > > > Cell of type timestamp is reformatted after an update. Data inserted from teiid are in format "yyyy-mm-dd hh:mm:ss[.fffffffff]", which is reformatted to "dd/mm/yyyy hh:mm:ss[.fffffffff]". Subsequent update of such row throws exception "Could not convert source column Source.smalla.timestampvalue to the expected runtime type timestamp". > Google spreadsheet locale was UK, timezone was set to Berlin. -- 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 updated TEIID-4901: ------------------------------- Fix Version/s: 8.12.x-6.4 > 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: Van Halbert > 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

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues May 2017