[
https://issues.jboss.org/browse/TEIID-2248?page=com.atlassian.jira.plugin...
]
Ramesh Reddy resolved TEIID-2248.
---------------------------------
Resolution: Done
I ended up using the
http://code.google.com/p/sfdc-wsc/ library after all, as it
encapsulated lot of call and parsing details. I removed it's dependencies as Teiid
does not use them.
The Bulk insert is only applicable for INSERT. There is code already for UPDATE and DELETE
based upon multiple IDs. Also Bulk API does not support UPDATE/DELETE.
If there is an error inserting a row into SF, since the communication is ASYNC, there is
no proper way to cancel the bulk job. So, the job continues, and reports which rows that
have been not inserted. All these errors are currently exposed back to client as
SQLWarning. Teiid can throw SQlException but that does not indicate whole job has been
aborted, so I choose to implement as SQLWarning.
Implement Salesforce Bulk API for inserts/updates to Salesforce
Connector
-------------------------------------------------------------------------
Key: TEIID-2248
URL:
https://issues.jboss.org/browse/TEIID-2248
Project: Teiid
Issue Type: Feature Request
Components: Salesforce Connector
Reporter: Marc Shirley
Assignee: Ramesh Reddy
Fix For: 8.3
Wish to utilize the Salesforce Bulk API for large inserts/updates. The specific use case
was for writing/updating a million record table back up to their Salesforce instance.
This will improve performance for large writes to the Salesforce instance.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see:
http://www.atlassian.com/software/jira