[teiid-issues] [JBoss JIRA] Commented: (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:comment-tabpanel&focusedCommentId=12569485#comment-12569485 ] 

Ramesh Reddy commented on TEIID-1388:
-------------------------------------

According to the test attached at least in the demo/developer Salesforce connections, SF only grant at most one "session" at any given time. Yes, you can call "login" as many times, but it will return the same session-id, whether it is from same VM or different VMs. However, once you call the "logout" all the connections which are of the same session are closed. So, it may not appropriate actually do a "logout " of a session any time from the connection pool as it will invalidate all the connection objects. Luckily Teiid is not doing any "logout"  right now, so we need keep this way.

Now, to the actual problem of not creating more than single connection, and why it is working in 7.2 and not in SOA. The variable here is CXF

7.2 - CXF may not be in use, and default JAX-WS in use, this one uses the default endpoint from Service class, that is in the WSDL.

SOA - CXF is in use, first time the endpoint is correctly set from the WSDL, however after that it set to default location, that will resolve to "127.0.0.1:8443" that will fail to make connection.

Resolution: Set the end point on port binding from user configuration. User is already been asked to supply the endpoint but it was not being used. Like

((BindingProvider)sfSoap).getRequestContext().put(BindingProvider.ENDPOINT_ADDRESS_PROPERTY, "https://www.salesforce.com/services/Soap/u/17.0");

then issue login.

> 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: John Doyle
>            Priority: Blocker
>
> 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