Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-6037

Cannot start translator salesforce-41

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Not a Bug
    • Affects Version/s: 15.0
    • Fix Version/s: None
    • Component/s: Salesforce Connector
    • Labels:
      None

      Description

      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

                      <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>
                                  <config-property name="requestTimeout">120000</config-property>
                                  <config-property name="username">uuu</config-property>
                              </connection-definition>
                          </connection-definitions>
                      </resource-adapter>
      

      3. Start the server by command ./bin/standalone.sh -c=standalone-teiid.xml
      4. Try to deploy ddl

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

      I tried use some other wrapper names in DDL, as salesforce-41, salesforce-34, but get the error of parsing DDL

      {"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\" | \";\""}}
      

      5. Got the exception

      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@15.0.0' @4fc75d56; org.teiid.translator.salesforce.SalesforceConnection is in unnamed module of loader 'org.jboss.teiid.translator.salesforce@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)
      

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                i3draven Renat Eskenin
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: