[teiid-issues] [JBoss JIRA] (TEIID-5856) Teiid generate wrong request to salesforce

[Renat Eskenin (Jira)]

     [ https://issues.jboss.org/browse/TEIID-5856?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Renat Eskenin reopened TEIID-5856:
----------------------------------


I try to use import stats

<?xml version="1.0" encoding="UTF-8"?>
<vdb name="db" version="1">
  <connection-type>BY_VERSION</connection-type>
  <property name="full-ddl" value="CREATE DATABASE db; USE DATABASE db; CREATE FOREIGN DATA WRAPPER salesforce; CREATE FOREIGN DATA WRAPPER mysalesforce type salesforce OPTIONS (supportsOrderBy true); CREATE SERVER salesforce FOREIGN DATA WRAPPER salesforce OPTIONS (&quot;resource-name&quot; 'salesforce'); CREATE SCHEMA sf SERVER salesforce; IMPORT FROM SERVER salesforce INTO sf OPTIONS(&quot;importer.useFullSchemaName&quot; 'false', &quot;importer.NormalizeNames&quot; 'false', &quot;import.modelAuditFields&quot; 'true', &quot;import.importStatstics&quot; 'true');"/>
  <model name="sf" type="PHYSICAL" visible="true">
    <source connection-jndi-name="salesforce" name="salesforce" translator-name="salesforce"/>
    <metadata type="DDL"/>
  </model>
  <translator name="mysalesforce" type="salesforce">
    <property name="supportsOrderBy" value="true"/>
  </translator>
</vdb>

But it has no effect, may be i used wrong params?
And for another solution please give me example of using OPTIONS for this request.


> Teiid generate wrong request to salesforce
> ------------------------------------------
>
>                 Key: TEIID-5856
>                 URL: https://issues.jboss.org/browse/TEIID-5856
>             Project: Teiid
>          Issue Type: Bug
>          Components: Salesforce Connector
>         Environment: spring-boot teiid salesforce-connector
>            Reporter: Renat Eskenin
>            Assignee: Steven Hawkins
>            Priority: Major
>
> When i call request to salesforce teiid get very long wrong request and then OOM, because teiid request all data in salesforce object.



--
This message was sent by Atlassian Jira
(v7.13.8#713008)