Oracle: mybatis error when inserting null values

Description

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:

  • org.alfresco.enterprise.repo.queryaccelerator.dao.RqaDAOImplTest#populate

  • org.alfresco.enterprise.repo.queryaccelerator.QueryAcceleratorITSuite

Environment

None

Activity

Show:
Bruno Bossola
2 days ago
Edited

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:

Done

Assignee

Unassigned

Reporter

Adina Ababei

Labels

None

Regression

None

Bug Priority

Category 2

Delivery Team

Team 5

Release Train

Iver

Sprint

None

Affects versions