When we are inserting null values we are having this error:
One solution is the following setting in rqa-SqlMapConfig.xml:
The issue can be reproduced by running:
The issue here is due to the system trying to insert a NULL value into a field WITHOUT specifying the JDBC type. While most databases deal with it internally, some cough professional databases like SQL Server and Oracle leave this to the user. This specific issue is manifested when trying to insert a NULL in a field declared of type FLOAT.
When node properties are saved in the “normal” tables, their metadata are collected. The item of interest here is the java short type name of such property, which is later used during the SQL operation.For example: