The integer values stored as NULL in backing store is returned as 0 (zero)
book
Article ID: KB0089490
calendar_today
Updated On:
Products
Versions
TIBCO BusinessEvents Enterprise Edition
-
Not Applicable
-
Description
Resolution: Description: ========== The integer values stored as NULL in backing store is returned as 0. Do we have any solution to get the NULL integer concept property as NULL?
Environment: ========== TIBCO BusinessEvent 3.0.2 SQL Server 2008
Symptoms: ========= Concept Tree has attribute leaves as integer.
- Set the leaves with NULL value (leave this value empty when creating the concept in the xslt mapper) - Print the leaves' value with tree.leaves. It will be 0 . - Check the leaves value from the database. The value will be NULL .
The NULL integer value is converted to 0 when extracting with tree.leaves.
Cause: ====== This is an expected behavior as the integer value cannot be NULL. The value of the NULL concept integer property will be extracted as 0.
Resolution: ========= The 'isSet' flag could help to determine if the 0 integer property is NULL.
Each property has an 'isSet' flag. If an object is loading from backing store, this flag is set accordingly based on if the value is NULL or not in the db.
When isSet is false, it means the value is NULL.
The isSet flag is accessd as following: tree.leaves@isSet
Issue/Introduction
The integer values stored as NULL in backing store is returned as 0 (zero)