[teiid-issues] [JBoss JIRA] (TEIID-4402) Insert statement with a date field fails

[J Price (JIRA)]

J Price created TEIID-4402:
------------------------------

             Summary: Insert statement with a date field fails
                 Key: TEIID-4402
                 URL: https://issues.jboss.org/browse/TEIID-4402
             Project: Teiid
          Issue Type: Bug
          Components: Salesforce Connector
    Affects Versions: 9.0.2
         Environment: WildFly Full 9.0.2.Final (WildFly Core 1.0.2.Final) 
Teiid 9.0.2
jdk1.8.0_101
Salesforce sandbox
Salesforce connectors / translators: salesforce and salesforce-34
            Reporter: J Price
            Assignee: Steven Hawkins


I have a custom object created in Salesforce which has date fields. The model has the fields identified as date correctly. When specifying a date using an insert statement I receive an error back from Salesforce:
_
org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidProcessingException: TEIID30504 Sandbox: Start Date: value not of required type: 2016-03-17_

I have tried forcing it to a date using the parsedate function as well as passing it as is.

I setup a proxy to try and identify the cause and found that the datatype being passed in the underlying SOAP request is xsd:string instead of xsd:date.

Using fiddler I duplicated the underlying SOAP request, but changed the types to xsd:date, and resubmitted the request successfully. 



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)