[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)
6 years, 4 months
[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)
6 years, 4 months
[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)
6 years, 4 months
[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)
6 years, 4 months
[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)
6 years, 4 months
[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)
6 years, 4 months
[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)
6 years, 4 months
[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)
6 years, 4 months