[
https://issues.jboss.org/browse/TEIIDDES-1906?page=com.atlassian.jira.plu...
]
Ramesh Reddy commented on TEIIDDES-1906:
----------------------------------------
you said you created a VDB, when you add the source model in the VDB explorer, then in the
"Source Bindings" tab, you can set the translator name and jndi name of the
connection. You need to make sure they both are set correctly.
Execute VDB fails for Salesforce model
--------------------------------------
Key: TEIIDDES-1906
URL:
https://issues.jboss.org/browse/TEIIDDES-1906
Project: Teiid Designer
Issue Type: Bug
Affects Versions: 8.2
Environment: Teiid Designer 8.2.0Final, JBDS 7, java 1.7 oracle, server DV
6.0.ER2 with teiid 8.4
Reporter: Lucie Fabrikova
1. create a source model by importing from testing Salesforce account; preview data of
one table (Modeling -> Preview data) - this works (select * from
"sf"."salesforce"."Account")
2. create a VDB with the source model; deploy, execute (use the same sql query) - this
results in a error:
org.teiid.resource.adapter.file.FileConnectionImpl cannot be cast to
org.teiid.translator.salesforce.SalesforceConnection
Console output:
13:46:09,114 ERROR [org.teiid.CONNECTOR] (Worker5_QueryProcessorQueue18) Connector worker
process failed for atomic-request=oZbg6bQY7MUO.0.0.5: java.lang.ClassCastException:
org.teiid.resource.adapter.file.FileConnectionImpl cannot be cast to
org.teiid.translator.salesforce.SalesforceConnection
at
org.teiid.translator.salesforce.SalesForceExecutionFactory.createResultSetExecution(SalesForceExecutionFactory.java:60)
at org.teiid.translator.ExecutionFactory.createExecution(ExecutionFactory.java:304)
[teiid-api-8.4.1-redhat-2.jar:8.4.1-redhat-2]
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:245)
[teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
at
org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:444)
[teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
at
org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:157)
[teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
at
org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:154)
[teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) [rt.jar:1.7.0_25]
at java.util.concurrent.FutureTask.run(FutureTask.java:166) [rt.jar:1.7.0_25]
at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58)
[teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269)
[teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
[teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214)
[teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
[rt.jar:1.7.0_25]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
[rt.jar:1.7.0_25]
at java.lang.Thread.run(Thread.java:724) [rt.jar:1.7.0_25]
13:46:09,116 ERROR [org.teiid.PROCESSOR] (Worker4_QueryProcessorQueue19) TEIID30019
Unexpected exception for request oZbg6bQY7MUO.0: java.lang.ClassCastException:
org.teiid.resource.adapter.file.FileConnectionImpl cannot be cast to
org.teiid.translator.salesforce.SalesforceConnection
at
org.teiid.translator.salesforce.SalesForceExecutionFactory.createResultSetExecution(SalesForceExecutionFactory.java:60)
at org.teiid.translator.ExecutionFactory.createExecution(ExecutionFactory.java:304)
[teiid-api-8.4.1-redhat-2.jar:8.4.1-redhat-2]
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:245)
[teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
at
org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:444)
[teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
at
org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:157)
[teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
at
org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:154)
[teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) [rt.jar:1.7.0_25]
at java.util.concurrent.FutureTask.run(FutureTask.java:166) [rt.jar:1.7.0_25]
at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58)
[teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269)
[teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
[teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214)
[teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
[rt.jar:1.7.0_25]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
[rt.jar:1.7.0_25]
at java.lang.Thread.run(Thread.java:724) [rt.jar:1.7.0_25]
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see:
http://www.atlassian.com/software/jira