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

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