]
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.