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

[Steven Hawkins (Jira)]

    [ https://issues.jboss.org/browse/TEIID-5856?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13818014#comment-13818014 ] 

Steven Hawkins commented on TEIID-5856:
---------------------------------------

> But it has no effect, may be i used wrong params?

That is an odd mixture of a ddl and xml vdb.  It should instead be:

{code}
<vdb name="db" version="1">
  <connection-type>BY_VERSION</connection-type>
  <model name="sf" type="PHYSICAL" visible="true">
    <property name="importer.useFullSchemaName" value="false"/>
    <property name="importer.NormalizeNames" value="false"/>
    <property name="importer.modelAuditFields" value="true"/>
    <property name="importer.importStatstics" value="true"/>
    <source connection-jndi-name="salesforce" name="salesforce" translator-name="mysalesforce"/>
  </model>
  <translator name="mysalesforce" type="salesforce">
    <property name="supportsOrderBy" value="true"/>
  </translator>
</vdb>
{code}

You can double check the if the stats are set by looking at the cardinality column on SYS.tables.

> And for another solution please give me example of using OPTIONS for this request.

There's also using hints inline http://teiid.github.io/teiid-documents/master/content/reference/FROM_Clause.html 

{code}
SELECT originalLicense.Id,originalLicense.Status__c,originalLicense.ReplacementLicenseID__c,originalLicense.LicenseId__c,originalLicense.vlic_Contract_Number__c,replacementLicense.LicenseId__c as replacementLicenseId ,replacementLicense.Id as replacementLicenseObjectId FROM Product_License__c originalLicense LEFT OUTER JOIN  /*+ MAKEDEP */ Product_License__c replacementLicense ON originalLicense.ReplacementLicenseID__c = replacementLicense.Id where originalLicense.vlic_Contract_Number__c = :contractNumber
{code}

> 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)