Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1232182

Summary: Infinispan-dsl-cache translator: can't insert value into BYTE and BIGINTEGER columns
Product: [JBoss] JBoss Data Virtualization 6 Reporter: Filip Elias <felias>
Component: TeiidAssignee: Van Halbert <vhalbert>
Status: CLOSED DUPLICATE QA Contact: Filip Elias <felias>
Severity: high Docs Contact:
Priority: unspecified    
Version: 6.2.0CC: atangrin, vhalbert
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2015-07-02 21:11:00 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 1232282    
Attachments:
Description Flags
server log
none
VDB through which data are inserted none

Description Filip Elias 2015-06-16 09:09:11 UTC
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.

Comment 1 Filip Elias 2015-06-16 09:10:27 UTC
Created attachment 1039312 [details]
VDB through which data are inserted

Comment 2 Van Halbert 2015-06-26 18:48:27 UTC
This one requires more work, will try to get this in post ER3.

Comment 3 Van Halbert 2015-07-02 21:07:49 UTC
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.

Comment 4 Van Halbert 2015-07-02 21:11:00 UTC

*** This bug has been marked as a duplicate of bug 1232282 ***