March 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4062) OData - $crossjoin fails due to missing class

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4062?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4062: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1316504|https://bugzilla.redhat.com/show_bug.cgi?id=1316504] from NEW to MODIFIED > OData - $crossjoin fails due to missing class > --------------------------------------------- > > Key: TEIID-4062 > URL: https://issues.jboss.org/browse/TEIID-4062 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > Fix For: 9.0, 8.12.5 > > > *URL:* http://localhost:8080/odata4/olingo_basic/Source/$crossjoin(PutTable,Dele... > *Missing dependency:* com.fasterxml.jackson > *Error:* > {code:plain} > 11:04:51,047 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/odata4].[odata4]] (http-/127.0.0.1:8080-2) JBWEB000236: Servlet.service() for servlet odata4 threw exception: java.lang.ClassNotFoundException: com.fasterxml.jackson.core.JsonFactory from [Module "org.jboss.teiid.olingo:main" from local module loader @7c53a9eb (finder: local module finder @ed17bee (roots: /home/jdurani/redhat/tests/functional_testing/workdir_olingo/modules,/home/jdurani/redhat/tests/functional_testing/workdir_olingo/modules/system/layers/dv,/home/jdurani/redhat/tests/functional_testing/workdir_olingo/modules/system/layers/base))] > at org.jboss.modules.ModuleClassLoader.findClass(ModuleClassLoader.java:213) [jboss-modules.jar:1.3.7.Final-redhat-1] > at org.jboss.modules.ConcurrentClassLoader.performLoadClassUnchecked(ConcurrentClassLoader.java:459) [jboss-modules.jar:1.3.7.Final-redhat-1] > at org.jboss.modules.ConcurrentClassLoader.performLoadClassChecked(ConcurrentClassLoader.java:408) [jboss-modules.jar:1.3.7.Final-redhat-1] > at org.jboss.modules.ConcurrentClassLoader.performLoadClass(ConcurrentClassLoader.java:389) [jboss-modules.jar:1.3.7.Final-redhat-1] > at org.jboss.modules.ConcurrentClassLoader.loadClass(ConcurrentClassLoader.java:134) [jboss-modules.jar:1.3.7.Final-redhat-1] > at org.teiid.olingo.TeiidODataJsonSerializer.complexCollection(TeiidODataJsonSerializer.java:53) [teiid-olingo-8.12.5.redhat-2.jar:8.12.5.redhat-2] > at org.teiid.olingo.EdmComplexResponse.writeComplexType(EdmComplexResponse.java:73) [teiid-olingo-8.12.5.redhat-2.jar:8.12.5.redhat-2] > at org.teiid.olingo.service.TeiidServiceHandler.sendResults(TeiidServiceHandler.java:317) [teiid-olingo-8.12.5.redhat-2.jar:8.12.5.redhat-2] > at org.teiid.olingo.service.TeiidServiceHandler.crossJoin(TeiidServiceHandler.java:834) [teiid-olingo-8.12.5.redhat-2.jar:8.12.5.redhat-2] > at org.apache.olingo.server.core.requests.DataRequest$CrossJoinRequest.execute(DataRequest.java:692) > at org.apache.olingo.server.core.requests.DataRequest.execute(DataRequest.java:245) > at org.apache.olingo.server.core.ServiceDispatcher.execute(ServiceDispatcher.java:117) > at org.apache.olingo.server.core.OData4HttpHandler.process(OData4HttpHandler.java:65) > at org.teiid.olingo.web.ODataServlet.service(ODataServlet.java:50) [teiid-olingo-8.12.5.redhat-2.jar:8.12.5.redhat-2] > at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.2.Final-redhat-2.jar:1.0.2.Final-redhat-2] > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] > at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] > at org.teiid.olingo.web.ODataFilter.doFilter(ODataFilter.java:194) [teiid-olingo-8.12.5.redhat-2.jar:8.12.5.redhat-2] > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] > at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] > at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:231) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] > at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] > at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:512) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] > at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169) [jboss-as-web-7.5.4.Final-redhat-4.jar:7.5.4.Final-redhat-4] > at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:150) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] > at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] > at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] > at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] > at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:854) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] > at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:653) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] > at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:926) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] > at java.lang.Thread.run(Thread.java:744) [rt.jar:1.8.0-internal] > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4061) OData - request is not traslated to valid SQL

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4061?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4061: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1316503|https://bugzilla.redhat.com/show_bug.cgi?id=1316503] from NEW to MODIFIED > OData - request is not traslated to valid SQL > --------------------------------------------- > > Key: TEIID-4061 > URL: https://issues.jboss.org/browse/TEIID-4061 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > Fix For: 9.0, 8.12.5 > > > *URL:* http://localhost:8080/odata4/olingo_basic/Source/Customers/?$filter=Order... > *Result:* TEIID31118 Element "g30.customerid" is not defined by any relevant group. > *SQL:* > {code:sql} > SELECT g30.idcust, g30.name FROM Source.Customers AS g30 WHERE (SELECT COUNT(*) FROM Source.Orders AS g31 WHERE g30.customerid = g31.idcust) < ? ORDER BY g30.idcust > {code} > *Correct SQL:* > {code:sql} > SELECT g30.idcust, g30.name FROM Source.Customers AS g30 WHERE (SELECT COUNT(*) FROM Source.Orders AS g31 WHERE g30.idcust = g31.customerid) < ? ORDER BY g30.idcust > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4063) OData - $all returns 500 without message (generic error page of EAP)

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4063?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4063: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1316508|https://bugzilla.redhat.com/show_bug.cgi?id=1316508] from NEW to MODIFIED > OData - $all returns 500 without message (generic error page of EAP) > -------------------------------------------------------------------- > > Key: TEIID-4063 > URL: https://issues.jboss.org/browse/TEIID-4063 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > Fix For: 9.0, 8.12.5 > > > *URL:* http://localhost:8080/odata4/olingo_basic/Source/$all > *Result:* OData returns status code 500 without message. There is no error in the console log of Teiid server. > *Expected result:* if $all is not implemented then OData should return 501 otherwise correct result should be returned. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4047) OData - $top with negative value return status code 500

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4047?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4047: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1316484|https://bugzilla.redhat.com/show_bug.cgi?id=1316484] from NEW to MODIFIED > OData - $top with negative value return status code 500 > ------------------------------------------------------- > > Key: TEIID-4047 > URL: https://issues.jboss.org/browse/TEIID-4047 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > Fix For: 9.0, 8.12.5 > > > OData request with query option $top with negative value returns status code 500. The root cause is SQLException. OData service should check passed value and return e.g. 400 instead. > *URL:* http://localhost:8080/odata4/olingo_basic/Source/Customers/?$top=-1 > See http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/part1-pr... -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4041) OData response does not contain header "allow"

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4041?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4041: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1316472|https://bugzilla.redhat.com/show_bug.cgi?id=1316472] from NEW to MODIFIED > OData response does not contain header "allow" > ---------------------------------------------- > > Key: TEIID-4041 > URL: https://issues.jboss.org/browse/TEIID-4041 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > > If user sends request to URL with unsupported HTTP method, OData service should return allowed methods in header _allow_. > *URL:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/ > *Method:* DELETE > *Response headers:* date=Wed, 09 Mar 2016 08:21:17 GMT, server=Apache-Coyote/1.1, content-length=192, expires=Thu, 01 Jan 1970 00:00:00 GMT+00:00, content-type=application/xml, cache-control=no-cache, pragma=No-cache, odata-version=4.0 > See http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/part1-pr... -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years

1
0
0 / 0

[JBoss JIRA] (TEIID-3906) OData v4 - definition of OData-Isolation header is either being ignored or is not implemented correctly

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3906?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3906: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1298916|https://bugzilla.redhat.com/show_bug.cgi?id=1298916] from NEW to MODIFIED > OData v4 - definition of OData-Isolation header is either being ignored or is not implemented correctly > ------------------------------------------------------------------------------------------------------- > > Key: TEIID-3906 > URL: https://issues.jboss.org/browse/TEIID-3906 > Project: Teiid > Issue Type: Sub-task > Components: OData > Affects Versions: 8.12.3 > Environment: Teiid - OData v4 > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > Fix For: 9.0, 8.12.5 > > > Teiid does not process header *OData-Isolation: snapshot* defined in request correctly. > * if service (Teiid) does not support this option it must return error 412 > * if Teiid does supports this option then it is not processed correctly, because modifications made during request are visbile > See http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/part1-pr... -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4055) OData - updating of raw value fails (PUT method to URL with path $value)

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4055?page=com.atlassian.jira.plugin... ] Work on TEIID-4055 started by Ramesh Reddy. ------------------------------------------- > OData - updating of raw value fails (PUT method to URL with path $value) > ------------------------------------------------------------------------ > > Key: TEIID-4055 > URL: https://issues.jboss.org/browse/TEIID-4055 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > > *URL:* http://localhost:8080/odata4/olingo_basic/Source/PutPropTable(1)/name/$value > *Method:* PUT > *Header:* Content-type: text/plain > *Body of request:* it is build like this: > {code:java} > new ByteArrayInputStream("6".getBytes()) > {code} > *Response:* The content-type range 'application/xml' is not supported as value of the Accept header. > *Status code:* 406 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4055) OData - updating of raw value fails (PUT method to URL with path $value)

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4055?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-4055: ------------------------------------- Reference in --> 11.4.9.1 Update a Primitive Property http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/part1-pr... this requires upstream change https://issues.apache.org/jira/browse/OLINGO-911 > OData - updating of raw value fails (PUT method to URL with path $value) > ------------------------------------------------------------------------ > > Key: TEIID-4055 > URL: https://issues.jboss.org/browse/TEIID-4055 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > > *URL:* http://localhost:8080/odata4/olingo_basic/Source/PutPropTable(1)/name/$value > *Method:* PUT > *Header:* Content-type: text/plain > *Body of request:* it is build like this: > {code:java} > new ByteArrayInputStream("6".getBytes()) > {code} > *Response:* The content-type range 'application/xml' is not supported as value of the Accept header. > *Status code:* 406 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4048) OData - update of clob value using HTTP method PATCH does not set correct value of the column

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4048?page=com.atlassian.jira.plugin... ] Ramesh Reddy edited comment on TEIID-4048 at 3/17/16 4:56 PM: -------------------------------------------------------------- PATCH verb is not allowed on Edm.Stream properties. You should have received 405 Method not allowed. All you can use is GET and PUT. BTW you did not get 405 because your issued the query at entity level, that is a merge of entity. Also above you test is wrong, you can NOT update the Edm.Stream properties in an entity payload. They need to be done directly at the property level. Look in TEIID-4054 comments for more information on how Edm.Stream properties need to be handled. was (Author: rareddy): PATCH verb is not allowed on Edm.Stream properties. You should have received 405 Method not allowed. All you can use is GET and PUT Also above you test is wrong, you can NOT update the Edm.Stream properties in an entity payload. They need to be done directly at the property level. Look in TEIID-4054 comments for more information on how Edm.Stream properties need to be handled. > OData - update of clob value using HTTP method PATCH does not set correct value of the column > --------------------------------------------------------------------------------------------- > > Key: TEIID-4048 > URL: https://issues.jboss.org/browse/TEIID-4048 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > > This affects both XML and JSON format. > *URL:* http://localhost:8080/odata4/olingo_basic/Source/PatchTable(2) > *Entity:* > {code:xml} > <?xml version='1.0' encoding='UTF-8'?> > <entry xmlns="http://www.w3.org/2005/Atom" xmlns:xml="http://www.w3.org/XML/1998/namespace" > xmlns:m="http://docs.oasis-open.org/odata/ns/metadata" xmlns:d="http://docs.oasis-open.org/odata/ns/data" > xmlns:gml="http://www.opengis.net/gml" xmlns:georss="http://www.georss.org/georss"> > <category scheme="http://docs.oasis-open.org/odata/ns/scheme" /> > <content type="application/xml"> > <m:properties> > <d:intnum m:type="Int32">4</d:intnum> > <d:stringval>4</d:stringval> > <d:timestampval m:type="DateTimeOffset">2004-01-01T00:00:04Z</d:timestampval> > <d:clobval m:type="Binary">Y2xvYl92YWx1ZV8wMDAwNA==</d:clobval> > </m:properties> > </content> > </entry> > {code} > *Result of GET:* > {code:xml} > <d:clobval m:type="Binary">NjM2YzZmNjI1Zjc2NjE2Yzc1NjU1ZjMwMzAzMDMwMzU=</d:clobval> > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years

1
0
0 / 0

[JBoss JIRA] (TEIID-4048) OData - update of clob value using HTTP method PATCH does not set correct value of the column

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4048?page=com.atlassian.jira.plugin... ] Ramesh Reddy resolved TEIID-4048. --------------------------------- Resolution: Rejected PATCH verb is not allowed on Edm.Stream properties. You should have received 405 Method not allowed. All you can use is GET and PUT Also above you test is wrong, you can NOT update the Edm.Stream properties in an entity payload. They need to be done directly at the property level. Look in TEIID-4054 comments for more information on how Edm.Stream properties need to be handled. > OData - update of clob value using HTTP method PATCH does not set correct value of the column > --------------------------------------------------------------------------------------------- > > Key: TEIID-4048 > URL: https://issues.jboss.org/browse/TEIID-4048 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > > This affects both XML and JSON format. > *URL:* http://localhost:8080/odata4/olingo_basic/Source/PatchTable(2) > *Entity:* > {code:xml} > <?xml version='1.0' encoding='UTF-8'?> > <entry xmlns="http://www.w3.org/2005/Atom" xmlns:xml="http://www.w3.org/XML/1998/namespace" > xmlns:m="http://docs.oasis-open.org/odata/ns/metadata" xmlns:d="http://docs.oasis-open.org/odata/ns/data" > xmlns:gml="http://www.opengis.net/gml" xmlns:georss="http://www.georss.org/georss"> > <category scheme="http://docs.oasis-open.org/odata/ns/scheme" /> > <content type="application/xml"> > <m:properties> > <d:intnum m:type="Int32">4</d:intnum> > <d:stringval>4</d:stringval> > <d:timestampval m:type="DateTimeOffset">2004-01-01T00:00:04Z</d:timestampval> > <d:clobval m:type="Binary">Y2xvYl92YWx1ZV8wMDAwNA==</d:clobval> > </m:properties> > </content> > </entry> > {code} > *Result of GET:* > {code:xml} > <d:clobval m:type="Binary">NjM2YzZmNjI1Zjc2NjE2Yzc1NjU1ZjMwMzAzMDMwMzU=</d:clobval> > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues March 2016