April 2016 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-2822) REST CP - HTTP Digest security - "Test connection" doesn't work

by Ted Jones (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2822?page=com.atlassian.jira.plu... ] Ted Jones reassigned TEIIDDES-2822: ----------------------------------- Assignee: Ted Jones > REST CP - HTTP Digest security - "Test connection" doesn't work > --------------------------------------------------------------- > > Key: TEIIDDES-2822 > URL: https://issues.jboss.org/browse/TEIIDDES-2822 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 10.0 > Environment: MAC OS > Reporter: Matus Makovy > Assignee: Ted Jones > Fix For: 10.0 > > Attachments: Screen Shot 2016-04-12 at 15.03.15.png > > > When you try to define a connection profile to REST web service that is secured with HTTP Digest authentication and hit Test connection ping fails with http response code 401. > See screenshot -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2822) REST CP - HTTP Digest security - "Test connection" doesn't work

by Matus Makovy (JIRA)

Matus Makovy created TEIIDDES-2822: -------------------------------------- Summary: REST CP - HTTP Digest security - "Test connection" doesn't work Key: TEIIDDES-2822 URL: https://issues.jboss.org/browse/TEIIDDES-2822 Project: Teiid Designer Issue Type: Bug Affects Versions: 10.0 Environment: MAC OS Reporter: Matus Makovy Attachments: Screen Shot 2016-04-12 at 15.03.15.png When you try to define a connection profile to REST web service that is secured with HTTP Digest authentication and hit Test connection ping fails with http response code 401. See screenshot -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2571) Add HTTP Digest Authentication Support for REST Web Services as a Source

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2571?page=com.atlassian.jira.plu... ] Matus Makovy reopened TEIIDDES-2571: ------------------------------------ I am working on test script for this. I can go through the whole wizard and create Source and View models. Then I create a VDB and deploy it on server. After I submit a query there is an error in server log: +No enum constant org.teiid.resource.adapter.ws.WSManagedConnectionFactory.SecurityType.HTTPDigest+ In the standalone.xml I found this definition of resource adapter: {code:xml} <resource-adapter id="RestDigestSource_DS"> <module slot="main" id="org.jboss.teiid.resource-adapter.webservice"/> <transaction-support>NoTransaction</transaction-support> <connection-definitions> <connection-definition class-name="org.teiid.resource.adapter.ws.WSManagedConnectionFactory" jndi-name="java:/RestDigestSource_DS" enabled="true" pool-name="RestDigestSource_DS"> <config-property name="AuthPassword"> digest </config-property> <config-property name="EndPoint"> http://ws-dvirt.rhcloud.com/dv-test-ws-digest/rest/xml </config-property> <config-property name="SecurityType"> HTTPDigest </config-property> <config-property name="AuthUserName"> digest </config-property> </connection-definition> </connection-definitions> </resource-adapter> {code} It looks like TD defines the resource adapter with wrong property. There is property named SecurityType with value *HTTPDigest*, after I change this to *Digest* it works without problems. (I found the correct property value here: http://docs.jboss.org/teiid/8.12.0.Final/apidocs/org/teiid/resource/adapt...) TD 10.0.0.Beta4 JDV 6.3.ER1 > Add HTTP Digest Authentication Support for REST Web Services as a Source > ------------------------------------------------------------------------ > > Key: TEIIDDES-2571 > URL: https://issues.jboss.org/browse/TEIIDDES-2571 > Project: Teiid Designer > Issue Type: Feature Request > Components: Import/Export, Patch Release, Web Services Support > Affects Versions: 9.0.3, 9.2.1 > Reporter: Ted Jones > Assignee: Ted Jones > Priority: Blocker > Fix For: 10.0.1 > > > Need to support importing REST web services that use HTTP Digest authentication -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2481) Add support for recursive common table expressions

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2481?page=com.atlassian.jira.plu... ] Matus Makovy reopened TEIIDDES-2481: ------------------------------------ I'll reopen this to indicate that it can not be tested right now and a fix is needed. > Add support for recursive common table expressions > -------------------------------------------------- > > Key: TEIIDDES-2481 > URL: https://issues.jboss.org/browse/TEIIDDES-2481 > Project: Teiid Designer > Issue Type: Feature Request > Components: Modeling, Patch Release, Teiid Integration > Reporter: Steven Hawkins > Assignee: Paul Richardson > Fix For: 10.0.1, 9.2.1 > > Attachments: RCTE1-vdb.xml > > > Teiid 8.10 added support for recursive common table expressions. There is no new syntax, but more logic around resolving a special form of a common table expression. If the query expression is written as a union then the right hand side of the union is allowed to reference the common table group. See https://docs.jboss.org/author/display/TEIID/WITH+Clause -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2481) Add support for recursive common table expressions

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2481?page=com.atlassian.jira.plu... ] Steven Hawkins commented on TEIIDDES-2481: ------------------------------------------ > Since t is not an external table/view, shouldn't that internal "metadata" be taken into account during process? I'm not sure what you as asking. A recursive common table look like with x as ( foo union [all] bar ) such that bar can reference the common table x. > Add support for recursive common table expressions > -------------------------------------------------- > > Key: TEIIDDES-2481 > URL: https://issues.jboss.org/browse/TEIIDDES-2481 > Project: Teiid Designer > Issue Type: Feature Request > Components: Modeling, Patch Release, Teiid Integration > Reporter: Steven Hawkins > Assignee: Paul Richardson > Fix For: 10.0.1, 9.2.1 > > Attachments: RCTE1-vdb.xml > > > Teiid 8.10 added support for recursive common table expressions. There is no new syntax, but more logic around resolving a special form of a common table expression. If the query expression is written as a union then the right hand side of the union is allowed to reference the common table group. See https://docs.jboss.org/author/display/TEIID/WITH+Clause -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2481) Add support for recursive common table expressions

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2481?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2481: ---------------------------------------- [~shawkins] I looked at that test class and followed the methods into TeiidProcessor but I don't see where any query resolving is happening (i.e. valid groups/symbols). The error we're getting is around the "internal" group name (Emp_CTE above). Matus verified that a Dynamic VDB deploys OK with this type of SQL, so I'm assuming the example we're using is valid? I'm having the same issue with one of your tests : TestWithClauseProcessing.testRecursive() {code} WITH t(n) AS ( VALUES (1) UNION ALL SELECT n+1 FROM t WHERE n < 64 ) SELECT sum(n) FROM t {code} ERROR : *Group does not exist: t* Since *t* is not an external table/view, shouldn't that internal "metadata" be taken into account during process? > Add support for recursive common table expressions > -------------------------------------------------- > > Key: TEIIDDES-2481 > URL: https://issues.jboss.org/browse/TEIIDDES-2481 > Project: Teiid Designer > Issue Type: Feature Request > Components: Modeling, Patch Release, Teiid Integration > Reporter: Steven Hawkins > Assignee: Paul Richardson > Fix For: 10.0.1, 9.2.1 > > Attachments: RCTE1-vdb.xml > > > Teiid 8.10 added support for recursive common table expressions. There is no new syntax, but more logic around resolving a special form of a common table expression. If the query expression is written as a union then the right hand side of the union is allowed to reference the common table group. See https://docs.jboss.org/author/display/TEIID/WITH+Clause -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2481) Add support for recursive common table expressions

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2481?page=com.atlassian.jira.plu... ] Steven Hawkins edited comment on TEIIDDES-2481 at 4/11/16 2:15 PM: ------------------------------------------------------------------- There are several in TestWithClauseProcessing was (Author: shawkins): There are several in TestWithClausProcessing > Add support for recursive common table expressions > -------------------------------------------------- > > Key: TEIIDDES-2481 > URL: https://issues.jboss.org/browse/TEIIDDES-2481 > Project: Teiid Designer > Issue Type: Feature Request > Components: Modeling, Patch Release, Teiid Integration > Reporter: Steven Hawkins > Assignee: Paul Richardson > Fix For: 10.0.1, 9.2.1 > > Attachments: RCTE1-vdb.xml > > > Teiid 8.10 added support for recursive common table expressions. There is no new syntax, but more logic around resolving a special form of a common table expression. If the query expression is written as a union then the right hand side of the union is allowed to reference the common table group. See https://docs.jboss.org/author/display/TEIID/WITH+Clause -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2481) Add support for recursive common table expressions

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2481?page=com.atlassian.jira.plu... ] Steven Hawkins commented on TEIIDDES-2481: ------------------------------------------ There are several in TestWithClausProcessing > Add support for recursive common table expressions > -------------------------------------------------- > > Key: TEIIDDES-2481 > URL: https://issues.jboss.org/browse/TEIIDDES-2481 > Project: Teiid Designer > Issue Type: Feature Request > Components: Modeling, Patch Release, Teiid Integration > Reporter: Steven Hawkins > Assignee: Paul Richardson > Fix For: 10.0.1, 9.2.1 > > Attachments: RCTE1-vdb.xml > > > Teiid 8.10 added support for recursive common table expressions. There is no new syntax, but more logic around resolving a special form of a common table expression. If the query expression is written as a union then the right hand side of the union is allowed to reference the common table group. See https://docs.jboss.org/author/display/TEIID/WITH+Clause -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2481) Add support for recursive common table expressions

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2481?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2481: ---------------------------------------- [~shawkins] I can't find a Teiid client test case that covers this WITH clause. Is there a unit test for this? > Add support for recursive common table expressions > -------------------------------------------------- > > Key: TEIIDDES-2481 > URL: https://issues.jboss.org/browse/TEIIDDES-2481 > Project: Teiid Designer > Issue Type: Feature Request > Components: Modeling, Patch Release, Teiid Integration > Reporter: Steven Hawkins > Assignee: Paul Richardson > Fix For: 10.0.1, 9.2.1 > > Attachments: RCTE1-vdb.xml > > > Teiid 8.10 added support for recursive common table expressions. There is no new syntax, but more logic around resolving a special form of a common table expression. If the query expression is written as a union then the right hand side of the union is allowed to reference the common table group. See https://docs.jboss.org/author/display/TEIID/WITH+Clause -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2481) Add support for recursive common table expressions

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2481?page=com.atlassian.jira.plu... ] Matus Makovy updated TEIIDDES-2481: ----------------------------------- Attachment: RCTE1-vdb.xml > Add support for recursive common table expressions > -------------------------------------------------- > > Key: TEIIDDES-2481 > URL: https://issues.jboss.org/browse/TEIIDDES-2481 > Project: Teiid Designer > Issue Type: Feature Request > Components: Modeling, Patch Release, Teiid Integration > Reporter: Steven Hawkins > Assignee: Paul Richardson > Fix For: 10.0.1, 9.2.1 > > Attachments: RCTE1-vdb.xml > > > Teiid 8.10 added support for recursive common table expressions. There is no new syntax, but more logic around resolving a special form of a common table expression. If the query expression is written as a union then the right hand side of the union is allowed to reference the common table group. See https://docs.jboss.org/author/display/TEIID/WITH+Clause -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 9 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues April 2016