[teiid-issues] [JBoss JIRA] Created: (TEIID-896) INSERT failing with SF connector on types other than a string

[Mark Drilling (JIRA)]

INSERT failing with SF connector on types other than a string
-------------------------------------------------------------

                 Key: TEIID-896
                 URL: https://jira.jboss.org/jira/browse/TEIID-896
             Project: Teiid
          Issue Type: Bug
          Components: Salesforce Connector
            Reporter: Mark Drilling
            Assignee: John Doyle


I am attempting to do an INSERT into salesforce Account table, using the following 

INSERT INTO SFDC.salesforce.Account(IsDeleted, Name, Type, ParentId, BillingStreet, BillingCity, BillingState, BillingPostalCode, BillingCountry) VALUES ({b'false'},"MyTest","Customer","","123 Street","City","MO","66688","USA")

The boolean type IsDeleted is causing failure with ClassCastException as follows:
Caused by: java.lang.ClassCastException: java.lang.Boolean
	at com.metamatrix.connector.salesforce.execution.visitors.InsertVisitor.visit(InsertVisitor.java:44)
	at com.metamatrix.connector.salesforce.execution.InsertExecutionImpl.execute(InsertExecutionImpl.java:15)
	at com.metamatrix.connector.salesforce.execution.UpdateExecutionParent.execute(UpdateExecutionParent.java:67)
	at com.metamatrix.dqp.internal.datamgr.impl.ConnectorWorker.processNewRequest(ConnectorWorker.java:255)

I have tried other types as well with the same result

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira