April 2017 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4867) Loosen up OData4 URL validation or parsing

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4867?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-4867: ------------------------------------- [~dsteigne] Yes, it will take some work, I will have something soon. > Loosen up OData4 URL validation or parsing > ------------------------------------------ > > Key: TEIID-4867 > URL: https://issues.jboss.org/browse/TEIID-4867 > Project: Teiid > Issue Type: Bug > Components: OData > Affects Versions: 8.12.8.6_3 > Environment: JDV 6.3.2 > Windows 7 > Reporter: Steve Tran > Assignee: Steven Hawkins > > I'm accessing my JDV table via OData4 through Salesforce's UI builder. The salesforce engine itself is creating the OData calls, and whenever a $filter is needed with multiple columns, it looks like salesforce pads the column name with a space in front and behind. That'll make the URL look like ...$filter={color:red}%20{color}ColumnA{color:red}%20{color}eq%20123%20and{color:red}%20{color}ColumnB{color:red}%20{color}eq... > The first space right after the $filter= throws off the JDV engine as it thinks it's a malformed URL - which I guess it is. The thing is when I tested it via the OData2 interface, it accepted it just fine. I'm not sure if the OData4 specifications explicitly state in terms of the URL, so it could be anybody's bug. Perhaps we could make JDV a little more forgiving and trim the spaces after un-URL-encoding the URI. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4867) Loosen up OData4 URL validation or parsing

by Debbie Steigner (JIRA)

[ https://issues.jboss.org/browse/TEIID-4867?page=com.atlassian.jira.plugin... ] Debbie Steigner commented on TEIID-4867: ---------------------------------------- [~rareddy] Customer is requesting that we do something to lax the URL, is there anything we can do without Olingo changing? > Loosen up OData4 URL validation or parsing > ------------------------------------------ > > Key: TEIID-4867 > URL: https://issues.jboss.org/browse/TEIID-4867 > Project: Teiid > Issue Type: Bug > Components: OData > Affects Versions: 8.12.8.6_3 > Environment: JDV 6.3.2 > Windows 7 > Reporter: Steve Tran > Assignee: Steven Hawkins > > I'm accessing my JDV table via OData4 through Salesforce's UI builder. The salesforce engine itself is creating the OData calls, and whenever a $filter is needed with multiple columns, it looks like salesforce pads the column name with a space in front and behind. That'll make the URL look like ...$filter={color:red}%20{color}ColumnA{color:red}%20{color}eq%20123%20and{color:red}%20{color}ColumnB{color:red}%20{color}eq... > The first space right after the $filter= throws off the JDV engine as it thinks it's a malformed URL - which I guess it is. The thing is when I tested it via the OData2 interface, it accepted it just fine. I'm not sure if the OData4 specifications explicitly state in terms of the URL, so it could be anybody's bug. Perhaps we could make JDV a little more forgiving and trim the spaces after un-URL-encoding the URI. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4434) Results returned by google spreadhseet may have columns missing labels, preventing the VDB to load

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4434?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4434. ----------------------------------- Resolution: Done > Results returned by google spreadhseet may have columns missing labels, preventing the VDB to load > -------------------------------------------------------------------------------------------------- > > Key: TEIID-4434 > URL: https://issues.jboss.org/browse/TEIID-4434 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 9.0.2 > Reporter: Marco Ardito > Assignee: Steven Hawkins > Fix For: 8.12.x-6.4, 9.0.4, 9.1 > > > see forum reference (extended descriptions, screenshots...) -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4824) Add unique id as a configuration property in the Google Resource adapter

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4824?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4824. ----------------------------------- Resolution: Done pulled back to 6.4 as well. Also added TEIID-4434 > Add unique id as a configuration property in the Google Resource adapter > ------------------------------------------------------------------------ > > Key: TEIID-4824 > URL: https://issues.jboss.org/browse/TEIID-4824 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Affects Versions: 8.12.8.6_3 > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Fix For: 9.3, 8.12.x-6.4 > > > Currently, only the google spreadsheet name can be used in the Google Resource adapter instead of the unique id of the document. If there is more than one document with same name in multiple folders the wrong file may be picked up by the resource adapter. Is it possible to use unique document ID instead of spreadsheet name for google data source -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4434) Results returned by google spreadhseet may have columns missing labels, preventing the VDB to load

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4434?page=com.atlassian.jira.plugin... ] Steven Hawkins reopened TEIID-4434: ----------------------------------- > Results returned by google spreadhseet may have columns missing labels, preventing the VDB to load > -------------------------------------------------------------------------------------------------- > > Key: TEIID-4434 > URL: https://issues.jboss.org/browse/TEIID-4434 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 9.0.2 > Reporter: Marco Ardito > Assignee: Steven Hawkins > Fix For: 9.1, 9.0.4, 8.12.x-6.4 > > > see forum reference (extended descriptions, screenshots...) -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4434) Results returned by google spreadhseet may have columns missing labels, preventing the VDB to load

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4434?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4434: ---------------------------------- Fix Version/s: 8.12.x-6.4 > Results returned by google spreadhseet may have columns missing labels, preventing the VDB to load > -------------------------------------------------------------------------------------------------- > > Key: TEIID-4434 > URL: https://issues.jboss.org/browse/TEIID-4434 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 9.0.2 > Reporter: Marco Ardito > Assignee: Steven Hawkins > Fix For: 9.1, 9.0.4, 8.12.x-6.4 > > > see forum reference (extended descriptions, screenshots...) -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4874) SQL Server translator should support full outer join by default

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4874?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-4874: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1444914 Bugzilla Update: Perform > SQL Server translator should support full outer join by default > --------------------------------------------------------------- > > Key: TEIID-4874 > URL: https://issues.jboss.org/browse/TEIID-4874 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.3, 9.2.3 > > > Due to inheriting from the sybase translator, the sqlserver translator by default does not support full outer join. This should changed to true. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4859) OData throws org.apache.olingo.commons.api.edm.EdmPrimitiveTypeException when primary key is bigdecimal

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4859?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-4859: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1442239, https://bugzilla.redhat.com/show_bug.cgi?id=1445044 Bugzilla Update: Perform > OData throws org.apache.olingo.commons.api.edm.EdmPrimitiveTypeException when primary key is bigdecimal > ------------------------------------------------------------------------------------------------------- > > Key: TEIID-4859 > URL: https://issues.jboss.org/browse/TEIID-4859 > Project: Teiid > Issue Type: Bug > Components: OData > Environment: VDB accessed through OData4 where the primary key is of bigdecimal type. > Reporter: Marc Shirley > Assignee: Ramesh Reddy > > Attempting to access the VDB through OData4 (http://server:8080/odata4/odataFacetError/odataFacetError/fauxdata) results in an error like: > org.apache.olingo.commons.api.edm.EdmPrimitiveTypeException: The value '1.1' does not match the facets' constraints. > Accessing through odata 2 (http://server:8080/odata/odataFacetError/odataFacetError.fauxdata) works correctly. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4874) SQL Server translator should support full outer join by default

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4874?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4874. ----------------------------------- Resolution: Done Changed the default. > SQL Server translator should support full outer join by default > --------------------------------------------------------------- > > Key: TEIID-4874 > URL: https://issues.jboss.org/browse/TEIID-4874 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.3, 9.2.3 > > > Due to inheriting from the sybase translator, the sqlserver translator by default does not support full outer join. This should changed to true. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4824) Add unique id as a configuration property in the Google Resource adapter

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4824?page=com.atlassian.jira.plugin... ] Work on TEIID-4824 started by Steven Hawkins. --------------------------------------------- > Add unique id as a configuration property in the Google Resource adapter > ------------------------------------------------------------------------ > > Key: TEIID-4824 > URL: https://issues.jboss.org/browse/TEIID-4824 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Affects Versions: 8.12.8.6_3 > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Fix For: 9.3, 8.12.x-6.4 > > > Currently, only the google spreadsheet name can be used in the Google Resource adapter instead of the unique id of the document. If there is more than one document with same name in multiple folders the wrong file may be picked up by the resource adapter. Is it possible to use unique document ID instead of spreadsheet name for google data source -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 8 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues April 2017