Bug 780277 (SOA-2678)

Summary: Appears to be a limit of only one functional SalesForce connector in Teiid at a time.
Product: [JBoss] JBoss Enterprise SOA Platform 5 Reporter: John Doyle <jdoyle>
Component: EDSAssignee: Van Halbert <vhalbert>
Status: CLOSED NEXTRELEASE QA Contact:
Severity: urgent Docs Contact:
Priority: urgent    
Version: 5.1.0.ER5   
Target Milestone: ---   
Target Release: 5.1.0.CR1   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/SOA-2678
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Teiid 7.1.1 in EDS ER5, JBDS Beta2, RHEL 5.1
Last Closed: 2011-02-07 18:49:19 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:

Description John Doyle 2010-12-13 14:51:54 UTC 
Affects: Documentation (Ref Guide, User Guide, etc.)
project_key: SOA

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.
Comment 1 Van Halbert 2010-12-13 14:51:54 UTC 
Link: Added: This issue Cloned from TEIID-1388
Comment 2 Van Halbert 2010-12-13 14:52:34 UTC 
Security: Added: Public
Comment 3 Van Halbert 2010-12-14 15:43:30 UTC 
Teiid has committed the changes and should be in the next build
Comment 4 John Doyle 2011-02-07 18:49:19 UTC 
Validated with SOA ER9 and JBDS jbdevstudio-product-linux-gtk-4.0.0.v201102031426R-H148-CR2.jar