[teiid-issues] [JBoss JIRA] Resolved: (TEIID-1388) Appears to be a limit of only one functional SalesForce connector in Teiid at a time.

[Ramesh Reddy (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-1388?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ramesh Reddy resolved TEIID-1388.
---------------------------------

      Assignee: Ramesh Reddy  (was: John Doyle)
    Resolution: Done


The commited changes make use of user supplied URL from ds.xml as the endpoint. If in case user did not supply the endpoint then a default endpoint is defined in the "ra.xml" will be used. 

Also, cleaned up some unused properties and added "isAlive"  method to the connection object to actually check if the connection is alive to be used by management tools.

> Appears to be a limit of only one functional SalesForce connector in Teiid at a time.
> -------------------------------------------------------------------------------------
>
>                 Key: TEIID-1388
>                 URL: https://issues.jboss.org/browse/TEIID-1388
>             Project: Teiid
>          Issue Type: Bug
>          Components: Salesforce Connector
>    Affects Versions: 7.1.1
>         Environment: Teiid 7.1.1 in EDS ER5, JBDS Beta2, RHEL 5.1
>            Reporter: John Doyle
>            Assignee: Ramesh Reddy
>            Priority: Blocker
>             Fix For: 7.1.1
>
>         Attachments: SFTest.java
>
>
> It appears they only one SalesForce connector can be run at a time.  If you preview a model from Designer and there are no SF connections in Teiid, it works.  When you create a DS for the VDB and deploy, the VDB cannot get connections from SalesForce.  If you delete the preview VDB and Datasource, then the deployed VDB begins working.
> I originally suspected that the problem might be that we are running out of connections; SalesForce limits you to 5 simultaneous connections per username/password.  But I deployed the two DataSources with different credentials, and the result did not change.  Need to investigate more.
> Think that we do need to default the SF DS to a pool of 1 and then doc that it should be bumped to 5 for production.  The current default is 10, and that should never be.  Even 5 will exhaust the limit with just a preview connection.

-- 
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira