]
Renat Eskenin closed TEIID-6037.
--------------------------------
Resolution: Not a Bug
Cannot start translator salesforce-41
-------------------------------------
Key: TEIID-6037
URL:
https://issues.redhat.com/browse/TEIID-6037
Project: Teiid
Issue Type: Bug
Components: Salesforce Connector
Affects Versions: 15.0
Reporter: Renat Eskenin
Assignee: Steven Hawkins
Priority: Major
I try to use wildfly+teiid and get strange exception
1. Download wildfly-teiid-server V15 (last released)
2. Add resource adapter to standalone config
{code}
<resource-adapter id="salesforcefour">
<module slot="main"
id="org.jboss.teiid.resource-adapter.salesforce-41"/>
<connection-definitions>
<connection-definition
class-name="org.teiid.resource.adapter.salesforce.SalesForceManagedConnectionFactory"
jndi-name="java:/sfDS41" enabled="true" connectable="true"
use-java-context="true" pool-name="sfDS41">
<config-property
name="connectTimeout">30000</config-property>
<config-property
name="password">ppp</config-property>
<config-property
name="URL">https://test.salesforce.com/services/Soap/u/45.0&...
<config-property
name="requestTimeout">120000</config-property>
<config-property
name="username">uuu</config-property>
</connection-definition>
</connection-definitions>
</resource-adapter>
{code}
3. Start the server by command ./bin/standalone.sh -c=standalone-teiid.xml
4. Try to deploy ddl
{code}
CREATE DATABASE db;
USE DATABASE db;
CREATE FOREIGN DATA WRAPPER salesforce;
CREATE SERVER salesforce FOREIGN DATA WRAPPER salesforce OPTIONS
("resource-name" 'sfDS41');
CREATE SCHEMA salesforce SERVER salesforce;
IMPORT FROM SERVER salesforce INTO salesforce
OPTIONS("importer.useFullSchemaName" 'false',
"importer.NormalizeNames" 'false', "importer.modelAuditFields"
'true', "importer.importStatstics" 'true');
{code}
I tried use some other wrapper names in DDL, as salesforce-41, salesforce-34, but get the
error of parsing DDL
{code}
{"jboss.deployment.unit.\"sf-vdb.ddl\".PARSE" =>
"WFLYSRV0153: Failed to process phase PARSE of deployment \"sf-vdb.ddl\"
Caused by: org.teiid.metadata.ParseException: TEIID30386
org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered
\"DATA WRAPPER salesforce[*]-[*]41;\" at line 3, column 39. Was expecting:
<EOF> | \"options\" | \"type\" | \"handler\" |
\";\" Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100
Parsing error: Encountered \"DATA WRAPPER salesforce[*]-[*]41;\" at line 3,
column 39. Was expecting: <EOF> | \"options\" | \"type\" |
\"handler\" | \";\""}}
{code}
5. Got the exception
{code}
17:54:14,450 ERROR [org.teiid.RUNTIME] (Worker3) TEIID30021 Uncaught exception
processing work: java.lang.ClassCastException: class
org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl cannot be cast to class
org.teiid.translator.salesforce.SalesforceConnection
(org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl is in unnamed module of
loader 'org.jboss.teiid.resource-adapter.salesforce-41(a)15.0.0' @4fc75d56;
org.teiid.translator.salesforce.SalesforceConnection is in unnamed module of loader
'org.jboss.teiid.translator.salesforce(a)15.0.0' @549eaee5)
at
org.jboss.teiid.translator.salesforce@15.0.0//org.teiid.translator.salesforce.SalesForceMetadataProcessor.process(SalesForceMetadataProcessor.java:56)
at
org.jboss.teiid.api@15.0.0//org.teiid.translator.ExecutionFactory.getMetadata(ExecutionFactory.java:989)
at
org.jboss.teiid@15.0.0//org.teiid.query.metadata.NativeMetadataRepository.getMetadata(NativeMetadataRepository.java:89)
at
org.jboss.teiid@15.0.0//org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:55)
{code}