April 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4150) Infinispan dsl resource-adapter has not valid module.xml

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4150?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4150: ---------------------------------- Fix Version/s: 9.0 > Infinispan dsl resource-adapter has not valid module.xml > -------------------------------------------------------- > > Key: TEIID-4150 > URL: https://issues.jboss.org/browse/TEIID-4150 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Reporter: Jan Stastny > Assignee: Van Halbert > Fix For: 9.0, 8.12.5 > > > There is a problem in mentioned module when server attempts to load it: > {code:plain} > [standalone@localhost:9999 /] /subsystem=resource-adapters/resource-adapter=infinispandsl:add(module=org.jboss.teiid.resource-adapter.infinispan.dsl) > { > "outcome" => "failed", > "failure-description" => "JBAS010473: Failed to load module for RA [org.jboss.teiid.resource-adapter.infinispan.dsl]", > "rolled-back" => true > } > {code} > It is not valid module according to the 'urn:jboss:module:1.1' schema. > Problematic fragment: > {code:xml} > <dependencies> > ... > <module name="org.infinispan.query" slot="jdg-6.6" optional="true" export="true" services="true" /> > ... > </dependencies> > {code} > According to the mentioned schema the attribute 'services' can have only values: > * none > * import > * export > This issue prevents a user from using the adapter. > Furthermore I am not sure that name 'org.infinispan.query' of the dependency module is correct. I haven't found such module in jdg client libs, there are two possible candidates though: > * org.infinispan.query.dsl > * org.infinispan.query.remote.client -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4112) ORA-32039: recursive WITH clause must have column alias list

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4112?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4112. ----------------------------------- Fix Version/s: 9.0 Resolution: Done Added a specific translator property for this - ExcludedCommonTableExpressionName It is currently only useful when certain with clauses are being pushed to oracle 11.2.0.2 - other later oracle versions should not be affected by this issues (we can follow up on their undocumented bug to get a full understanding of when this can occur). The logic will also in general allow us to remap common table expression names should we ever need to do that more generally. > ORA-32039: recursive WITH clause must have column alias list > ------------------------------------------------------------ > > Key: TEIID-4112 > URL: https://issues.jboss.org/browse/TEIID-4112 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector, Query Engine > Affects Versions: 8.7.2.6_2 > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Fix For: 9.0 > > > If running a WITH table AS(...) query to Oracle and the query schema name is the same as the subquery name i.e. EWI. you receive the Oracle error: > ORA-32039: recursive WITH clause must have column alias list > If you modify the query to > WITH EWI1 AS .... > then it works. > f.ex: > breaking: WITH tbl AS ( > where tbl = a common table name in the current schema and the common table definition as (...) references a view in that schema. Oracle will complain with this erroneous error. > work-around: WITH tbl_1 AS( > where tbl_1 does not exist as a current schema/table name. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4112) ORA-32039: recursive WITH clause must have column alias list

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4112?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4112: ---------------------------------- Component/s: JDBC Connector Query Engine > ORA-32039: recursive WITH clause must have column alias list > ------------------------------------------------------------ > > Key: TEIID-4112 > URL: https://issues.jboss.org/browse/TEIID-4112 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector, Query Engine > Affects Versions: 8.7.2.6_2 > Reporter: Debbie Steigner > Assignee: Steven Hawkins > > If running a WITH table AS(...) query to Oracle and the query schema name is the same as the subquery name i.e. EWI. you receive the Oracle error: > ORA-32039: recursive WITH clause must have column alias list > If you modify the query to > WITH EWI1 AS .... > then it works. > f.ex: > breaking: WITH tbl AS ( > where tbl = a common table name in the current schema and the common table definition as (...) references a view in that schema. Oracle will complain with this erroneous error. > work-around: WITH tbl_1 AS( > where tbl_1 does not exist as a current schema/table name. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4150) Infinispan dsl resource-adapter has not valid module.xml

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4150?page=com.atlassian.jira.plugin... ] Van Halbert resolved TEIID-4150. -------------------------------- Fix Version/s: 8.12.5 Resolution: Done > Infinispan dsl resource-adapter has not valid module.xml > -------------------------------------------------------- > > Key: TEIID-4150 > URL: https://issues.jboss.org/browse/TEIID-4150 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Reporter: Jan Stastny > Assignee: Van Halbert > Fix For: 8.12.5 > > > There is a problem in mentioned module when server attempts to load it: > {code:plain} > [standalone@localhost:9999 /] /subsystem=resource-adapters/resource-adapter=infinispandsl:add(module=org.jboss.teiid.resource-adapter.infinispan.dsl) > { > "outcome" => "failed", > "failure-description" => "JBAS010473: Failed to load module for RA [org.jboss.teiid.resource-adapter.infinispan.dsl]", > "rolled-back" => true > } > {code} > It is not valid module according to the 'urn:jboss:module:1.1' schema. > Problematic fragment: > {code:xml} > <dependencies> > ... > <module name="org.infinispan.query" slot="jdg-6.6" optional="true" export="true" services="true" /> > ... > </dependencies> > {code} > According to the mentioned schema the attribute 'services' can have only values: > * none > * import > * export > This issue prevents a user from using the adapter. > Furthermore I am not sure that name 'org.infinispan.query' of the dependency module is correct. I haven't found such module in jdg client libs, there are two possible candidates though: > * org.infinispan.query.dsl > * org.infinispan.query.remote.client -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4150) Infinispan dsl resource-adapter has not valid module.xml

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4150?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4150: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1328436|https://bugzilla.redhat.com/show_bug.cgi?id=1328436] from NEW to MODIFIED > Infinispan dsl resource-adapter has not valid module.xml > -------------------------------------------------------- > > Key: TEIID-4150 > URL: https://issues.jboss.org/browse/TEIID-4150 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Reporter: Jan Stastny > Assignee: Van Halbert > Fix For: 8.12.5 > > > There is a problem in mentioned module when server attempts to load it: > {code:plain} > [standalone@localhost:9999 /] /subsystem=resource-adapters/resource-adapter=infinispandsl:add(module=org.jboss.teiid.resource-adapter.infinispan.dsl) > { > "outcome" => "failed", > "failure-description" => "JBAS010473: Failed to load module for RA [org.jboss.teiid.resource-adapter.infinispan.dsl]", > "rolled-back" => true > } > {code} > It is not valid module according to the 'urn:jboss:module:1.1' schema. > Problematic fragment: > {code:xml} > <dependencies> > ... > <module name="org.infinispan.query" slot="jdg-6.6" optional="true" export="true" services="true" /> > ... > </dependencies> > {code} > According to the mentioned schema the attribute 'services' can have only values: > * none > * import > * export > This issue prevents a user from using the adapter. > Furthermore I am not sure that name 'org.infinispan.query' of the dependency module is correct. I haven't found such module in jdg client libs, there are two possible candidates though: > * org.infinispan.query.dsl > * org.infinispan.query.remote.client -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3035) Request to add NTLM Security to Web service datasources

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-3035?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-3035: ------------------------------------- [~dajester2011] we use CXF for http client, last time I checked they did not have NTLM support, but I found couple others. Basically in Teiid one needs to write JAAS based security domain, and pass it in the context that we can convert into whatever HEADERS in REST. Not sure about SOAP. If you want look into doing this let me know. > Request to add NTLM Security to Web service datasources > ------------------------------------------------------- > > Key: TEIID-3035 > URL: https://issues.jboss.org/browse/TEIID-3035 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Reporter: Debbie Steigner > Assignee: Ramesh Reddy > > Currently the only Security types we support for Web Service data sources is None, HTTPBasic and WSSecurity can NTLM be added? -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3035) Request to add NTLM Security to Web service datasources

by Jesse Shaffer (JIRA)

[ https://issues.jboss.org/browse/TEIID-3035?page=com.atlassian.jira.plugin... ] Jesse Shaffer commented on TEIID-3035: -------------------------------------- I do not know what Teiid uses to manage HTTP client connections, but the Apache HttpClient 4.5 library natively supports NTLM, NTLMv2, and NTLM2 Sessions authentication. Is is possible to just make use of that library for web service consumption? > Request to add NTLM Security to Web service datasources > ------------------------------------------------------- > > Key: TEIID-3035 > URL: https://issues.jboss.org/browse/TEIID-3035 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Reporter: Debbie Steigner > Assignee: Ramesh Reddy > > Currently the only Security types we support for Web Service data sources is None, HTTPBasic and WSSecurity can NTLM be added? -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4160) Impala - result set is not sorted if ORDER BY is defined in query

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-4160?page=com.atlassian.jira.plugin... ] Johnathon Lee updated TEIID-4160: --------------------------------- Fix Version/s: 8.7.6.6_2 > Impala - result set is not sorted if ORDER BY is defined in query > ----------------------------------------------------------------- > > Key: TEIID-4160 > URL: https://issues.jboss.org/browse/TEIID-4160 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Affects Versions: 8.12.x > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 9.0, 8.12.5, 8.7.6.6_2, 8.13.4 > > > Query: > {code:sql} > SELECT g_1.StringNum AS c_0 FROM Source.SmallA AS g_1 WHERE g_1.IntKey <= 50 UNION ALL SELECT g_0.StringNum AS c_0 FROM Source.SmallB AS g_0 WHERE g_0.IntKey > 50 ORDER BY c_0 > {code} > Result: as you can see, nulls are not next to each other > |StringNum| > |-24| > |<null>| > |-14| > |-13| > |-12| > |-11| > |-10| > |-9| > |-8| > |<null>| > |-6 > |-5| > |...| > Expected result: this is result of simple query SELECT stringnum FROM source.smalla ORDER BY 1 > |StringNum| > |-1| > |-10| > |-11| > |-12| > |-13| > |-14| > |-15| > |...| -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4148) Add "org.modeshape.jdbc" dependency to teiid jdbc translator module

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4148?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4148: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1315397|https://bugzilla.redhat.com/show_bug.cgi?id=1315397] from MODIFIED to ASSIGNED > Add "org.modeshape.jdbc" dependency to teiid jdbc translator module > ------------------------------------------------------------------- > > Key: TEIID-4148 > URL: https://issues.jboss.org/browse/TEIID-4148 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Affects Versions: 8.12.5 > Reporter: Van Halbert > Assignee: Van Halbert > Fix For: 9.0, 8.12.5 > > > the "org.jboss.teiid.translator.jdbc" module (where the query originates from) has to list "org.modeshape.jdbc" as a dependency so that ModeShape's CP can be accessible. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4152) Error: ASSERTION FAILED: expected reference to be not null

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4152?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4152: --------------------------------------- I haven't had as much to look at this as I would have hoped. Please let me know if this is reproducible for you on a later version. Also if possible please provide a vdb. > Error: ASSERTION FAILED: expected reference to be not null > ---------------------------------------------------------- > > Key: TEIID-4152 > URL: https://issues.jboss.org/browse/TEIID-4152 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.11.3 > Reporter: Bram Gadeyne > Assignee: Steven Hawkins > Attachments: queryplan.txt > > -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 11 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 April 2016