March 2016 - teiid-issues - Jboss List Archives

[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 updated TEIID-4063: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1316508 Bugzilla Update: Perform > 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 > > *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 month

1
0
0 / 0

[JBoss JIRA] (TEIID-4062) OData - $corssjoin 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 updated TEIID-4062: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1316504 Bugzilla Update: Perform > OData - $corssjoin 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 > > *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 month

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 updated TEIID-4061: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1316503 Bugzilla Update: Perform > 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 > > *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 month

1
0
0 / 0

[JBoss JIRA] (TEIID-4060) OData - $count after $expand does not work

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4060?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-4060: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1316502 Bugzilla Update: Perform > OData - $count after $expand does not work > ------------------------------------------ > > Key: TEIID-4060 > URL: https://issues.jboss.org/browse/TEIID-4060 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > > If user declares $count after $expand, OData service should return count if referenced entities instead of whole entities. > *URL:* http://localhost:8080/odata4/olingo_basic/Source/Customers/?$expand=Order... > *Result:* > {code:xml} > ... > <a:link rel="http://docs.oasis-open.org/odata/ns/related/Orders_FK0" title="Orders_FK0" href="http://localhost:8080/odata4/olingo_basic/Source/Customers(1)/Orders_FK0"> > <m:inline> > <a:feed> > <a:entry> > ... > {code} > *Expected result:* > {code:xml} > <a:link rel="http://docs.oasis-open.org/odata/ns/related/Orders_FK0" title="Orders_FK0" href="http://localhost:8080/odata4/olingo_basic/Source/Customers(1)/Orders_FK0"> >  > <m:count>4</m:count> > ... > {code} > 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 month

1
0
0 / 0

[JBoss JIRA] (TEIID-4059) OData - $ref after $expand does not work

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4059?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-4059: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1316501 Bugzilla Update: Perform > OData - $ref after $expand does not work > ---------------------------------------- > > Key: TEIID-4059 > URL: https://issues.jboss.org/browse/TEIID-4059 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > > If user declares $ref after $expand, OData service should return inline references to entities instead of whole entities. > *URL:* http://localhost:8080/odata4/olingo_basic/Source/Customers/?$expand=Order... > *Result:* > {code:xml} > ... > <a:link rel="http://docs.oasis-open.org/odata/ns/related/Orders_FK0" title="Orders_FK0" href="http://localhost:8080/odata4/olingo_basic/Source/Customers(1)/Orders_FK0"> > <m:inline> > <a:feed> > <a:entry> > ... > {code} > *Expected result:* > {code:xml} > <a:link rel="http://docs.oasis-open.org/odata/ns/related/Orders_FK0" title="Orders_FK0" href="http://localhost:8080/odata4/olingo_basic/Source/Customers(1)/Orders_FK0"> > <m:inline> > <a:feed> > <m:ref id="http://localhost:8080/odata4/olingo_basic/Source/Orders(1)"/> > ... > {code} > 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 month

1
0
0 / 0

[JBoss JIRA] (TEIID-4058) OData - Request entity which does not exist return 204 instead of 404

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4058?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-4058: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1316500 Bugzilla Update: Perform > OData - Request entity which does not exist return 204 instead of 404 > --------------------------------------------------------------------- > > Key: TEIID-4058 > URL: https://issues.jboss.org/browse/TEIID-4058 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > > If entity with requested ID does not exist, OData service should return 404 but Teiid returns 204. > *URL:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView(-2) > Moreover, if users define also property in the URL, Teiid returns 404, but body is neither in XML nor in JSON format (seems like generic EAP error page). > *URL:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView(-2)/intkey > 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 month

1
0
0 / 0

[JBoss JIRA] (TEIID-4057) OData - if PUT fails, next update request fails because table in DB is still locked

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4057?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-4057: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1316498 Bugzilla Update: Perform > OData - if PUT fails, next update request fails because table in DB is still locked > ----------------------------------------------------------------------------------- > > Key: TEIID-4057 > URL: https://issues.jboss.org/browse/TEIID-4057 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > > I can see (from the log) that processing of PUT request is as follows: > # select record from table > # delete record > # parse entity from HTTP request > # insert new record > But if e.g. step 3 fails, Teiid cancels transaction and returns error. In my opinion, parsing of the entity should be the first step (or at least right after select). > What happen here is, that DELETE statement creates transaction and locks the table. But the transaction is not canceled immediately after cancel request \[1\]. This causes that no other query can succeed, because of lock on the table (EAP uses connection pool and does not close connections immediately and therefore open connection has still one transaction in active state). > *Note:* We use H2 database for testing purpose. But I think that this could happen with any DB. Anyway, parsing of the entity should not be performed after delete. > \[1\] > {code:plain} > 09:35:33,937 DEBUG [org.teiid.TRANSPORT] (New I/O worker #1) Channel closed > 09:40:31,430 WARN [com.arjuna.ats.arjuna] (Transaction Reaper) ARJUNA012117: TransactionReaper::check timeout for TX 0:ffff7f000001:113c3cbe:56e131a7:e in state RUN > 09:40:31,438 WARN [com.arjuna.ats.arjuna] (Transaction Reaper Worker 0) ARJUNA012121: TransactionReaper::doCancellations worker Thread[Transaction Reaper Worker 0,5,main] successfully canceled TX 0:ffff7f000001:113c3cbe:56e131a7:e > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-4056) OData - PUT cannot parse entity

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4056?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-4056: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1316497 Bugzilla Update: Perform > OData - PUT cannot parse entity > ------------------------------- > > Key: TEIID-4056 > URL: https://issues.jboss.org/browse/TEIID-4056 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > > If user want to update entity using HTTP PUT method, OData service returns error that JSON document is not valid. Even if entity is in XML format. > *URL:* http://localhost:8080/odata4/olingo_basic/Source/PutTable(1) or http://localhost:8080/odata4/olingo_basic/Source/PutTable(2) > *Method:* PUT > *Request reader:* Content-type: application/json or Content-type: application/xml > *Error:* The syntax of the JSON document is not valid. > *Entity JSON:* > {code:plain} > {"intnum(a)odata.type":"Int32","intnum":5,"stringval(a)odata.type":"String","stringval":"5","timestampval(a)odata.type":"DateTimeOffset","timestampval":"2005-01-01T00:00:05Z","clobval(a)odata.type":"Binary","clobval":"Y2xvYl92YWx1ZV8wMDAwNQ=="} > {code} > *Entity XML:* > {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} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

1
0
0 / 0

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

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4055?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-4055: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1316494 Bugzilla Update: Perform > 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 month

1
0
0 / 0

[JBoss JIRA] (TEIID-4054) OData - creation of entity (POST) returns exception (status code 500)

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4054?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-4054: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1316490 Bugzilla Update: Perform > OData - creation of entity (POST) returns exception (status code 500) > --------------------------------------------------------------------- > > Key: TEIID-4054 > URL: https://issues.jboss.org/browse/TEIID-4054 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > > Creation of entity returns exception \[1\]. Representation of entity \[2\]. Http request \[3\]. Header \[4\]. Same exception with of JSON format. > \[1\] > {code:plain} > TEIID10076 Invalid conversion from type class java.lang.Object with value 'java.util.GregorianCalendar[time=4000,areFieldsSet=true,areAllFieldsSet=true,lenient=true,zone=sun.util.calendar.ZoneInfo[id="GMT",offset=0,dstSavings=0,useDaylight=false,transitions=0,lastRule=null],firstDayOfWeek=2,minimalDaysInFirstWeek=4,ERA=1,YEAR=1970,MONTH=0,WEEK_OF_YEAR=1,WEEK_OF_MONTH=1,DAY_OF_MONTH=1,DAY_OF_YEAR=1,DAY_OF_WEEK=5,DAY_OF_WEEK_IN_MONTH=1,AM_PM=0,HOUR=0,HOUR_OF_DAY=0,MINUTE=0,SECOND=4,MILLISECOND=0,ZONE_OFFSET=0,DST_OFFSET=0]' to type class java.sql.Time > {code} > \[2\] > {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:intkey m:type="Int32">4</d:intkey><d:intnum m:type="Int32">4</d:intnum><d:stringkey>4</d:stringkey><d:stringval>value_4</d:stringval><d:booleanval m:type="Boolean">false</d:booleanval><d:decimalval m:type="Double">-20.4</d:decimalval><d:timeval m:type="TimeOfDay">00:00:04</d:timeval><d:dateval m:type="Date">2004-04-04</d:dateval><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} > \[3\] > POST http://localhost:8080/odata4/olingo_basic/Source/PostTable(4) > \[4\] > Content-type: application/xml -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 1 month

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