November 2019 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-5847) Allow translator properties to be set via application.properties

by Steven Hawkins (Jira)

Steven Hawkins created TEIID-5847: ------------------------------------- Summary: Allow translator properties to be set via application.properties Key: TEIID-5847 URL: https://issues.jboss.org/browse/TEIID-5847 Project: Teiid Issue Type: Sub-task Reporter: Steven Hawkins Assignee: Steven Hawkins When using a vdb-less deployment, import/model properties can be set from spring.datasource. or spring.xa.datasource. properties. However translator properties cannot. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5846) top in odata query is not working

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5846?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-5846: --------------------------------------- > May be teiid have programmatically methods to set this property? I had thought application properties would be applicable, but that is not the case. Another issue (spring boot specific) could be spawned for that. > Can i create server in vdb manner as thin wraper around of salesforce auto generated vdb metadata? Yes, the vdb would look like: CREATE DATABASE db ; USE DATABASE db; CREATE FOREIGN DATA WRAPPER salesforce; CREATE SERVER samplesf FOREIGN DATA WRAPPER salesforce OPTIONS ("resource-name" 'samplesf', supportsOrderBy true); CREATE SCHEMA sf SERVER samplesf; IMPORT FROM SERVER samplesf INTO sf OPTIONS("importer.useFullSchemaName" 'false'); > Or may be exists example vdb+salesforce? I don't see a specific example unfortunately. > top in odata query is not working > --------------------------------- > > Key: TEIID-5846 > URL: https://issues.jboss.org/browse/TEIID-5846 > Project: Teiid > Issue Type: Bug > Components: OData, Salesforce Connector > Environment: teiid-spring-boot+spring-odata teiid+spring-data-salesforce > Reporter: Renat Eskenin > Priority: Major > > When we call simple request as > salesforce-odata-facade/odata/salesforce/Product_License__c?$top=1&$select=Id > request processing time is 1min. But this request processing by simple SOAP SOQL request is ~150ms. > I think this do because teiid select all objects by ignoring top in request. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5846) top in odata query is not working

by Renat Eskenin (Jira)

[ https://issues.jboss.org/browse/TEIID-5846?page=com.atlassian.jira.plugin... ] Renat Eskenin edited comment on TEIID-5846 at 11/12/19 4:53 PM: ---------------------------------------------------------------- And other question. Can i create server in vdb manner as thin wraper around of salesforce auto generated vdb metadata? Or may be exists example vdb+salesforce? was (Author: i3draven): And other question. Can i create server in vdb manner as thin wraper around of salesforce auto generated vdb metadata? > top in odata query is not working > --------------------------------- > > Key: TEIID-5846 > URL: https://issues.jboss.org/browse/TEIID-5846 > Project: Teiid > Issue Type: Bug > Components: OData, Salesforce Connector > Environment: teiid-spring-boot+spring-odata teiid+spring-data-salesforce > Reporter: Renat Eskenin > Priority: Major > > When we call simple request as > salesforce-odata-facade/odata/salesforce/Product_License__c?$top=1&$select=Id > request processing time is 1min. But this request processing by simple SOAP SOQL request is ~150ms. > I think this do because teiid select all objects by ignoring top in request. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5846) top in odata query is not working

by Renat Eskenin (Jira)

[ https://issues.jboss.org/browse/TEIID-5846?page=com.atlassian.jira.plugin... ] Renat Eskenin commented on TEIID-5846: -------------------------------------- And other question. Can i create server in vdb manner as thin wraper around of salesforce auto generated vdb metadata? > top in odata query is not working > --------------------------------- > > Key: TEIID-5846 > URL: https://issues.jboss.org/browse/TEIID-5846 > Project: Teiid > Issue Type: Bug > Components: OData, Salesforce Connector > Environment: teiid-spring-boot+spring-odata teiid+spring-data-salesforce > Reporter: Renat Eskenin > Priority: Major > > When we call simple request as > salesforce-odata-facade/odata/salesforce/Product_License__c?$top=1&$select=Id > request processing time is 1min. But this request processing by simple SOAP SOQL request is ~150ms. > I think this do because teiid select all objects by ignoring top in request. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5846) top in odata query is not working

by Renat Eskenin (Jira)

[ https://issues.jboss.org/browse/TEIID-5846?page=com.atlassian.jira.plugin... ] Renat Eskenin commented on TEIID-5846: -------------------------------------- I don't use vdb. Datasource created from spring properties and bean...generated from methadata automatically. May be teiid have programmatically methods to set this property? > top in odata query is not working > --------------------------------- > > Key: TEIID-5846 > URL: https://issues.jboss.org/browse/TEIID-5846 > Project: Teiid > Issue Type: Bug > Components: OData, Salesforce Connector > Environment: teiid-spring-boot+spring-odata teiid+spring-data-salesforce > Reporter: Renat Eskenin > Priority: Major > > When we call simple request as > salesforce-odata-facade/odata/salesforce/Product_License__c?$top=1&$select=Id > request processing time is 1min. But this request processing by simple SOAP SOQL request is ~150ms. > I think this do because teiid select all objects by ignoring top in request. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5846) top in odata query is not working

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5846?page=com.atlassian.jira.plugin... ] Steven Hawkins moved TEIIDSB-135 to TEIID-5846: ----------------------------------------------- Project: Teiid (was: Teiid Spring Boot) Key: TEIID-5846 (was: TEIIDSB-135) Component/s: OData Salesforce Connector (was: OData) Affects Version/s: (was: 1.2.0) > top in odata query is not working > --------------------------------- > > Key: TEIID-5846 > URL: https://issues.jboss.org/browse/TEIID-5846 > Project: Teiid > Issue Type: Bug > Components: OData, Salesforce Connector > Environment: teiid-spring-boot+spring-odata teiid+spring-data-salesforce > Reporter: Renat Eskenin > Priority: Major > > When we call simple request as > salesforce-odata-facade/odata/salesforce/Product_License__c?$top=1&$select=Id > request processing time is 1min. But this request processing by simple SOAP SOQL request is ~150ms. > I think this do because teiid select all objects by ignoring top in request. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIIDSB-135) top in odata query is not working

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIIDSB-135?page=com.atlassian.jira.plugi... ] Steven Hawkins commented on TEIIDSB-135: ---------------------------------------- If you are using a ddl vdb, you can specify the property in the option clause of the create server statement: {code} CREATE SERVER samplesf FOREIGN DATA WRAPPER salesforce OPTIONS ("resource-name" 'samplesf', supportsOrderBy true); {code} Actually it does not appear that you can use application.properties for translator properties. > top in odata query is not working > --------------------------------- > > Key: TEIIDSB-135 > URL: https://issues.jboss.org/browse/TEIIDSB-135 > Project: Teiid Spring Boot > Issue Type: Bug > Components: OData > Affects Versions: 1.2.0 > Environment: teiid-spring-boot+spring-odata teiid+spring-data-salesforce > Reporter: Renat Eskenin > Priority: Major > > When we call simple request as > salesforce-odata-facade/odata/salesforce/Product_License__c?$top=1&$select=Id > request processing time is 1min. But this request processing by simple SOAP SOQL request is ~150ms. > I think this do because teiid select all objects by ignoring top in request. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIIDSB-135) top in odata query is not working

by Renat Eskenin (Jira)

[ https://issues.jboss.org/browse/TEIIDSB-135?page=com.atlassian.jira.plugi... ] Renat Eskenin edited comment on TEIIDSB-135 at 11/12/19 9:34 AM: ----------------------------------------------------------------- Can you write full property example for spring-boot teiid application with supportsOrderBy? was (Author: i3draven): Can you write full property example for spring-boo teiid application with supportsOrderBy? > top in odata query is not working > --------------------------------- > > Key: TEIIDSB-135 > URL: https://issues.jboss.org/browse/TEIIDSB-135 > Project: Teiid Spring Boot > Issue Type: Bug > Components: OData > Affects Versions: 1.2.0 > Environment: teiid-spring-boot+spring-odata teiid+spring-data-salesforce > Reporter: Renat Eskenin > Priority: Major > > When we call simple request as > salesforce-odata-facade/odata/salesforce/Product_License__c?$top=1&$select=Id > request processing time is 1min. But this request processing by simple SOAP SOQL request is ~150ms. > I think this do because teiid select all objects by ignoring top in request. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIIDSB-135) top in odata query is not working

by Renat Eskenin (Jira)

[ https://issues.jboss.org/browse/TEIIDSB-135?page=com.atlassian.jira.plugi... ] Renat Eskenin commented on TEIIDSB-135: --------------------------------------- Can you write full property example for spring-boo teiid application with supportsOrderBy? > top in odata query is not working > --------------------------------- > > Key: TEIIDSB-135 > URL: https://issues.jboss.org/browse/TEIIDSB-135 > Project: Teiid Spring Boot > Issue Type: Bug > Components: OData > Affects Versions: 1.2.0 > Environment: teiid-spring-boot+spring-odata teiid+spring-data-salesforce > Reporter: Renat Eskenin > Priority: Major > > When we call simple request as > salesforce-odata-facade/odata/salesforce/Product_License__c?$top=1&$select=Id > request processing time is 1min. But this request processing by simple SOAP SOQL request is ~150ms. > I think this do because teiid select all objects by ignoring top in request. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5798) Mixed PERMISSION GRANTS

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5798?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-5798: --------------------------------------- The easier foundational issues are now out of the way. With more reflection I'm inclined to either address by expanding upon the single statement approach or by separating out our handling of row based security / masking. The rationale is that it's either the easiest / least breaking change, or it's more consistent with other vendors. Any thoughts / votes? > Mixed PERMISSION GRANTS > ----------------------- > > Key: TEIID-5798 > URL: https://issues.jboss.org/browse/TEIID-5798 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Christoph John > Assignee: Steven Hawkins > Priority: Major > Fix For: 13.0 > > Original Estimate: 6 hours > Remaining Estimate: 6 hours > > Hello, > I am currently trying to set a set of permissions on a table/view. Hence a condition on INSERT,UPDATE,DELETE and an unconditioned SELECT. > However, it seems that conditioned and unconditioned GRANT statements do not work together. > {code} > GRANT INSERT,UPDATE,DELETE ON TABLE "my_nutri_diary.UserDefinedProducts_SRC" CONDITION 'UserDefinedProducts_SRC.fkProfile in (SELECT Account.idProfile FROM Account WHERE Account.uuidUser = LEFT(user(), 36) )' TO odata; > GRANT SELECT ON TABLE "my_nutri_diary.UserDefinedProducts_SRC" TO odata; > REVOKE ALTER,EXECUTE ON TABLE "my_nutri_diary.UserDefinedProducts_SRC" FROM odata; > {code} -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years, 1 month

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues November 2019