[
https://issues.jboss.org/browse/TEIID-1388?page=com.atlassian.jira.plugin...
]
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