[teiid-issues] [JBoss JIRA] (TEIID-3533) Infinispan-dsl-cache translator: can't insert value into BYTE and BIGINTEGER columns

[Van Halbert (JIRA)]

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

Van Halbert commented on TEIID-3533:
------------------------------------

There were several issues here:

-  the model that was used didn't correspond to what was created when using the Teiid Connection Importer, which had data types on the source model mis-aligned.
-  the logic needed to use DataTypeManager.transformValue to handle to help in broader conversion cases.
-  and another issue was encountered (when the above was resolved) in that the JDG confirmed it has an issue with boolean columns.  JDG will throw an exception if no value is specified in the insert or there's no default defined in the protobuf definition.  

> Infinispan-dsl-cache translator: can't insert value into BYTE and BIGINTEGER columns
> ------------------------------------------------------------------------------------
>
>                 Key: TEIID-3533
>                 URL: https://issues.jboss.org/browse/TEIID-3533
>             Project: Teiid
>          Issue Type: Bug
>          Components: Misc. Connectors
>    Affects Versions: 8.7.1.6_2
>            Reporter: Filip Elias
>            Assignee: Van Halbert
>             Fix For: 8.7.1.6_2, 8.12, 8.11.1
>
>         Attachments: server.log, testVDB.vdb
>
>
> Sample query:
> {code}
> insert into smalla(intKey, byteNum) values(100,100);
> insert into smalla(intKey, BIGINTEGERVALUE) values(100,100);
> {code}
> Exception:
> {code}
> [org.teiid.CONNECTOR] (Worker9_QueryProcessorQueue59) Connector worker process failed for atomic-request=NuZ8Nt3h1bKx.20.0.13: java.lang.IllegalArgumentException: Conversion from String to java.math.BigDecimal is not supported
> 	at org.teiid.core.util.StringUtil.valueOf(StringUtil.java:797) [teiid-common-core-8.7.1.6_2-redhat-2.jar:8.7.1.6_2-redhat-2]
> 	at org.teiid.core.util.PropertiesUtils.setProperty(PropertiesUtils.java:792) [teiid-common-core-8.7.1.6_2-redhat-2.jar:8.7.1.6_2-redhat-2]
> 	at org.teiid.core.util.PropertiesUtils.setBeanProperty(PropertiesUtils.java:782) [teiid-common-core-8.7.1.6_2-redhat-2.jar:8.7.1.6_2-redhat-2]
> 	at org.teiid.translator.infinispan.dsl.InfinispanUpdateExecution.handleInsert(InfinispanUpdateExecution.java:204)
> {code}
> The VDB and the server log is attached.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)