[JBoss JIRA] Created: (TEIID-896) INSERT failing with SF connector on types other than a string
by 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
14 years, 6 months
[JBoss JIRA] Created: (TEIID-1021) Enable better support for mixed database encoding
by Mark Drilling (JIRA)
Enable better support for mixed database encoding
-------------------------------------------------
Key: TEIID-1021
URL: https://jira.jboss.org/jira/browse/TEIID-1021
Project: Teiid
Issue Type: Feature Request
Components: Server
Reporter: Mark Drilling
Assignee: Steven Hawkins
I was working with a Japanese PostGreSQL database - database encoding is SQL_ASCII, but some of the columns have EUC_JP encoded data. I attempted to create a UDF to utilize the PostGreSQL convert(string, sourceEncoding, targetEncoding) function, but had difficulty with that (in the production version 554). Eventually we were able to workaround with other code changes, but handling of this situation may have been easier with a byte data type - logging this JIRA for consideration in teiid.
--
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
14 years, 6 months