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

[John Doyle (JIRA)]

    [ https://jira.jboss.org/jira/browse/TEIID-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12499534#action_12499534 ] 

John Doyle commented on TEIID-896:
----------------------------------

I couldn't test this with the SQL in the description, because isDeleted cannot be set, it's an internal variable.  The SQL below can be used to validate the fix.

INSERT INTO Account(Name, Type, ParentId, BillingStreet, BillingCity, BillingState, BillingPostalCode, BillingCountry, NumberOfEmployees) VALUES ("MyTest","Customer","","123 Street","City","MO","66688","USA", 100)

> 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
>             Fix For: 7.0
>
>
> 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