June 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3686) OData DELETE nonexisting row - wrong response code

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3686?page=com.atlassian.jira.plugin... ] Van Halbert reopened TEIID-3686: -------------------------------- Setting this to ASSIGNED. - OData V2 still returns 200 (OK) for first and second delete call. - OData v4 returns 204 (No Content) for first call and 304 (Not Modified) for second call. -- The question is, whether this is good or not. Requirements from the description says, that response should be 404 [1]. It may seem that 304 is right, but user specifies URL of the resource which does not exist, and therefore OData service should return 404 (Not found) [1]. My conclusion: - BZ is not fixed in OData V2 at all. - BZ is fixed in OData V4 only partially. [1] However, reporter did not provide any relevant document/specification which supports this assumption. [2] This is relevant to any HTTP method, not only GET. http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/part1-pr... > OData DELETE nonexisting row - wrong response code > -------------------------------------------------- > > Key: TEIID-3686 > URL: https://issues.jboss.org/browse/TEIID-3686 > Project: Teiid > Issue Type: Bug > Components: OData > Affects Versions: 8.7.1.6_2 > Reporter: Michal Sanitrak > Assignee: Ramesh Reddy > Labels: CR1 > Fix For: 8.12, 8.7.2.6_2 > > > I deployed VDB that can be accessed with OData. When I perform DELETE request to remove row for first time response code is 200 OK (maybe it should be 204) but when I repeat the same DELETE request and tried to delete already deleted entry, response is again 200 OK, but it should be 404 Not Found. Same thing happens even I when tried to delete entry with id that doesn't exist at all. > Only indication of this problem is in the server log: > {code:plain}INFO [org.teiid.ODATA] (http-/127.0.0.1:8080-1) no entity to delete in = BooksMySQL.BOOKS with key= ('1') > {code} > I think that response code for deleting row that doesn't exist should be different than 200 OK. > For example the service at odata.org returns following content with response code 404 Not Found: > {code:xml} > <?xml version="1.0" encoding="utf-8" standalone="yes"?> > <error xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata"> > <code></code> > <message xml:lang="en-US">Resource not found for the segment 'Products'.</message> > </error> > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3617) Provide an option to Limit per user based connections

by Kylin Soong (JIRA)

[ https://issues.jboss.org/browse/TEIID-3617?page=com.atlassian.jira.plugin... ] Kylin Soong commented on TEIID-3617: ------------------------------------ I have done a updates(https://github.com/teiid/teiid/pull/726), add 3 cli to do this: {code} /subsystem=teiid/transport=jdbc:add-max-session-per-user(username=teiidUser,max-sessions=25) /subsystem=teiid/transport=jdbc:remove-max-session-per-user(username=teiidUser) /subsystem=teiid/transport=jdbc:max-session-per-user() {code} If use embedded, use EmbeddedConfiguration as below {code} EmbeddedConfiguration config = new EmbeddedConfiguration(); config.addMaxSessionPerUser("anonymous", 3); embeddedserver.start(config); {code} Any comments, suggests feel free let me know. > Provide an option to Limit per user based connections > ----------------------------------------------------- > > Key: TEIID-3617 > URL: https://issues.jboss.org/browse/TEIID-3617 > Project: Teiid > Issue Type: Feature Request > Components: Server > Reporter: Xian Liu > Assignee: Kylin Soong > Fix For: 9.1 > > > we deploy teiid for users to get data, but some users will create many connections to teiid and they are not necessary, I need to find a good way to limit each user account can only get like 50 connections or so -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4125) Problem with SOAP war generated in TD

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4125?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4125: ------------------------------------------------ Juraj Duráni <jdurani(a)redhat.com> changed the Status of [bug 1311608|https://bugzilla.redhat.com/show_bug.cgi?id=1311608] from ON_QA to VERIFIED > Problem with SOAP war generated in TD > ------------------------------------- > > Key: TEIID-4125 > URL: https://issues.jboss.org/browse/TEIID-4125 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.12.5 > Reporter: Matus Makovy > Assignee: Van Halbert > Priority: Critical > Fix For: 9.0, 8.12.5 > > Attachments: ProductInfoVdb.war, Untitled.zip > > > I don't know if this is a Teiid or Teiid Designer issue. > When I generate a SOAP war from VDB and try to deploy it to server, I get following exception: > {code} > Deployment failed: ProductInfoVdb.war: {"outcome" : "failed", "failure-description" : {"JBAS014671: Failed services" : {"jboss.deployment.unit.\"ProductInfoVdb.war\".INSTALL" : "org.jboss.msc.service.StartException in service jboss.deployment.unit.\"ProductInfoVdb.war\".INSTALL: JBAS018733: Failed to process phase INSTALL of deployment \"ProductInfoVdb.war\"\n Caused by: java.lang.NoClassDefFoundError: org/apache/commons/logging/LogFactory\n Caused by: java.lang.ClassNotFoundException: org.apache.commons.logging.LogFactory from [Module \"org.springframework.spring:main\" from local module loader @ed17bee (finder: local module finder @2a33fae0 (roots: /Users/mmakovy/server-installer/dv-6.3.0.DR3/target/jboss-eap-6.4/modules,/Users/mmakovy/server-installer/dv-6.3.0.DR3/target/jboss-eap-6.4/modules/system/layers/dv,/Users/mmakovy/server-installer/dv-6.3.0.DR3/target/jboss-eap-6.4/modules/system/layers/base/.overlays/layer-base-jboss-eap-6.4.3.CP,/Users/mmakovy/server-installer/dv-6.3.0.DR3/target/jboss-eap-6.4/modules/system/layers/base))]"}}, "rolled-back" : true} > {code} > The whole "test script" should be accessible here: https://mojo.redhat.com/docs/DOC-995324 > This happens *only with DV-6.3.0.DR3*. When I deploy this war to DV 6.2 server, everything works as expected. > I attached project in zip file (Untitled.zip) and generated WAR. The WAR file was generated in TD 10.0.0.Beta2, but I tried to generate the war in 9.0.5 Designer and the result was the same. > I marked this as Critical, but if it is a Designer issue I think it should be marked as blocker. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4110) Odata - date functions does't accept date string as a parameter

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4110?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4110: ------------------------------------------------ Juraj Duráni <jdurani(a)redhat.com> changed the Status of [bug 1322536|https://bugzilla.redhat.com/show_bug.cgi?id=1322536] from ON_QA to VERIFIED > Odata - date functions does't accept date string as a parameter > --------------------------------------------------------------- > > Key: TEIID-4110 > URL: https://issues.jboss.org/browse/TEIID-4110 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Michal Sanitrak > Assignee: Ramesh Reddy > Fix For: 9.0, 8.12.5 > > > Date functions year, month, day, hour, minute and second doesn't accept date string(DateTimeOffset) as a parameter. > Reference service which supports OData V4: > *ULR:* http://services.odata.org/V4/Northwind/Northwind.svc/Employees/?$filter=m... eq EmployeeID > *Result:* Employee with ID 1 > *URL:* http://localhost:8080/odata4/olingo_basic/Source/SimpleDataTable/?$filter... eq intkey > *Result:* {"error": {"code": null, "message": "TEIID30069 The function 'MONTH(?)' has more than one possible signature." }} > *Expected result:* Entity with intkey 1 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4103) OData - wrong string indexing in string functions indexof and substring

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4103?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4103: ------------------------------------------------ Juraj Duráni <jdurani(a)redhat.com> changed the Status of [bug 1320535|https://bugzilla.redhat.com/show_bug.cgi?id=1320535] from ON_QA to VERIFIED > OData - wrong string indexing in string functions indexof and substring > ------------------------------------------------------------------------ > > Key: TEIID-4103 > URL: https://issues.jboss.org/browse/TEIID-4103 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Michal Sanitrak > Assignee: Ramesh Reddy > Labels: Alpha3 > Fix For: 9.0, 8.12.5 > > > By documentation \[1\] function indexof returns the zero-based character position of the first occurrence of the second parameter value in the first parameter value. > Function substring doens't have explicitly specified indexing, but based on _Example 60_ \[2\] is function substring _zero-based_ too. > *indexof* > Reference service which supports OData V4: > *ULR:* http://services.odata.org/V4/Northwind/Northwind.svc/Customers/?$filter=i...,'lfreds') eq 1 > *Result:* Customer with CompanyName equals "Alfreds Futterkiste" > *URL:* http://localhost:8080/odata4/olingo_basic/Source/SimpleDataTable/?$filter...,'alue') eq 1 > *Result:* No entities > *Expected result:* Entity with intkey 1,2,3,4,8,9,10,11,12 > *substring* > Reference service which supports OData V4: > *URL:* http://services.odata.org/V4/Northwind/Northwind.svc/Customers/?$filter=i...,'lfreds') eq 1 > *Result:* Customer with CompanyName equals "Alfreds Futterkiste" > *ULR:* http://localhost:8080/odata4/olingo_basic/Source/SimpleDataTable/?$filter..., 1) eq 'alue_asdf' > *Result:* No entities > *Expected result:* Entity with intkey 10 > \[1\] https://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/part2-u... > \[2\] https://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/part2-u... -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4087) OData - Math function round doesn't accept decimal number as parameter

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4087?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4087: ------------------------------------------------ Juraj Duráni <jdurani(a)redhat.com> changed the Status of [bug 1318435|https://bugzilla.redhat.com/show_bug.cgi?id=1318435] from ON_QA to VERIFIED > OData - Math function round doesn't accept decimal number as parameter > ---------------------------------------------------------------------- > > Key: TEIID-4087 > URL: https://issues.jboss.org/browse/TEIID-4087 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Michal Sanitrak > Assignee: Ramesh Reddy > Labels: Alpha3 > Fix For: 9.0, 8.12.5 > > > Reference service which supports OData V4: > *ULR:* http://services.odata.org/V4/Northwind/Northwind.svc/Employees/?$filter=E... > *Result:* Employee with ID 4 > *URL:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/?$filter... > *Actual result:* {"error": {"code": null, "message": "TEIID30558 Error converting parameter number 1 with value \"4,2\" of class java.math.BigDecimal to expected type integer." }} > *Expected result:* Entity with intkey 4 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4086) OData - Math functions floor and ceiling doesn't accept number as parameter

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4086?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4086: ------------------------------------------------ Juraj Duráni <jdurani(a)redhat.com> changed the Status of [bug 1318434|https://bugzilla.redhat.com/show_bug.cgi?id=1318434] from ON_QA to VERIFIED > OData - Math functions floor and ceiling doesn't accept number as parameter > --------------------------------------------------------------------------- > > Key: TEIID-4086 > URL: https://issues.jboss.org/browse/TEIID-4086 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Michal Sanitrak > Assignee: Ramesh Reddy > Labels: Alpha3 > Fix For: 9.0, 8.12.5 > > > Basic functionality of math functions floor and ceiling works properly as \[1\] describes, but these functions doesn't accept number as parameter. > Reference service which supports OData V4: > *ULR:* http://services.odata.org/V4/Northwind/Northwind.svc/Employees/?$filter=E... > *Result:* Employee with ID 4 > *ULR:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/?$filter... > *Actual result:* {"error":{"code": null, "message": "TEIID30069 The function 'FLOOR(\?)' has more than one possible signature."}} > *Expected result:* Entity with intkey 4 > *ULR:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/?$filter... > *Actual result:* {"error": {"code": null, "message": "TEIID30069 The function 'CEILING(\?)' has more than one possible signature."}} > *Expected result:* Entity with intkey 5 > See [\[OData-ABNF\]|http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/abnf/odata-abnf-construction-rules.txt] _Line:_ 539 - Math functions accepts _commonExpr_ > \[1\] http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/part2-ur... -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4085) OData doesn't support mulitiple usage of arithmetic operators

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4085?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4085: ------------------------------------------------ Juraj Duráni <jdurani(a)redhat.com> changed the Status of [bug 1318433|https://bugzilla.redhat.com/show_bug.cgi?id=1318433] from ON_QA to VERIFIED > OData doesn't support mulitiple usage of arithmetic operators > -------------------------------------------------------------- > > Key: TEIID-4085 > URL: https://issues.jboss.org/browse/TEIID-4085 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Michal Sanitrak > Assignee: Ramesh Reddy > Fix For: 9.0, 8.12.5 > > > Cannot use more than one arithmetic operator in single OData query. Each arithmetic operator has same problem: add,sub,mul,div and mod. > *URL:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/?$filter... > *Actual result:* {"error":{"code": null,"message": "TEIID30067 Type was null for (? + ?) in function ((? + ?) + ?)"}} > *Expected result:* Entity with intkey 7 > See: [\[OData-ABNF\]|http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/abnf/odata-abnf-construction-rules.txt] _Line:_ 384 and 561 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4082) OData - null literal is not supported

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4082?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4082: ------------------------------------------------ Juraj Duráni <jdurani(a)redhat.com> changed the Status of [bug 1318432|https://bugzilla.redhat.com/show_bug.cgi?id=1318432] from ON_QA to VERIFIED > OData - null literal is not supported > ------------------------------------- > > Key: TEIID-4082 > URL: https://issues.jboss.org/browse/TEIID-4082 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Michal Sanitrak > Assignee: Ramesh Reddy > Fix For: 9.0, 8.12.5 > > > *URL:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/?$filter... > *Actual result:* {"error":{"code": null,"message": "OData Library: An exception without message text was thrown."}} > *Expected result:* Return all entities where stringval equals _null_ > See: http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/part1-pr... > http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/part2-ur... -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3686) OData DELETE nonexisting row - wrong response code

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3686?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3686: ------------------------------------------------ Juraj Duráni <jdurani(a)redhat.com> changed the Status of [bug 1266539|https://bugzilla.redhat.com/show_bug.cgi?id=1266539] from ON_QA to ASSIGNED > OData DELETE nonexisting row - wrong response code > -------------------------------------------------- > > Key: TEIID-3686 > URL: https://issues.jboss.org/browse/TEIID-3686 > Project: Teiid > Issue Type: Bug > Components: OData > Affects Versions: 8.7.1.6_2 > Reporter: Michal Sanitrak > Assignee: Ramesh Reddy > Labels: CR1 > Fix For: 8.12, 8.7.2.6_2 > > > I deployed VDB that can be accessed with OData. When I perform DELETE request to remove row for first time response code is 200 OK (maybe it should be 204) but when I repeat the same DELETE request and tried to delete already deleted entry, response is again 200 OK, but it should be 404 Not Found. Same thing happens even I when tried to delete entry with id that doesn't exist at all. > Only indication of this problem is in the server log: > {code:plain}INFO [org.teiid.ODATA] (http-/127.0.0.1:8080-1) no entity to delete in = BooksMySQL.BOOKS with key= ('1') > {code} > I think that response code for deleting row that doesn't exist should be different than 200 OK. > For example the service at odata.org returns following content with response code 404 Not Found: > {code:xml} > <?xml version="1.0" encoding="utf-8" standalone="yes"?> > <error xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata"> > <code></code> > <message xml:lang="en-US">Resource not found for the segment 'Products'.</message> > </error> > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 4 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues June 2016