Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Server
    • Labels:
      None
    • Steps to Reproduce:
      Hide

      1. Setup wildfly-teiid-server
      2. Add resource adapter to standalone-teiid.xml

                      <resource-adapter id="salesforcefour" statistics-enabled="true">
                          <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">fff</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">fff</config-property>
                              </connection-definition>
                          </connection-definitions>
                      </resource-adapter>
      

      3. add-user.sh -> to add new admin user in wildfly
      6. Start server

      7. Deploy DDL

      CREATE DATABASE saleforce;
      USE DATABASE saleforce;
      CREATE SERVER salesforcesrv FOREIGN DATA WRAPPER "salesforce-41" OPTIONS (supportsOrderBy true, "resource-name" 'java:/sfDS41');
      CREATE SCHEMA salesforce SERVER salesforcesrv;
      IMPORT FROM SERVER salesforcesrv INTO salesforce OPTIONS("importer.useFullSchemaName" 'false', "importer.NormalizeNames" 'false', "importer.modelAuditFields" 'true', "importer.importStatstics" 'true');
      

      7. Open WebAdminConsole at "http://localhost:9990/console/App.html#resource-adapters" -> Configuration: Subsystems Subsystem: Resource Adapters Resource Adapter: salesforcefour
      8. Open Pool settings
      9. Try to set min pool size

      Show
      1. Setup wildfly-teiid-server 2. Add resource adapter to standalone-teiid.xml <resource-adapter id= "salesforcefour" statistics-enabled= " true " > <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" >fff</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" >fff</config-property> </connection-definition> </connection-definitions> </resource-adapter> 3. add-user.sh -> to add new admin user in wildfly 6. Start server 7. Deploy DDL CREATE DATABASE saleforce; USE DATABASE saleforce; CREATE SERVER salesforcesrv FOREIGN DATA WRAPPER "salesforce-41" OPTIONS (supportsOrderBy true , "resource-name" 'java:/sfDS41' ); CREATE SCHEMA salesforce SERVER salesforcesrv; IMPORT FROM SERVER salesforcesrv INTO salesforce OPTIONS( "importer.useFullSchemaName" ' false ' , "importer.NormalizeNames" ' false ' , "importer.modelAuditFields" ' true ' , "importer.importStatstics" ' true ' ); 7. Open WebAdminConsole at "http://localhost:9990/console/App.html#resource-adapters" -> Configuration: Subsystems Subsystem: Resource Adapters Resource Adapter: salesforcefour 8. Open Pool settings 9. Try to set min pool size

      Description

      Hi! I tried to make VDB to salesforce with wildfly-teiid-server. Bit when I set connection pool attributes i get error

      Failed to modify resource [ ("subsystem" => "resource-adapters"), ("resource-adapter" => "salesforcefour"), ("connection-definitions" => "sfDS41") ]
      
      Request
      {
          "operation" => "composite",
          "address" => [],
          "steps" => [{
              "address" => [
                  ("subsystem" => "resource-adapters"),
                  ("resource-adapter" => "salesforcefour"),
                  ("connection-definitions" => "sfDS41")
              ],
              "operation" => "write-attribute",
              "name" => "min-pool-size",
              "value" => 1
          }]
      }
      
      Response
      
      Internal Server Error
      {
          "outcome" => "failed",
          "result" => {"step-1" => {
              "outcome" => "failed",
              "failure-description" => "WFLYJCA0045: failed to set attribute: Index 0 out of bounds for length 0",
              "rolled-back" => true
          }},
          "failure-description" => {"WFLYCTL0062: Composite operation failed and was rolled back. Steps that failed:" => {"Operation step-1" => "WFLYJCA0045: failed to set attribute: Index 0 out of bounds for length 0"}},
          "rolled-back" => true
      }
      

        Gliffy Diagrams

          Attachments

            Activity

              People

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

                Dates

                • Created:
                  Updated: