[teiid-issues] [JBoss JIRA] (TEIID-5856) Teiid generate wrong request to salesforce
Renat Eskenin (Jira)
issues at jboss.org
Tue Nov 26 09:19:01 EST 2019
[ https://issues.jboss.org/browse/TEIID-5856?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13817992#comment-13817992 ]
Renat Eskenin edited comment on TEIID-5856 at 11/26/19 9:18 AM:
----------------------------------------------------------------
del
was (Author: i3draven):
I try to use import stats
{code}
<?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 ("resource-name" 'salesforce'); CREATE SCHEMA sf SERVER salesforce; IMPORT FROM SERVER salesforce INTO sf OPTIONS("importer.useFullSchemaName" 'false', "importer.NormalizeNames" 'false', "import.modelAuditFields" 'true', "import.importStatstics" '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>
{code}
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)
More information about the teiid-issues
mailing list