Created attachment 1039310 [details] server log Sample query: insert into smalla(intKey, byteNum) values(100,100); insert into smalla(intKey, BIGINTEGERVALUE) values(100,100); Exception: [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) The VDB and the server log is attached.
Created attachment 1039312 [details] VDB through which data are inserted
This one requires more work, will try to get this in post ER3.
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.
*** This bug has been marked as a duplicate of bug 1232282 ***