[JBoss JIRA] (TEIID-2159) Provide language objects to produce a JSON document
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2159?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-2159.
-----------------------------------
Resolution: Done
Added and documented jsonParse, jsonObject, jsonArray, jsonArray_Agg. Also logged TEIID-2390 to improve document generation performance.
> Provide language objects to produce a JSON document
> ---------------------------------------------------
>
> Key: TEIID-2159
> URL: https://issues.jboss.org/browse/TEIID-2159
> Project: Teiid
> Issue Type: Feature Request
> Components: Query Engine
> Reporter: Ramesh Reddy
> Assignee: Steven Hawkins
> Fix For: 8.3
>
>
> SQLXML is standard that lets users define XML constructs to define a XML documents using SQL. However there is such standard exists for producing the JSON based documents.
> It would be nice if Teiid provides such SQL language extensions produce and deal with JSON documents. The constructs equivalent from SQLXML are
> JsonParse
> JsonObject
> JsonArray
> JsonForrest
> JsonAgg
--
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
11 years, 11 months
[JBoss JIRA] (TEIID-2248) Implement Salesforce Bulk API for inserts/updates to Salesforce Connector
by Ramesh Reddy (JIRA)
[ 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
11 years, 11 months
[JBoss JIRA] (TEIID-2389) jsonToXml may loose numerical precision
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2389?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-2389:
---------------------------------------
As long as we want to support the xml conversion case, we'll want an event based/pull parser approach. Whatever minimal dependency can provide that, I'm fine with using. The fork/google parser are quite minimalistic mainly because we don't need pojo mapping or other more complicated support.
> jsonToXml may loose numerical precision
> ---------------------------------------
>
> Key: TEIID-2389
> URL: https://issues.jboss.org/browse/TEIID-2389
> Project: Teiid
> Issue Type: Feature Request
> Components: Query Engine
> Affects Versions: 7.2
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 8.3
>
>
> The json simple parser will parse all numeric values as doubles, which may loose precision.
--
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
11 years, 11 months